Viewing 15 posts - 1 through 15 (of 72 total)
Have you tried enclosing the value in single-quotes?
I mean JSON_MODIFY(@j, 'append $.size', '1000')
Please let us...
May 1, 2017 at 6:34 am
March 9, 2017 at 2:48 am
February 13, 2017 at 5:48 am
this SELECT has nothing to rollback ! and its about 2 days that this query is rolling back !
I had this issue before and It resolve when Sql Server...
February 13, 2017 at 1:25 am
after along time finally process were killed and I couldn't check sp_whoisactive !
what build of SQL Server are you on?
Microsoft SQL Server 2014 (SP2) (KB3171021) - 12.0.5000.0 (X64)
Jun...
November 30, 2016 at 3:38 am
GilaMonster (11/15/2016)
November 15, 2016 at 4:00 am
GilaMonster (11/15/2016)
farax_x (11/15/2016)
Are the wait times long?less than a second (about 8 miliseconds)
That's pretty low. Is this wait causing a problem?
What is the session that's waiting trying to do?
The applications(8...
November 15, 2016 at 3:32 am
Is this a common wait?
yes, Every time I query sys.dm_exec_requests I saw that
Are the wait times long?
less than a second (about 8 miliseconds)
What is the session that's waiting trying...
November 15, 2016 at 3:22 am
Eirikur Eiriksson (10/9/2016)
farax_x (10/9/2016)
DECLARE @input NVARCHAR(max) = N'
test
test https://telegram.me/hiberd_com hihihihihi
hihihihihi
October 9, 2016 at 5:29 am
Eirikur Eiriksson (10/9/2016)
😎
USE TEEST;
GO
SET NOCOUNT ON;
DECLARE @input NVARCHAR(max) = '
hihihi
hihihi
hihihi
https://telegram.me/joinchat/BW0OCzvs1F6frTkUj2HEAQ
hihihi
hihihi
hihihi
https://telegram.me/joinchat/DigSjj6xZYsI_H2GRjtNQQ
hihihi
hihihi
hihihi
hihihi
http://telegram.me/ZOJ20/10236
';
;WITH T(N) AS (SELECT N FROM (VALUES (0),(0),(0),(0),(0),(0),(0),(0),(0),(0)) AS X(N))
, NUMS(N) AS (SELECT...
October 9, 2016 at 5:06 am
farax_x (10/9/2016)
I have string like this :
DECLARE @input NVARCHAR(max) = '
hihihi
hihihi
hihihi
https://telegram.me/joinchat/BW0OCzvs1F6frTkUj2HEAQ
hihihi
hihihi
hihihi
https://telegram.me/joinchat/DigSjj6xZYsI_H2GRjtNQQ
hihihi
hihihi
hihihi
hihihi
http://telegram.me/ZOJ20/10236
'
and I want to extract all Urls from this string :
result
--------
https://telegram.me/joinchat/BW0OCzvs1F6frTkUj2HEAQ
October 9, 2016 at 5:03 am
Problem solved 🙂
SELECT j.name AS JobName
,sch.name AS ScheduleName
,'EXECUTE msdb..sp_update_jobschedule @job_name = ''' +...
May 29, 2016 at 6:09 am
Viewing 15 posts - 1 through 15 (of 72 total)