Viewing 15 posts - 52,696 through 52,710 (of 59,064 total)
Heh... don't forget about DBCC SHOWCONTIG WITH TABLERESULTS
January 30, 2008 at 3:58 pm
Didn't you read any of the above? Don't use ISQL... use OSQL or SQLCMD depending on which version of SQL you have.
January 30, 2008 at 6:08 am
bonk (1/29/2008)
I agree with you! But there's nothing to do in this case. I explain: the table with one column for each month already exists and I can't modify...
January 30, 2008 at 5:59 am
It's because ISQL is just a subset of what the server can actually do. Do NOT use ISQL. Use OSQL instead.
January 29, 2008 at 8:03 am
I agree with Matt... recursion is probably not the best way to do things like this...
There are variations on this theme but here's a nice little NON-recursive CTE that...
January 29, 2008 at 7:59 am
It that case... might be OSQL... THAT does have such a set of switches... if memory serves, "-h-1" (no spaces, no quotes) would be the switch you're looking for.
January 28, 2008 at 2:02 pm
I would like to know how can I read a record from a table with 12 columns (each on for each month in a year) end put the value for...
January 28, 2008 at 1:59 pm
Think "Library"... it's easier to find the books if they're all in order... it's just about that simple. There are tools for defragging disks and tools for defragging database...
January 28, 2008 at 1:52 pm
Would you carefully fill in the question marks to meet the Friday/Saturday rules on the following, please... again, not trying to be difficult... trying to get it right...
EmpID Date ...
January 28, 2008 at 7:02 am
Jeff i think you don't wont to help
only make it difficult
you think i am don't know "how to make simple schedule" or bother you in purpose
you are insult me...
January 27, 2008 at 8:59 am
"GO" isn't actually a part of T-SQL and it can't be used the way you want in Dynamic SQL...
January 26, 2008 at 6:07 pm
So, why do you have to count down from the middle of the month and count up from that same date to the end. And, why does the secretary...
January 26, 2008 at 5:41 pm
Are you sure we're talking BCP 'cause BCP doesn't output column headers and can't be made to do so... it requires a UNION in a proc to output column headers...
January 26, 2008 at 9:11 am
How many rows are you loading with BULK INSERT?
January 26, 2008 at 8:43 am
Philip Barry (1/25/2008)
Is this principal of limiting the number of rows for the deletion operation also applicable to updating? I have to update several hundred thousand rows and I...
January 26, 2008 at 8:06 am
Viewing 15 posts - 52,696 through 52,710 (of 59,064 total)