Viewing 15 posts - 1 through 15 (of 1,047 total)
It uses the .net framework functionality for scripting that are in the Microsoft.SqlServer.Management.Smo namespace. I wrote a .net command line utility in C# that lets me access these handy scripting features and use it...
November 6, 2017 at 2:17 pm
Why not populate a merged temporary table by selecting from the two sources (ie union all). You now have the row count so then dump your header, the temp table and the trailer...
October 31, 2017 at 1:27 pm
Basically you can use OPENXML to represent the XML data as a relational table. You need to know what flavor of XML you are dealing with though and pass the...
October 31, 2017 at 8:35 am
First of all, I would hope never to receive data of this type in a single file like this. The data should be supplied in two files: One containing ProductID and ProductName,...
October 30, 2017 at 1:11 pm
You could writ a C# class with method(s) to do what you want then create as CLR assembly and user functions. Then you could manipulate the column data directly with...
February 6, 2017 at 2:13 pm
A agree with Jeff. Unless it is relatively simple you should design your database objects and define the relations as it conforms to business rules but also considering what type...
October 19, 2016 at 12:41 pm
The schedule also has an enabled flag. The schedule also may have had an end date.
August 21, 2014 at 10:16 am
You'll need to create a .NET assembly that ultimately calls out to the Java routine. There will be a lot of overhead in this so consider how it will be...
February 26, 2014 at 2:36 pm
videl666 (2/6/2014)Ok, thanks....I was hope that i can do this in other way - not inserting in int table and copying data from it to bigint.....
Well, I supposed you could...
February 6, 2014 at 8:28 am
Okay, then your only other option is to bcp in to a stage table that has ints, then do a final insert into the destination table having the bigints.
February 6, 2014 at 7:29 am
sp_rename won't work on computed columns. Probably have to drop and recreate it. The caution/warning messages are normal output of sp_rename.
February 5, 2014 at 1:16 pm
You don't want to use RAW in this case because it expects the data types to be the same. Use something other than RAW, or use a query out that...
February 5, 2014 at 9:10 am
Your query looks all wrong for one thing, you are using group by with no aggregate so I assume you want to SUM(AMOUNT) for different conditions. And you really don;t...
February 5, 2014 at 9:06 am
With separate file groups you can specify exactly where tables or partitions will be located.
January 30, 2014 at 11:07 am
With SQL Server 2012 Always-On AG you can have active/Readonly-Active cluster without a SAN. You just need two servers set up the same way.
January 28, 2014 at 9:57 am