Sql server 常用语句
2013-07-08 09:52 hduhans 阅读(125) 评论(0) 收藏 举报1、复制表结构:
select * into b from a where 1<>1
2、查询数据表所有字段
select name from syscolumns where ID=OBJECT_ID('RP_StampInfor')
1、复制表结构:
select * into b from a where 1<>1
2、查询数据表所有字段
select name from syscolumns where ID=OBJECT_ID('RP_StampInfor')