Hi all,
I've been through the existing questions on SCOPE_IDENTITY() and I can't quite get it to work. Hoping someone could help.
I'm inserting field data into a SQL 2000 DB, and I want to imm...
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/ASP/Q_21138070.htm...
Zones:
ASPDate Answered: 09/21/2004 Grade: A Views: 4
I have a problem with getting the new ID from an insert command. can someone help me?
It executes, so it adds the row in the database, but then in the OnRowUpdated event handler it always returns ...
http://www.experts-exchange.com/Programming/Languages/C_Sharp/Q_21454008.html
Zones:
C#Date Answered: 06/13/2005 Grade: A Views: 0
I have a table that is using an Instead Of trigger for Inserts (and updates and deletes..its an auditing trigger). I have a stored procedure that copies a record from one project to another:
CR...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21456874.html
I have a question about MS SQL Servers SCOPE_IDENTITY - this is the explanation MSDN gives:
SCOPE_IDENTITY returns the last identity value generated for any table in the current session and t...
http://www.experts-exchange.com/Programming/Languages/C_Sharp/Q_21922530.html
Zones:
C#Date Answered: 07/18/2006 Grade: A Views: 0
First, I know very little about stored procedures or how to use them, I have been reading how to do this but it always talks about using SP's, I want to learn how to use them but I do not have the ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21973529.html
Hello Experts,
I am new to stored prcedures and have a small problem with my stored procedure returning values after inserting a record.
I need to pass the returned value to a variable and so...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_22111097.html
working with @@identity and scope_identity
Hello guys, I have a doubt about this, I have a table and both user trigger an insert value in that table,
A and B user wants the ID generated.
I...
http://www.experts-exchange.com/Programming/Languages/Pascal/Delphi/Q_22552982.html
Hi,
Can anyone tell me or point me to any theory that using SCOPE_IDENTITY is isolated to the user who is performing the action, i.e. separate thread?. i.e. so If I call SCOPE_IDENTITY I will g...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_22749099.html
I have a form that takes you through a series of steps based of CFSWITCH and CFCASE, then at the end asks you to confirm, click yes and this sends you to the Commit page where I have a stored proce...
http://www.experts-exchange.com/Software/Server_Software/Web_Servers/ColdFusion/Q_20907499...
this portion of my stored procedure gives me an "incorrect syntax" error.
DECLARE @NewResourceID int
SELECT SCOPE_IDENTITY() AS @NewResourceID
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21192539.html
