Tip Bank

Question: I have a field that stores lots of data (up to 8,000 characters). I thought that I could maybe save disk space if I stored this data as varbinary

Question: I need to pass the @TheVar variable to the stored procedure’s IN statement but I keep getting zero records. If I type this statement into the SQL… WHERE Name

Question: How do I control the output format for the list structure command so that it always fits on a page (portrait or landscape)? Is there another way to get

Question: How do I check strings that have only alphanumeric characters? Answer: When you say alphanumeric, I assume you mean that the characters are in one of the following domains:

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