sql
devilszhou
‘努力ヽ未来
展开
-
sql2000中查询一个表中的所有列名
SELECT nameFROM syscolumnsWHERE (id = (SELECT id FROM sysobjects WHERE type = u AND name = TreeShow))原创 2010-05-28 10:22:00 · 290 阅读 · 0 评论 -
sql查询同一字段值是否存在相同记录
SELECT *FROM Ds_WasteBookWHERE (Ds_WasteBook_Desc IN (SELECT Ds_WasteBook_Desc FROM Ds_WasteBook GROUP BY Ds_WasteBook_Desc HAVING (COUNT(*) > 1))) AND (Ds_WasteBook_D原创 2010-05-28 10:23:00 · 808 阅读 · 0 评论 -
修改sql2000区分大小写问题
修改为区分大小写 ALTER DATABASE 数据库名 COLLATE Chinese_PRC_CS_AS 修改为不区分大小写在执行t-sql之前先把企业分析器关掉use master declare @dbname varchar(20) set @dbname=zxj_xinchengxu1 decl原创 2010-05-28 10:25:00 · 263 阅读 · 0 评论