Viewing 15 posts - 5,686 through 5,700 (of 13,877 total)
April 21, 2017 at 6:04 am
April 21, 2017 at 5:48 am
A more efficient way of coding this is to perform the deletion and then check @@ROWCOUNT afterwards, thus hitting the table once per deletion rather than twice.
April 21, 2017 at 5:45 am
Try running in 64 bit mode and see what happens.
April 20, 2017 at 3:50 pm
As SQL Server Express Edition does not support Integration Services, what do you expect SSDT...
April 20, 2017 at 11:59 am
As you already have a DMS, how is SQL Server involved in this?
April 20, 2017 at 10:03 am
Please post a screen shot of the screen where you have configured the parameter mappings.
April 20, 2017 at 9:58 am
April 20, 2017 at 7:59 am
'Forgiving' is not the word I would use, more like 'silently truncating data'. Here is some code to demonstrate the validity of Eirikur's suggestion.
SET ANSI_WARNINGS OFF;
IF...
April 20, 2017 at 7:37 am
shanegair - Thursday, April 20, 2017 7:14 AMSorry for the bad post, reading article now to get understanding of how to properly post.
I...
April 20, 2017 at 7:30 am
April 20, 2017 at 6:57 am
Thom, you should probably check this 🙂
April 20, 2017 at 6:56 am
April 19, 2017 at 10:42 am
April 19, 2017 at 7:28 am
April 19, 2017 at 6:55 am
Viewing 15 posts - 5,686 through 5,700 (of 13,877 total)