Tutorials
Resources
Forum
Communities
Interview
Jobs
Projects
Offshore Development
Silverlight Tutorials
|
Mentor
|
Code Converter
|
Articles
|
Code Factory
|
Computer Jokes
|
Members
|
Peer Appraisal
|
IT Companies
|
Bookmarks
|
Revenue Sharing
|
Prizes & Awards
My Profile
Sign In
Register
AdSense Revenue
Active Members
Today
Deepika Harida...
(321)
SweetGhost
(267)
David Billa
(183)
Last 7 Days
Arun Jacob
(1406)
amarababu nara...
(1301)
Deepika Harida...
(1194)
more...
New Feature:
Community Sites
:
Create your own .NET community website and start earning from Google AdSense !
It's Free !
How to Explicitly assign value to identity column
Posted Date: 28 May 2008 Resource Type:
Code Snippets
Category:
SQL DBA
Posted By:
imamjani shaik
Member Level:
Silver
Rating:
Points
: 10
we can explicitly insert value to a identity set column.here is the sample query
SET IDENTITY_INSERT ON
GO
INSERT INTO TABLENAME VALUE(......)
SET IDENTITY_INSERT OFF
GO
Responses
No responses found. Be the first to respond and make money from
revenue sharing program
.
Feedbacks
Popular Tags
What are tags ?
Search Tags
Sign In
(No tags found.)
Post Feedback
This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must
Sign In
to post a response.
Next Resource:
How to change TEMPDB settings permanently
Previous Resource:
LIKE KEYWORD
Return to Discussion Resource Index
Post New Resource
Category:
SQL DBA
Post resources and
earn money
!
Related Resources
Searching particular Column name in all the tables in the database
Find space occupied by a table in a database
Removing unwanted spaces within a string ...
Use the parameter as Column name or Table name in select query
Generate XML files from SQL Database
dotNet Slackers
BizTalk Adaptors
Web Design
teleconferencing
Contact Us
Privacy Policy
Terms Of Use