Viewing 15 posts - 436 through 450 (of 562 total)
Steven Willis (6/12/2013)
Here's another option you might consider:
Thanks for your contribution Steven, but or I do not get your anwser, or you are missing the point.
The question was:
How to get...
June 12, 2013 at 10:25 am
Hello all,
Now that SSC-Enthusiastic has given a short solution to the problem, my solution does not have much value anymore. But I promissed to come up with a more complete...
June 12, 2013 at 7:23 am
patrickmcginnis59 10839 (6/11/2013)
SELECT...
June 11, 2013 at 9:36 am
Ed Wagner (6/11/2013)
When trying to pass a parameter to to the procedure, I cannot get it to work. I tried using 'table_name' and [table_name] and neither syntax worked.
Ok I...
June 11, 2013 at 6:53 am
Sean Lange (6/10/2013)
Secondly, this now has to create a second connection to the same server. Yes it can be done but you have to jump through a lot of hoops...
June 11, 2013 at 6:04 am
Sean Lange (6/10/2013)
Secondly, this now has to create a second connection to the same server. Yes it can be done but you have to jump through a lot of hoops...
June 10, 2013 at 11:19 am
bitbucket-25253 (6/10/2013)
This discussion of the subject may be of help to you.
As you can see in the third message in this thread I allready mentioned exactly that link. The referenced...
June 10, 2013 at 11:09 am
Dird (6/10/2013)
Do you mean calculate more accurately the size before actually creating the table?
At the moment I am trying to do the calculation on existing tables. This allows me to...
June 10, 2013 at 10:28 am
Ed Wagner (6/10/2013)
Since the results generated by a stored procedure vary by procedure in both number and type, I don't see how you could create a table to work with...
June 10, 2013 at 9:59 am
PaulB-TheOneAndOnly (6/10/2013)
ben.brugman (6/10/2013)
So how can I calculate the size more accurately?The actual space used by a table is what sp_spaceused reports.
Thanks for your reply, but this does not anwser my...
June 10, 2013 at 8:15 am
sturner (5/29/2013)
I could make the source available, it is written in C# with .net 3.5 runtime (IIRC).
Thanks for the offer, I am not proficient enough with C#.
Problem with the wizard...
May 30, 2013 at 9:37 am
Evgeny (5/29/2013)
You can start from:select * into dbo.newtable
from dbo.oldtable
if you need new table to be populated with old table data, then you can add required constraints and indexes.
I do...
May 29, 2013 at 9:43 am
Lynn Pettis (5/29/2013)
May 29, 2013 at 9:40 am
codebyo (5/28/2013)
Couldn't you do a smart replacing in a text editor to change the part of the index's name the mentions the...
May 29, 2013 at 7:42 am
GilaMonster (5/28/2013)
May 29, 2013 at 7:36 am
Viewing 15 posts - 436 through 450 (of 562 total)