摘要：--创建测试数据表tbcreate table tb(id varchar(3) , pid varchar(3) , name varchar(10))insert into tb values('001' , null , '广东省')insert into tb values('002' ... 阅读全文

摘要：写sql语句分别按日，星期，月，季度，年统计销售额--按日select sum(consume),day([date]) from consume_record where year([date]) = '2006' group by day([date])--按周quarterselect sum(consume),datename(week,[date]) from consume_record where year([date]) = '2006' group by datename(week,[date])--按月select sum(consume), 阅读全文

摘要：/*打开全文索引支持，启动SQL Server的全文搜索服务 */execute sp_fulltext_database ‘enable’ /*创建全文目录*/EXEC SP_FULLTEXT_CATALOG 'FT_testData','CREATE'/*建立全文索引数据元*/EXEC sp_fulltext_table 'Hc_Book_Book','CREATE','FT_testData','PK_Hc_Book_BookInfo'/*添加支持全文索引的列名*/EXEC sp_fullte 阅读全文

摘要：1. 获取gridview Repeater datalist控件的行号2. 15 ? Eval("title").ToString().Substring(0, 15) + "....." : Eval("title")%>前台页面截取字符串3.NavigateUrl='' Eval()同时绑定多个参数4.dbcc checkident('T_SimCode',reseed,0) 将sql的自动增长列恢复到1开始5.SELECT DISTINCT列名 from [表名] where... 过滤列 阅读全文