随笔分类 -  SqlServer数据库

摘要：这里有两个没有任何关联的表（ testa 和 item）select* from testaselect * from item 查询结果如下图一：接下来操作是--->现在把他们两个关联起来：select * from item left join testa on 1=1查询结果如下图二 阅读全文

摘要：在数据库中把查询的数据结果以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 阅读全文