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='表名')