|
|
-
cgeach Liked 2 Years ago through Just Learned | 1 Point
During the development of any application we input dummy data and which is stored in database. But frequently we come to the point where we want all records of the table to be deleted and also want to start the identity columns values from 0.
For this ...
|
-
cgeach Liked 2 Years ago through Just Learned | 1 Point
During the development of any application we input dummy data and which is stored in database. But frequently we come to the point where we want all records of the table to be deleted and also want to start the identity columns values from 0.
For this ...
|
-
cgeach knew 2 Years ago through Just Learned | 1 Point
During the development of any application we input dummy data and which is stored in database. But frequently we come to the point where we want all records of the table to be deleted and also want to start the identity columns values from 0.
For this ...
|
-
cgeach knew 2 Years ago through Just Learned | 1 Point
During the development of any application we input dummy data and which is stored in database. But frequently we come to the point where we want all records of the table to be deleted and also want to start the identity columns values from 0.
For this ...
|
-
cgeach interesting 2 Years ago through Just Learned | 1 Point
There is something $IDENTITY to get the identity value for a table contained the identity column.
[Code]
create Table T1(Col1 int identity(1,5),Col2 int)
Go
Insert into T1(Col2) Select 100
Go 100
Select $Identity,* From T1
[/Code]......
|
-
cgeach interesting 2 Years ago through Just Learned | 1 Point
There is something $IDENTITY to get the identity value for a table contained the identity column.
[Code]
create Table T1(Col1 int identity(1,5),Col2 int)
Go
Insert into T1(Col2) Select 100
Go 100
Select $Identity,* From T1
[/Code]......
|
-
cgeach Liked 2 Years ago through Just Learned | 1 Point
There is something $IDENTITY to get the identity value for a table contained the identity column.
[Code]
create Table T1(Col1 int identity(1,5),Col2 int)
Go
Insert into T1(Col2) Select 100
Go 100
Select $Identity,* From T1
[/Code]......
|
-
cgeach Liked 2 Years ago through Just Learned | 1 Point
There is something $IDENTITY to get the identity value for a table contained the identity column.
[Code]
create Table T1(Col1 int identity(1,5),Col2 int)
Go
Insert into T1(Col2) Select 100
Go 100
Select $Identity,* From T1
[/Code]......
|
-
cgeach Liked 2 Years ago through Just Learned | 1 Point
There is something $IDENTITY to get the identity value for a table contained the identity column.
[Code]
create Table T1(Col1 int identity(1,5),Col2 int)
Go
Insert into T1(Col2) Select 100
Go 100
Select $Identity,* From T1
[/Code]
|
-
cgeach Liked 2 Years ago through Just Learned | 1 Point
During the development of any application we input dummy data and which is stored in database. But frequently we come to the point where we want all records of the table to be deleted and also want to start the identity columns values from 0.
For this we
|