I need a different random number for each row in my table. The following seemingly obvious code uses the same random value for each row. SELECT table_name, RAND() magic_number FROM information_schema.tables I’d like to get an INT or a FLOAT out of this. The rest of the story is I’m going to use this random … Read more
I’ll use a concrete, but hypothetical, example. Each Order normally has only one line item: Orders: OrderGUID OrderNumber ========= ============ {FFB2…} STL-7442-1 {3EC6…} MPT-9931-8A LineItems: LineItemGUID Order ID Quantity Description ============ ======== ======== ================================= {098FBE3…} 1 7 prefabulated amulite {1609B09…} 2 32 spurving bearing But occasionally there will be an order with two line items: … Read more
I would like this to be the ultimate discussion on how to check if a table exists in SQL Server 2000/2005 using SQL Statements. When you Google for the answer, you get so many different answers. Is there an official/backward and forward compatible way of doing it? Here are two possible ways of doing it. … Read more
How can I add a column with a default value to an existing table in SQL Server 2000 / SQL Server 2005? 4 44
