@@IDENTITY script download - @@IDENTITY @@IDENTITY script shows you how to use @@IDENTITY function to add a record to

@@IDENTITY script shows you how to use @@IDENTITY function to add a record to a table in your database and then retrieve the Identity field. Did you ever need to add a record to a table in your database and then retrieve the Identity or AutoNumber field of the record you just added? If you don't know about the built in SQL server system functions, it might be one of the hardest things to do and be sure that you are getting the right ID each time. But, MS Access and SQL Server both support using the @@IDENTITY function. Here's how it works, you add a record to a table with an INSERT or SELECT INTO statement, and then you call @@IDENTITY and it returns the ID number of the record you just added.

RECOMMENDED TOOLS

» database tool » record autonumber » record add » record » add » database

MySQL-Server-Manager script 0.2a     
MySQL-Server-Manager MySQL-Server-Manager is a PHP-program that allows you to administrate
Price: GPL$, Rating: 10, Downloads: 0

MSDB script 3.1     
MSDB MSDB - My SQL Data Browser - is a friendly database browsing WEB front end for MySQL.
Price: GPL$, Rating: 8, Downloads: 0

ICFormGen script 0.2     
ICFormGen ICFormGen should help you to create database driven forms.
Price: Freeware$, Rating: 8, Downloads: 0

odp2db script 1.1     
odp2db odp2db is a collection of Perl programs that can be used to parse the ODP data dump
Price: GPL$, Rating: 9, Downloads: 0

SQLyog Community Edition script 7.01     
SQLyog Community Edition SQLyog MySQL GUI is one of the most powerful MySQL managers and a
Price: GPL$, Rating: 8, Downloads: 0

PHP5 to MySQL connector script 6.0.3     
PHP5 to MySQL connector PHP5 to MySQL connector - With the help of this script you can eas
Price: Freeware$, Rating: 7.75, Downloads: 0

MySQL-Formmaker script 1.4.1     
MySQL-Formmaker MySQL-Formmaker is a tool for creating easy administration forms and outpu
Price: GPL$, Rating: 9, Downloads: 0

paBugs script 2.0b3     
paBugs paBugs is a bug tracker designed to help developers organize bugs in their programs
Price: Freeware$, Rating: 9, Downloads: 0