hi to the group,
i am small problem,
i am having two columns 1 is col1 which is a primary key and col2 any think .now i want to insert the data into second column at that time the first column must get the values in identity (like 1,2,3,4 etc)
with out using identity(sql server)/generated always(db2)
can any one knows please explain itDidn't I answer this one already?
http://weblogs.sqlteam.com/brettk/archive/2004/06/29/1687.aspx|||Didn't I answer this one already?
http://weblogs.sqlteam.com/brettk/archive/2004/06/29/1687.aspx
OMFG brett, are you kidding?
you seriously expect people to remember everything you wrote up to several years ago on a completely different site from this one?
i don't know, man, did you answer it already?
sheesh|||jagadish, look up the SET IDENTITY INSERT option in Books Online.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment