摘要:
在数据库中把查询的数据结果以CSV导出,并把表头也导出。花了数个小时几经周折,初步实现了,应该还有更好的方式方法。现在创建一个表格CREATE TABLE [book] ( [bid] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , [bname] [char] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , [bauthor] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL , [bprice] [float] NOT NULL , [bnumber] [in. 阅读全文
摘要:
--一视图一if exists(select 1 from sysobjects where name=N'v_ExpenseQry' and type=N'V')drop view v_ExpenseQrygocreate view v_ExpenseQrywith encryptionas--一视图二if exists (select TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'v_ExpenseQry') DROP VIEW v_ExpenseQryGOcreat 阅读全文
摘要:
这些都是工作中遇到的问题,后来通过网上查找积累下来的。查找一个数据库有多少个表?select count(*) from sysobjects where xtype='U'查找一个数据库下所有表的表名select name from sysobjects where xtype='U'SELECT name FROM sysobjects WHERE xtype = 'U' Or xtype = 'S' 查找一个表的结构select * from information_schema.columns where table_na 阅读全文