NOTICE

last insert id

Date : 2016. 1. 12. 17:32 Category : Programming/ASP

<%
sql = "SET NOCOUNT ON; "
sql = sql & "INSERT INTO table(~~) VALUES(~~); "
sql = sql & "SET NOCOUNT OFF; SELECT SCOPE_IDENTITY() ID;"
Set res = objConn.Execute(sql)
Response.Write res("ID")
%>

mysql_insert_id()랑 같은 역할을 한다.