Tip Bank

Question: I want to order the output of my query by two fields. Is this possible? That is, if two values are the same, I want the output ordered by

Question: I write a stored procedure and it works fine. But when I do write a “select statement” as below: “select * from sp_name” I get an error message: “Server:

Question: I have a stored procedure that takes a costcenterid (int) as an input parameter. The user wants to search on an unspecified number of costcenters each time. I use

Question: I am developing a database program using Access and Visual Basic. I want to display data in a form where the data comes from two tables. For example, the

Question: Is it possible to create tables in stored procedures using a variable for the table name? For instance: declare @MyNameset @MyName = ‘dbo.Unique_Name’create table @MyName … This obviously doesn’t

Question: I am facing a problem with the following SQL stored procedure: CREATE PROCEDURE usp_CreateAdminUser /*Input Parameters for the Create Admin User */ @FullName varchar(100), @Telephone varchar(50), @Email varchar(50), @Address1

Question: We have to connect VFP to SQL Server, and we have a lot of non-structural index files for tables. We’ve created remote views for the tables and need to

Question: I would like to create a stored procedure that runs a query and outputs the results to a text file and allows me to add extra delimeters and static

Question: I have a table with column called Date, which stores date record, that was entered in smalldatetime format (e.g., 2000-06-01 00:00:00). I need to write a stored procedure that