sql提升
摘要：
1、复制表的结构select *into newTable from oldTable where 1<>1select top 0 *into newTable from oldTable2、拷贝表insert into newTable(newColumn1, newColumn2, ...) select column1, column2, ... from oldTable3、between的用法select * from tableName where column between value1 and value2４、1=1,1=2的使用where 1=1 是表示选择全 阅读全文
posted @ 2012-10-02 10:17 zqiang3 阅读(110) 评论(0) 推荐(0) 编辑