how can I put Identity Insert to ON and OFF from Enterprise Manager
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_10059276.html
How do you update the identity column or can this even be done?
Thanks!
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_10168576.html
Hi,
After inserting a recored to the DB, I'd like to know which number it assigned to it for the identity column. The identity column is a record id. How I can I tell which number it assigned? C...
http://www.experts-exchange.com/Database/Sybase/Q_10185466.html
Zones:
SybaseDate Answered: 07/22/1999 Grade: A Views: 0
Can I Refer to INSERTED table in a stored procedure?
Specifically I want to create a stored procedure that inserts a record into a table - it will copy a record from the table into the SAME table....
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_10194129.html
This is not a very practical question, but I thought would be a good theoretical exercise.
What I want to do is retrieve the next available identity value for a given table, BEFORE AN INSERT OCC...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_10350313.html
After creating a table would like to alter the table using the alter table command to include a identity value for the primary key field.
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_11882978.html
How can I add / drop identity to fields already in a table using T-SQL?
Thanks,
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20090302.html
Hi Guys!
I have this problem using IDENTITY for the primary key column of a table. You see, I use a single primary key for all my tables and it uses the IDENTITY property. However, as more and...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20091996.html
How can i insert a record in a sql generated table and apply updates? And how can I change the table proprety IDENTITY_INSERT? (the table is linked to an sql server)
http://www.experts-exchange.com/Programming/Languages/Pascal/Delphi/Q_20097273.html
I know how to create a MTS package using VB coding but am not sure how to change the default "Interactive User" setting to "This User". I have tried this but failed. I am also trying to set the use...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_20125440.html
Zones:
Visual BasicDate Answered: 05/29/2001 Grade: A Views: 4