This shows you the differences between two versions of the page.
wiki:software:code:cfm:mssql [2022/09/19 20:05] claire created |
wiki:software:code:cfm:mssql [2022/09/26 17:20] (current) claire ↷ Page moved from wiki:software:cfm:mssql to wiki:software:code:cfm:mssql |
||
---|---|---|---|
Line 1: | Line 1: | ||
====== Coldfusion 8 and Microsoft SQL 2005 : @@IDENTITY ====== | ====== Coldfusion 8 and Microsoft SQL 2005 : @@IDENTITY ====== | ||
- | <adm abstract Old blog post> | + | {{template>util:oldblog|date=November 12, 2008}} |
- | This article was originally published on November 12, 2008. | + | |
- | </adm> | + | |
There’s a handy little query you can run in SQL to retrieve the identity (primary key) value of a record you just created. So, you can do something like this: | There’s a handy little query you can run in SQL to retrieve the identity (primary key) value of a record you just created. So, you can do something like this: |