Sql 增删改查

use master 
go
if exists(select * from sysdatabases where name = 'userManager')
    drop database userManager
go
create database userManager
go
use userManager
go
/***********用户表**********/
create table userInfo(
    userId        int identity not null,--用户ID    
    userName    varchar(20)  not null,--用户名    
    passWord    varchar(20)  not null,--密码    
    context        varchar(20)           --备注
)
go
alter table userInfo 
    add constraint PK_companyId primary key (userId)
go



/*************增**************/
insert into userInfo(userName, passWord, context)
    values('乔峰','qiaofeng','备注1')

insert into userInfo(userName, passWord, context)
    values('大黑','dahei','备注2')

insert into userInfo(userName, passWord, context)
    values('小黄','xiaohuang','备注3')

insert into userInfo(userName, passWord, context)
    values('大蓝','dalan','备注4')
go

/****************删除*****************/
delete from userInfo
where userName = '大黑';
GO

/****************修改*****************/
UPDATE userInfo 
SET userName = '虚竹', passWord = 'xuzhu', context = '不会九阴白骨爪'
WHERE userName = '大黑';
GO


/****************查找*****************/
select userName, passWord, context
from userInfo



select * from userInfo