Viewing 15 posts - 1,996 through 2,010 (of 4,087 total)
Just use the TOP option in your DELETE statement.
DECLARE @page_size INT = 50000;
WHILE @@ROWCOUNT > 0
BEGIN
DELETE TOP (@page_size) YourTableNameHere
...
January 18, 2017 at 3:17 pm
For those interested in how to unpivot a multi-row table, you do need some form...
January 18, 2017 at 1:04 pm
January 18, 2017 at 8:52 am
January 17, 2017 at 3:24 pm
Reported as spam.
January 17, 2017 at 2:38 pm
January 17, 2017 at 2:22 pm
Reported as spam.
January 17, 2017 at 2:11 pm
January 17, 2017 at 11:38 am
January 17, 2017 at 10:41 am
Just add
, cnt = COUNT(*) OVER()
You need the OVER clause, because there is no group by, but you don't have to have any partition or...
January 17, 2017 at 10:12 am
dianerstein 8713 - Friday, January 13, 2017 11:04 AMAre you saying there is no solution to this problem?
No, I'm saying that it's not...
January 13, 2017 at 2:24 pm
January 13, 2017 at 9:24 am
SELECT stulink,stringtemplate,updateddate=MAX(updateddate)
FROM atlltr
WHERE (atlltr.language IS NOT NULL)
AND (atlltr.stringtemplate IS NOT...
January 13, 2017 at 9:08 am
January 12, 2017 at 1:21 pm
Viewing 15 posts - 1,996 through 2,010 (of 4,087 total)