Viewing 15 posts - 2,041 through 2,055 (of 2,648 total)
TOP 1 is...
November 9, 2018 at 8:43 am
Alternatives are:select * from myTable x
where x.Description like '%text%'
select * from myTable x
where PATINDEX('%text%',x.Description)>0
select * from myTable x
where CHARINDEX('text',x.Description)>0
I doubt...
November 9, 2018 at 7:14 am
You just need to call msdb.dbo.sp_send_dbmail with the right parameters.
November 9, 2018 at 4:47 am
November 8, 2018 at 10:36 am
November 8, 2018 at 8:58 am
November 8, 2018 at 8:47 am
We have 2 heavy SELECT statements in...
November 8, 2018 at 8:36 am
November 7, 2018 at 1:48 pm
;WITH A(A) AS (SELECT '' FROM (VALUES (0),(0),(0),(0),(0),(0),(0),(0),(0),(0),(0),(0),(0),(0),(0),(0)) T(C))
,B(N) AS (SELECT TOP(200) ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) +1000 N FROM A A,A B)
SELECT N SchoolId...
November 7, 2018 at 12:39 pm
November 6, 2018 at 10:30 am
November 6, 2018 at 10:13 am
I am hoping some one can help me as I am nto quite sure...
November 6, 2018 at 7:26 am
November 6, 2018 at 6:33 am
The only noticeable difference between BIN and BIN2 is when you sort them.
November 5, 2018 at 9:34 am
Viewing 15 posts - 2,041 through 2,055 (of 2,648 total)