Viewing 15 posts - 5,911 through 5,925 (of 13,877 total)
Here's the code again, formatted for readability:
BEGIN TRY
BEGIN TRAN;
IF (
1 = 2
)
BEGIN
...
February 22, 2017 at 7:31 am
February 22, 2017 at 7:28 am
February 21, 2017 at 7:19 am
February 20, 2017 at 1:00 pm
I have an SSIS package that outputs a .csv file to a folder on an internal...
February 20, 2017 at 9:49 am
I am a power shell newbie , looking to import SQL server version information...
February 17, 2017 at 1:17 pm
February 17, 2017 at 6:42 am
February 16, 2017 at 2:22 pm
February 16, 2017 at 2:18 pm
Note that having mega packages which do everything is generally regarded as a bad design practice. When things go wrong, errors become difficult to track down and solve and maintenance...
February 16, 2017 at 2:16 pm
My SSIS project, developed in Visual Studio 2012 under my Windows user account, includes two packages,...
February 16, 2017 at 1:13 pm
I have created a SSIS project. In that I have created 3 dtsx packages (Mastertable.dtsx ,...
February 16, 2017 at 1:11 pm
February 16, 2017 at 12:11 pm
Change your proc to access a 'how many?' parameter and then use something like this:
DECLARE @n INT = 10;
SELECT TOP (@n) RAND(CHECKSUM(NEWID()))
FROM (VALUES(0),(0),(0),(0),(0),(0),(0),(0),(0),(0)) a(n)
February 16, 2017 at 11:25 am
February 16, 2017 at 10:45 am
Viewing 15 posts - 5,911 through 5,925 (of 13,877 total)