Questions tagged [scope-identity]

122 questions
-2
votes
1 answer

Sql server scope identity with return id save and update

I am saving a photo to another table when saving the form. everything works very well. but the update does not work when updating, so the error is "can not be cast from dbnull to other types"
-3
votes
1 answer

Scope_identity is giving null values?

I have stored procedure in which I use scope_identity() Create table table1 id int, name varchar, age int Create procedure details @id int, @name varchar, age int Select @old_id = id , @name = name ,@age = age …
1 2 3
8
9