常用sql操作语句
<div id="cnblogs_post_body">/*创建表*/CREATE TABLE [UserInfo](
[UserID] [uniqueidentifier] not null,
[UserName] [varchar](100) not null,
[LoginNumber] [varchar](50) not null,
[Password] [varchar](50) not null
);
/*删除表*/
drop table [UserInfo];
/*添加主键约束*/
ALTER TABLE [UserInfo] ADDCONSTRAINT [PK_UserInfo]primary key([UserID]);
/*添加默认值约束*/
ALTER TABLE [UserInfo] ADDCONSTRAINT [DF_UserInfo_UserID]default (newid()) for [UserID];
/*添加字段*/
alter table [UserInfo] add [Sex] [varchar](10) null;
/*修改字段*/
alter table [UserInfo] alter column [Sex] [varchar](20) null;
/*删除字段*/
alter table [UserInfo] drop column [Sex];
/*批量插入*/
insert into [UserInfo]([Username],[LoginNumber],[Password],[Sex] select [UserName],[LoginNumber],[Password],[Sex] from [UserInfo];
/*批量更新*/
update [UserInfo1] set [UserInfo1].[Password]=b.[Password],[UserInfo1].[Sex]=b.[Sex] from [UserInfo] b where [UserInfo1].[LoginNumber]=b.[LoginNumber];
/*创建临时表*/
create table #TempTable(
[LoginNumber] [varchar](50),
[Password] [varchar](50)
);
/*自增列*/
create table [TestTable](
[ID] [int] identity(1,1) not null
);
页:
[1]