Shahnawaz
Member since Mar 19, 2012
- Profile: /members/9748-shahnawaz.htm
- Comments: 1
Recent Blog Comments By Shahnawaz
-
Turning Off and On Identity Column in SQL Server
Posted on Mar 19, 2012 at 1:58 AM
USE AdventureWorks2008R2; GO -- Create tool table. CREATE TABLE dbo.Tool( ID INT IDENTITY NOT NULL PRIMARY KEY, Name VARCHAR(40) NOT NULL ) GO -- Inserting values into products table. INSERT INTO dbo.Tool(Name) VALUES ('Screwdriver') INSERT INTO dbo.Tool(Name) VALUES ('Hammer') INSERT INTO db... read more »