文件名称：sql常用代码
文件大小：3KB
文件格式：TXT
更新时间：2017-09-07 05:20:13
sql常用代码
sql常用查询，内连接，外连接declare @sum int declare @count int set @count =0 set @sum =0 while @count <100 begin set @count =@count +1 set @sum =@sum +@count end print'1+2+3+....' print @sum create table employ ( empid varchar(10) not null primary key, empname varchar (10) null, sex varchar(4) null, age int null, deptid varchar(10) null ) drop table employ CREATE TABLE employ ( empid varchar(10) PRIMARY KEY, empname varchar(10) , sex varchar(4) , age int , deptid varchar(10) ) insert into employ values('1000','张三','男',30,'10') insert into employ values('1001','张四','男',20,'11') insert into employ values('1002','张五','女','43','12') INSERT INTO amploy VALUES('1000','张三','男',30,'10')