Member Avatar for justapimp

How do I create a single sql statement that will insert a row into a data table and return the row number back for processing? I tried to use the scope_identity method and find out it works well within a stored procedure environment.

If anybody out there have another method, I would appreciate the help.

  • 2 Contributors
  • 1 Reply
  • 102 Views
  • 20 Hours Discussion Span
  • Latest Post Latest Post by serkan sendur
Member Avatar for serkan sendur

after your insert query append
select @@IDENTITY statement

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.