sql starts with string

--方法1--sql 分隔字符串，返回个数CREATEfunctionf_splitLen_1(@strvarchar(1024),--要分割的字符串@splitvarchar(10)--分隔符号)returnsintasbegindeclare@locationintdeclare@startintdeclare@lengthintset@str=ltrim(rtrim(@str))set@location=charindex(@split,@str)set@length=1while @locationbeginset @[emailprotected]+1set@location=charindex(@split,@str,@start)set@[emailprotected]+1endreturn@lengthend--演示1select dbo.f_splitLen_1(‘1,2,3,4‘,‘,‘)as‘Count‘-- 查询结果为：4createfunctionf_splitLen_2

Tags: logs convert weight made with int span app DivSQL Server Profiler caught a lot of code in the job, applicationname similar to Sqlagent-tsql JobStep (Job 0x94b9b5c016e8d94fb50898c868314d08:st EP 1) Such a Need to convert the binary name in the job into job_id The conversion is done in the following ways: Declare @JobID uniqueidentifier SELECT @JobID = 0x94b9b5c016e8d94fb50898c868314d08 PRINT 'My JobID is' + Convert(Char(255),@JobID) Select * fromMsdb.dbo.sysjobswherejob_id=Convert(Char(

), Current_timestamp, 104) 105 22-02-2006 CONVERT (CHAR (Ten), Current_timestamp, 105) 106 2006 CONVERT (CHAR (one), Current_timestamp, 106) 107 Feb 22, 2006 CONVERT (CHAR (), Current_timestamp, 107) 108 16:26:08 CONVERT (CHAR (8), Current_timestamp, 108) 109 Feb 2006 4:26:08:067pm CONVERT (CHAR (+), Current_timestamp, 109) the 02-22-2006 CONVERT

Tags: sql join lemp end character size routing employee LinCase is left (t5.name,2) = ' substring ' and then ' (t5.name,9,2) Else substring (t5.name,7,2) End GD Intercept pre-1~10 digits ac17072408 Select substring (name,0,11) from Profin_application; name=ac1707240801 Select substring (name,0,11) from Profin_application;Select Left (name,10) from Profin_application; Select T1.name, Timeadd (' Hour ', 8,t1.date), T3.name_template, left (t3.name_t

Tags: create function Fn_find (@find varchar (8000), @str varchar (8000), @n smallint) ret Urns int as BEGIN if @n 　　SQL Server finds the location of the specified string

DECLARE @str NVARCHAR(MAX);SET @str = 'AA|BB|CC|DD';DECLARE @n NVARCHAR( -)SET @str += '|' while LEN(@str)> 1 BEGIN SET @n = Left(@str,CHARINDEX('|',@str)) SET @str = Right(@str,LEN(@str)- LEN(@n)) SET @n = REPLACE(@n,'|',"') SELECT @n END----------------------------------------------------------------------------------------------------Aa(1 rows affected)----------------------------------------------------------------------------------------------------Bb(1

How SQL Server, MySQL gets the connection stringSteps:First, create a new text document Xxx.txt, modify the file type to. udlSecond, open the document, in the "provide data" to find the corresponding services.Third, select the required database in the connection and fill in the relevant information.Iv. Test Connection, if successful then skip to the next step, failure is the user information error, re-modify.Change the xxx.udl suffix name to txt and o

When connecting to a database with a. UDL, select Allow Persist Security info=true when saving passwords, otherwise falseThe Persist Security Info property is meant to indicate whether or not to save secure information, in fact, it can be simply understood as "whether ADO saves password information after a successful database connection",True means save, false means no saveThe default for ADO is False, not tested, according to the referenceThis can be verified by the ConnectString property of th

Label:SQL Create function Database name--programmability---table-valued functions Right-click to create a "multi-statement table-valued Function" CREATE FUNCTION [dbo].[Fun_splitstr](@str VARCHAR(MAX)) RETURNS @temp TABLE(IDINT) as BEGIN DECLARE @ch as VARCHAR( -) SET @str+=',' while(@str"') BEGIN SET @ch = Left(@str,CHARINDEX(',',@str,1)-1) IF @ch>0 INSERT @temp VALUES(@ch) SET @str=STUFF(@str,1,CHARINDEX(',',@str,1),"') END RETURN END

Can the intercepted string be directly treated as the where condition in the SQL statement, such as select nbsp; 'id' nbsp; from nbsp; 'table' nbsp; where nbsp; left ('flag', 1) = 1; I have a string of flag IDs used to indicate various attributes of the product. nbsp; can a 10-bit SQL statement directly use the t

Label:Delete the table containing the specified stringCREATE PROCEDURE Sys_deletetablebytablename (@bianliang varchar (100))AsBeginDECLARE @biao varchar (+), @sql varchar (1000)Set @sql = '% ' [email protected]+ '% 'Declare c cursor for select name from sysobjects where type= ' u ' and name @sqlSet @sql = ' drop table 'Open CFetch C into @biaoWhile @ @fetch_statu

Basic SQL string operations From: http://hi.baidu.com/15960278709/blog/item/bd3507ddf14af3ea76c63805.html -- ======================================================= ====================================== -- Truncates a string from a character and inserts another string hereSelect stuff ('hello, world! ', 4, 4,' *

value * * * *--===================================================================================--============= ======================== Digital Operations Summary ==================================--returns the largest integer of a specified numberSelectFloor123456.1234) --return value 123456--returns the smallest number without a decimal part and not less than the value of its argument. If the argument is an empty sequence, an empty sequence is returnedSelectCeiling123.010) --back to 1

PATINDEX ('%[0-9]% ', LOWER (@pString)) = 0 Then 1ENDRETURN @vJudgeEND4. Function judgment string contains only letters (ignoring case)CREATE FUNCTION [Dbo].fn_isalpha(@pString VARCHAR (8000))RETURNS bitWith encryptionAsBEGINDECLARE @vJudge intSET @vJudge = 0SELECT @vJudge =CaseWhen PATINDEX ('%[a-z]% ', LOWER (@pString)) > 0 Then 0When PATINDEX ('%[a-z]% ', LOWER (@pString)) = 0 Then 1ENDRETURN @vJudgeEND5. Function judgment