using @@IDENTITY (or nething like this)for char datatype(sql server)
-
Hi guys i m having a table which primary key is char(7). i want to have last inserted row's id value but @@IDENTITY returns numeric rather character. I dnt hv ne field like time timestamp too :( Thanks in advance Utsav
-
Hi guys i m having a table which primary key is char(7). i want to have last inserted row's id value but @@IDENTITY returns numeric rather character. I dnt hv ne field like time timestamp too :( Thanks in advance Utsav
do i need 2 mention thaT CHAR primery key is not identity (i.e. autoincrement)??
-
Hi guys i m having a table which primary key is char(7). i want to have last inserted row's id value but @@IDENTITY returns numeric rather character. I dnt hv ne field like time timestamp too :( Thanks in advance Utsav
i think it was d stupid most question a person can ask, got d solution guys, dnt boter 4 that stupidness Utsav
-
i think it was d stupid most question a person can ask, got d solution guys, dnt boter 4 that stupidness Utsav
hi there, if u want to use @@Identity to get the last inserted record, u've to use the int field with auto increament attribute. Then, u can use this identity to retrive the info of the last inserted record << >>