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: | ||