￠虾咪┆℡ 的博客

【代码】Sqlserver多个字段不空的where条件。

SqlServer对应的C#类型

Sqlserver唯一约束添加，删除，查看。

SELECT *INTO #DiGuiFROM (SELECT 8 AS Id, 5 AS ParentId UNION SELECT 15, 5 UNION SELECT 30, 15 UNION SELECT 23, 15 UNION.

string sql="select * from A where Title like @title"new SqlParameter("@title", "%" + Title + "%")

select distinct namefrom sysobjects o, syscomments swhere o.id = s.idand text like '%Factory_Invoice_No%'and o.xtype = 'P'

--查看索引--execute sp_helpindex @objname = 'Allocation_Result_Tracking';--创建复合索引--create index Index_Tracking_Ref on Allocation_Result_Tracking(Ref_Id,Ref_Type);--删除索引--drop index Allocation_Result_Tracking.Index_Tracking_Ref...

SELECT * INTO #Temp_Date FROM (SELECT Cast( '2020-01-01' AS DateTime) AS ValidationStart ,Cast('2020-04-08' AS DateTime) AS ValidationEndUNIONSELECT Cast( '2020-02-01' AS DateTime) AS ValidationSt...

select distinct namefrom sysobjects o, syscomments swhere o.id = s.idand text like '%SubsidyCriteria%'and o.xtype = 'P'

Delete A from GIS_Mall_Info A inner join ( select MAX(id) as ID,Ref_ID from GIS_Mall_Info group by Ref_ID having count(1)>1 ) B on B.Ref_ID=A.Ref_ID and B.ID<>A.ID 

需要处理有逗号的sql语句REPLACE(REPLACE(REPLACE(REPLACE(Comment, CHAR(13), ''), CHAR(10), ''),CHAR(9),''),',','，') as 'Comment'

string sql="select * from A where Title like @title"new SqlParameter("@title", "%" + Title + "%")

举例：小明第1名，总人数10人小黑第2名，总人数10人小白第3名，总人数10人小明的计算公式：(10+1-1)/10.00*100小黑的计算公式：(10+1-2)/10.00*100小白的计算公式：(10+1-3)/10.00*100算法：（总人数+1）减去排名/总人数*100

Linq中包含查询//Linq代码：T_WxMaterials.Where(n=>T_VideoMsgs.Select(m=>m.MediaID).Contains(n.MediaID)) //生成的sql语句:SELECT [t0].[ID], [t0].[Type], [t0].[Title], [t0].[Cnt], [t0].[MediaID], [t0].[LocalPath], [t

http://www.cnblogs.com/doubleliang/archive/2011/07/06/2098775.html

create table test4 ( id int identity(1,1), name varchar(100) ) create table test4Score ( test4id int, score int ) insert into test4(name) select 'LeeWhoeeUniversit

select left('123456',3) --返回从左开始的3个字符长度的字符串结果：123-----------------------------------------------------------select right('123456',3)--返回从右开始的3个字符长度的字符串结果：123---------------------------------------

ALTER Proc [dbo].[sp_exam_GetStoreSurvey_SurveyRecord201608] as if OBJECT_ID(‘tempdb..#TEMP_StoreSurvey_SurveyRecord201608’) is not null drop table #TEMP_StoreSurvey_SurveyRecord201608 select SR.Us

示例：declare @TaskName varchar(100)set @TaskName='费用类请购流程,费用类请购流程,固资预算调整流程'select distinct TASK_Name from VW_SYS_TASKS_ACCESSIBLEwhere CHARINDEX(','+CAST(Task_Name as varchar)+',',','+@TaskNam