Wednesday, October 28, 2009

Getting started with SQL Azure

Getting started with SQL Azure

http://www.sqlservercentral.com/articles/SQL+Azure/68333/

Insert into a table with identity column

this is an easy way to insert into a table with default valus that has a identoty column.

this sample will insert 500 records.


WHILE SCOPE_IDENTITY()<500 OR SCOPE_IDENTITY() IS NULL INSERT INTO test1 default VALUES
There was an error in this gadget
There was an error in this gadget