Select Last Inserted Record in SQL Server 2008 using vb.net SqlCommand with CommandType set to Text "NOT USING ANY STORED PROCEDURE"

Asked Jan 12 '13 at 12:14

Active Jan 15 '13 at 13:40

Viewed 46 times

Possible Duplicate:
Get last inserted UNIQUEIDENTIFIER in SQL Server 2000

Here is my table schema

CustomersID     uniqueidentifier    (newid())
CompanyName     nvarchar(50)
RegistrantName  nvarchar(50)
AddressLine1    nvarchar(50)
AddressLine2    nvarchar(50)
City            nvarchar(50)
State           nvarchar(50)
Country         nvarchar(50)
Zip             nvarchar(20)
PhoneNo         nvarchar(50)
MobileNo        nvarchar(20)
FaxNo           nvarchar(20)
Website         nvarchar(250)
Email           nvarchar(250)

As I'm not using any identity field in my table I cannot use the SCOPE_IDENTITY() to get the last inserted record id. I need to get the CustomersID after inserting the record. How is it possible?

edited May 23 '17 at 10:24

Community

asked Jan 12 '13 at 12:14

Krishanu Dey

6,326
7
51
69

2

@MitchWheat Damn you! Alternatively, since GUIDs are unique, you could always call `NEWID` in advance. – ta.speot.is Jan 12 '13 at 12:15
@MitchWheat: Can you show me a little example? – Krishanu Dey Jan 12 '13 at 12:16
1

https://www.simple-talk.com/content/article.aspx?article=1095 : that's what search engines are for! :) http://msdn.microsoft.com/en-us/library/ms177564(v=sql.105).aspx – Mitch Wheat Jan 12 '13 at 12:17
I'm confused... How can the identity now be known if it is not issued by the table, but issued by the "inserter"? – MarkD Jan 12 '13 at 12:17
1

@MarkD: because its a GUID... – Mitch Wheat Jan 12 '13 at 12:17
@tech_me : It's almost the same, but I want to do it from VB.NET SqlCommand Class object. And I think the solution in the link you provided is not applicable for SqlCommand Class object in VB.NET – Krishanu Dey Jan 12 '13 at 17:02
This site moderators are much interested in finding duplicates and closing questions than identifying the actual point of question. x-( – Krishanu Dey Jan 15 '13 at 13:38
CODE PROJECT IS MUCH MUCH BETTER SITE THAN STACKOVERFLOW – Krishanu Dey Jan 15 '13 at 13:41

Select Last Inserted Record in SQL Server 2008 using vb.net SqlCommand with CommandType set to Text "NOT USING ANY STORED PROCEDURE"

0 Answers0