Sometimes we need to get the last record inserted into the database. But if there is no primary key, date, or ID field to query we can use a temp table to return the results we need. <\/p>\n
Example:
\nTable MY_CONTACTS
\ncontains
\nContact varchar(100) not null
\nNote varchar(200) null<\/p>\n
Sometimes we need to get the last record inserted into the database. But if there is no primary key, date, or ID field to query we can use a temp table to return the results we need. Example: Table MY_CONTACTS … Continue reading \/\/select all records into a temp table
\nselect IDENTITY(int,1,1) AS id, contact, note
\ninto #tempContacts
\nfrom MY_CONTACTS
\n...
\n\/\/get the last record
\nselect * from #tempContacts
\nwhere id = @@identity
\n...
\n\/\/ pull all records to compare results.
\nselect * from #tempContacts<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"