var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Is there a way to return the PK ID of the row inserted?
When I insert a row I need the PK assigned to that row. Is there a way to do this.
yes, there is, the SCOPE_IDENTITY function
Following are the ways to find out last Identity value inserted.
See which one is useful to you.
One thing to remember, these solutions work only when the primary key is an identity column.
almost always the one you want to use is scope_identity()
read BOL on the differences between these three:
If you're using SQL 2005 you can use the OUTPUT-clause:
INSERT MyTable (<column list>)
VALUES (<insert list>)