current record number

  • Thread starter Thread starter ven
  • Start date Start date
V

ven

hello

i want to get current record in MS SQL table with identity column, let say i
put somethin using INSERT INTO and then i want to know current number in
identity column
how can i put this number into variable in vbscript ?

Ven
 
SELECT SCOPE_IDENTITY

this must be executed in the same batch as your insert statement
 
ven said:
hello

i want to get current record in MS SQL table with identity column, let
say i put somethin using INSERT INTO and then i want to know current
number in identity column
Click to expand...


SELECT @@IDENTITY.
 
U¿ytkownik "A. Elamiri said:
SELECT SCOPE_IDENTITY

this must be executed in the same batch as your insert statement
Click to expand...

but how write this value to vbscript variable ?
 
ven said:
but how write this value to vbscript variable ?
Click to expand...

Does your .NET app have a COM interface? If it does, then you can call the
app via COM+ and access the variable as a property or function.
 
U¿ytkownik "Lucas Tam said:
Does your .NET app have a COM interface? If it does, then you can call the
app via COM+ and access the variable as a property or function.
Click to expand...


that`s ok, but maybe can you put a little code ?

Thank`s

Ven
 
Back
Top