How do I generate a random number for each row in a T-SQL select?
I need a different random number for each row in my table. The following seemingly obvious code uses the same random value for … Read more
sql-server-2000
How to Join to first row
I’ll use a concrete, but hypothetical, example. Each Order normally has only one line item: Orders: OrderGUID OrderNumber ========= ============ {FFB2…} STL-7442-1 {3EC6…} … Read more
Check if table exists in SQL Server
I would like this to be the ultimate discussion on how to check if a table exists in SQL Server 2000/2005 using SQL … Read more
Add a column with a default value to an existing table in SQL Server
How can I add a column with a default value to an existing table in SQL Server 2000 / SQL Server 2005? 4 … Read more