Puzzle question in SQL Server
CREATE TABLE VENKAT_TABLE (ID INT IDENTITY(1,1)) INSERT INTO VENKAT_TABLE DEFAULT VALUES GO 100
CREATE TABLE VENKAT_TABLE (ID INT IDENTITY(1,1)) GO -- Should have seperate GO here. INSERT INTO VENKAT_TABLE DEFAULT VALUES GO 100