create table Xl_StorePictureCategory
(
StorePictureCategoryId int identity(1,1) // identity(int,1,1)有什么区别么?
,[Name] nvarchar(25),PRIMARY KEY ( StorePictureCategoryId)
) 小f妹妹
(
StorePictureCategoryId int identity(1,1) // identity(int,1,1)有什么区别么?
,[Name] nvarchar(25),PRIMARY KEY ( StorePictureCategoryId)
) 小f妹妹
identity(int,1,1) 只能在 select ..into ..from..
create table tb(id int identity(1,1),name varchar(10))
生成表時候用
select ID=identity(int,1,1),* into newtable from tb
:identity(int,1,1)
IDENTITY(属性)
:identity(1,1)
生成表的时候用identity(int,1,1)
(
StorePictureCategoryId int identity(1,1) // identity(int,1,1)有什么区别么?
,[Name] nvarchar(25) ,PRIMARY KEY ( StorePictureCategoryId) )
create table Xl_StorePictureCategory
(
StorePictureCategoryId identity(int,1,1)有什么区别么?
,[Name] nvarchar(25) ,PRIMARY KEY ( StorePictureCategoryId) ) 这样运行会报错的..
identity(int,1,1)---插入临时表时用.
这个句子用于生成id自增的临时表#t