Viewing 15 posts - 56,041 through 56,055 (of 59,067 total)
Then there's THAT
Works almost everytime...
June 22, 2007 at 1:24 pm
If you use OSQL with the -h-1 option and the -o option, something like the following works very well...
USE Northwind
SET NOCOUNT ON
SELECT QUOTENAME('CustomerID','"')+','
+ QUOTENAME('CompanyName','"')+','
+...
June 22, 2007 at 1:17 pm
My pleasure... however, Wayne is correct... his method not only inherently checks the row counts, it also checks the actual data...
June 22, 2007 at 1:06 pm
Heh... understood and no worries... you've just got my curiosity up especially on the performance thing...
June 22, 2007 at 8:15 am
Sorry... missed the fact that you were still working on this to take variables... I'll take a crack at it over the weekend...
June 22, 2007 at 8:00 am
Sorry... didn't read the whole thread... I pretty much repeated what David McFarland already posted.
June 22, 2007 at 6:21 am
Agreed... BIGINT will certainly work... But consider a couple of things before you decide to use any numeric datatype for any "numbers" column such as credit card numbers, bank account numbers,...
June 22, 2007 at 6:19 am
Gosh, you would think so... I guess I understand why some folks don't, though... some DBA's don't practice what I consider to be the cardinal rule of being a DBA...
June 22, 2007 at 5:58 am
Once again, your ideas are extemely sound, but I see no code from you...
June 21, 2007 at 11:38 pm
Start with OSQL -L
June 21, 2007 at 11:35 pm
I agree with Aaron and Remi... there is no need for any dynamic SQL here. Also, you must follow Aaron's suggestion for how to test for the presence of a...
June 21, 2007 at 11:31 pm
Bond a DBA or whatever is necessary, but no matter what the circumstance, the DBA must be a trusted individual in order to protect the very security required by SOX......
June 21, 2007 at 11:27 pm
First of all... INT is NOT capable of storing a 16 digit number so just forget about that.
Serqiy's idea is great but you must take that one step further... every...
June 21, 2007 at 11:22 pm
And, to add to Seqiy's good questions, what does the table parameter look like? Is it merely 2 dimensional or is it N dimensional?
June 21, 2007 at 11:16 pm
Viewing 15 posts - 56,041 through 56,055 (of 59,067 total)