{I+=codeWee;} |
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")