{I+=codeWee;}
[ASP] ASP: Return id after insert SQL
	SQL = "SET NOCOUNT ON; INSERT INTO myTable (value1, value2) VALUES ("
	SQL = SQL & "'" & value1 &"'"
	SQL = SQL & ", '" & value2  &"'"
	SQL = SQL & ");  SET NOCOUNT OFF; SELECT SCOPE_IDENTITY() idx;"
	set Rs = db.Execute(SQL)

	returned_id = Rs("idx")
HTML | PHP | C++ | DirectX11 | Javascript | C# | HTML5 | ASP | SQL | General | CSS | Oculus Rift | Unity3d | Virtools SDK | Tip | NSIS | PowerShell | node.js | Web API | RTSP | All
Copyright© 2016 CodeWee.com All rights reserved.