Advertisement

1 - 10 of 794 containing alltags:("identities") (0.001 seconds)
how can I put Identity Insert to ON and OFF from Enterprise Manager
Zones: MS SQL ServerDate Answered: 06/24/1998 Grade: A Views: 0
How do you update the identity column or can this even be done? Thanks!
Zones: MS SQL ServerDate Answered: 06/28/1999 Grade: C Views: 0
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...
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....
Zones: MS SQL ServerDate Answered: 08/17/1999 Grade: B Views: 0
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...
Zones: MS SQL ServerDate Answered: 05/19/2000 Grade: A Views: 0
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.
Zones: MS SQL Server, SSIDate Answered: 10/10/2003 Grade: A Views: 0
How can I add / drop identity to fields already in a table using T-SQL? Thanks,
Zones: MS SQL ServerDate Answered: 03/07/2002 Grade: A Views: 0
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...
Zones: MS SQL ServerDate Answered: 04/30/2001 Grade: B Views: 0
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)
Zones: Delphi ProgrammingDate Answered: 03/29/2001 Grade: A Views: 0
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...
Zones: Visual BasicDate Answered: 05/29/2001 Grade: A Views: 4