Null values

Hi All . I had a strange experience with composite primary key in table . In that I found if Type o…

How are usernames checked?

Hi there, How are new usernames actually checked? It might lead to irritations when you allow Jonat…

Using Table Type in SQL 2K giving error.

Trying to Use Table Data Type in Sql 2K, While I Use it directly in a Stored procedure, It works fi…

Suggestions on processing result set in T-SQL

Attempting to get column name from varchar staging table and data type from target table. Query wor…

installing SQL server

I am the absolute definition of a newbie. I am just starting my first SQL class online and the book…

Asynchrous Execution with C#

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/colum…

multiple database vs multiple instance in 2000

What are peoples opinions of using multiple instancese as opposed to multiple databases on a single…

My Question

My name samerto , and have real problem . i used sql server 2000 sp3a and work it fine but in oth…

XTAB - SIMPLE CROSSTAB UTILITY

sp_XTAB (see Script library) ------------------------------------- example Use Northwind   EXE…

FOREIGN KEY on Temporary Table?

Question: Is is not possible to add a FOREIGN KEY constraint on a local or global Temporary table? …

Help on web multiple web forms.

CREATE TABLE Lookup_User_Title ( [TitleID] varchar(10) primary key, [TitleText] varchar (10) not nu…

what is clustring

Question About DEFAULT

If I have the need to create a new field for a table where records already exist, and that new fiel…

Review Lookup Tables...

Can someone check my logic here my main table I creared is at the buttom. How can I implement this …

Help on T-SQL

I am building a six page survey and I was wondering if u could give me a few tips or if u know of s…