sql语句零拾1

1.查看表中所有字段的类型语句：（换一下表名即可）
select name,(select name from systypes where xtype=c.xtype)as type from syscolumns c where id=(
select id from sysobjects where xtype='u' and name='表名')

 

2.在数据库中新建一个表，并复制另一表的所有字段(一条数据)：
select top 1 * into A 表 from B表

 

3.求差：1.update tb_store  set wtkc =ktysl-ycksl

 

4.外连接：1.select * from tb_store a full outer join tb_contractapply b on a.organization2=b.organization2 and (a.contractcode=b.contractcode or a.contractcode1=b.contractcode1)

 

5.查看表中所有字段的类型语句：（换一下表名即可）
select name,(select name from systypes where xtype=c.xtype)as type from syscolumns c where id=(
select id from sysobjects where xtype='u' and name='表名')