identity column
-
hi all, can any one tell me what is an identity column and what is the use of this column in sql table... Regards, S.Inayat basha.
-
hi all, can any one tell me what is an identity column and what is the use of this column in sql table... Regards, S.Inayat basha.
Try using Google: Identity column[^]. This was the first result.
me, me, me "The dinosaurs became extinct because they didn't have a space program. And if we become extinct because we don't have a space program, it'll serve us right!" Larry Niven nils illegitimus carborundum
-
hi all, can any one tell me what is an identity column and what is the use of this column in sql table... Regards, S.Inayat basha.
An identity column gives an unique identificationnumber to every row in a table. Identity columns are frequently used, especially to establish links with other tables to keep your references in order. e.g. TABLE NAMES (Customer_ID, FirstName, LastName) TABLE ADDRESS ([ADDR_ID], Customer_ID, Address)
-
hi all, can any one tell me what is an identity column and what is the use of this column in sql table... Regards, S.Inayat basha.
identity automatically increment your column values from seed property specified in identify clause. exam create table tbl ( i int identity(1000,1), name varchar(100)) output as 1000 table1 1001 table2 1002 table3
Ganu Sharma :)
-
An identity column gives an unique identificationnumber to every row in a table. Identity columns are frequently used, especially to establish links with other tables to keep your references in order. e.g. TABLE NAMES (Customer_ID, FirstName, LastName) TABLE ADDRESS ([ADDR_ID], Customer_ID, Address)
identity automatically increment your column values from seed property specified in identify clause.
exam
create table tbl
( i int
identity(1000,1), name varchar(100))output 1000 ;P 1001 1002
Ganu Sharma