摘要：select rownum from ( SELECT ROW_NUMBER() over (order by CreateTime asc) as rownum,CompanyId,SourceType FROM dbo.t_BaiduIncludedRecord where Status=0 ) t where t.CompanyId=1 and t.SourceType=2 阅读全文

摘要：SELECT SUM(CASE WHEN PcIncludedStatus=1 OR PcSubIncludedStatus=1 THEN 1 ELSE 0 END) AS PcIncludedCounts, SUM(CASE WHEN PcIncludedStatus=0 AND PcSubIncludedStatus=0 THEN 1 ELSE 0 END) AS PcCounts, S... 阅读全文

摘要：sql 字符串类型转成xml类型 阅读全文

摘要：-- 创建临时表 IF OBJECT_ID('tempdb.dbo.#temprecord','U') IS NOT NULL DROP TABLE dbo.#temprecord; GO SELECT Id INTO dbo.#temprecord FROM dbo.t_BaiduIncludedRecord DECLARE @Id Int WHILE EXIST... 阅读全文

摘要：一、把数据库把某个字段更新为随机数 2、自定义随机函数 阅读全文

摘要：结果图： 阅读全文