Sql

Search

insert value in identity

SET IDENTITY_INSERT <table_name> ON
-- execute this before inserting values in idenity

-- example
SET IDENTITY_INSERT Customer ON  
INSERT INTO Customer(ID, Name, Address)  
VALUES(3,'Prabhu','Pune')

Comment

PREVIOUS	NEXT

Code Example
Sql :: null column to 0 in mysql
Sql :: SQL date part only of datetime
Sql :: what is my mysql version
Sql :: mysqldump: Got error: 1045: Access denied for user
Sql :: how to add CHECK constraint to a column in postgres
Sql :: mysql between date range
Sql :: change postgress password
Sql :: update single sql column
Sql :: select top 10 rows in sql
Sql :: mysql query first character
Sql :: get name of day in sql
Sql :: how to update date value in sql
Sql :: select rows with same value in a column
Sql :: sql count group by
Sql :: remove duplicates sql server select
Sql :: select distinct
Sql :: oracle drop temporary table
Sql :: psql fatal database does not exist
Sql :: print year of a date sql
Sql :: postgresql create query
Sql :: select if then postgresql
Sql :: how to check the mysql version mac
Sql :: sql declare table variable
Sql :: create table employees oracle
Sql :: oracle select first result
Sql :: sql calculate working days between two dates excluding weekends and holidays
Sql :: mysql alter add foreign key
Sql :: sql count number of rows after group by
Sql :: mysql change default collation
Sql :: duplicate entry

Search

SQL

insert value in identity

ADD CONTENT