samedi 19 septembre 2015

how to give the delected id value to new record in sqlite

i have two questions 1)How can i use the previously deleted id value to new record.In sqlite we don't have identity column so i used auto increment keyword can i use set identity_insert here 2)Is there any possibility of using DBCC to reset id values

CREATE TABLE "Customer"(
"Id" integer primary key autoincrement not null ,
"Name" varchar ,
"Mid" varchar ,
"Year" integer ,
"Semester" integer )

http://1drv.ms/1F8iAxM

Aucun commentaire:

Enregistrer un commentaire