Sql

Search

insert output identity

DECLARE @OutputTbl TABLE (ID INT)

INSERT INTO MyTable(Name, Address, PhoneNo)
OUTPUT INSERTED.ID INTO @OutputTbl(ID)
VALUES ('Yatrix', '1234 Address Stuff', '1112223333')

Comment

PREVIOUS	NEXT

Code Example
Sql :: create user sql server
Sql :: sql server concat string and int
Sql :: sql add two values together
Sql :: mysql grant access to one database
Sql :: copy table postgres
Sql :: postgresql get difference between two dates
Sql :: When mysql server would not work in xampp
Sql :: mysql add column with default value
Sql :: postgres float to int
Sql :: postgres list all triggers
Sql :: How to check event scheduler status mysql
Sql :: postgresql export database
Sql :: Get the Db column names from a SqlDataReader
Sql :: sql extract numbers from string
Sql :: phpmyadmin change password
Sql :: check if database exists sql
Sql :: n highest salary in sql
Sql :: mysql get last insert id
Sql :: extract weekday from date in sql
Sql :: sqlite autoincrement
Sql :: alter table add multiple columns postgresql
Sql :: oracle revoke
Sql :: SQL Server lock table example
Sql :: varchar vs nvarchar sql
Sql :: sql datetime format dd/mm/yyyy hh:mm am/pm
Sql :: psql create user
Sql :: mysql trim spaces
Sql :: SQL ORDER BY ASC (Ascending Order)
Sql :: sql create database
Sql :: add multiple row table pl sql

Search

SQL

insert output identity

ADD CONTENT