Viewing 15 posts - 1,096 through 1,110 (of 3,221 total)
Jeff Moden (7/19/2011)
bitbucket-25253 (7/19/2011)
July 19, 2011 at 9:49 pm
[Rant]
After getting the supposed incorrect answer, I cut and pasted the code into SQL 2005 and then again into 2008. Ran each not less than 15 times and ALWAYS...
July 19, 2011 at 9:33 pm
krishusavalia (7/19/2011)
Its giving me Error:Error Msg:
Msg 7403, Level 16, State 1, Line 1
The OLE DB provider "Microsoft.Jet.OLEDB.4.0" has not been registered.
Sorry for being so long in getting back to you.
Do...
July 19, 2011 at 7:36 pm
Download and install from:
http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=5793
July 19, 2011 at 1:21 pm
You could use OPENROWSET for example:
-- table to text file. Text file must have a first line of comma separated field names
--and select must be by column name
INSERT...
July 19, 2011 at 11:43 am
Having had the pleasure of meeting Jeff Moden, at the speakers / volunteers dinner prior to SQL Sat #60 (Cleveland), let me tell you Jeff is not only an exceptional...
July 19, 2011 at 8:07 am
Nice easy question .. and thank goodness one that will NOT provoke arguments and the begging for "I want my points"
So thank you
July 18, 2011 at 9:28 pm
Far from being the first to answer the question and most likely not the last to learn more about a complex subject. Thanks Steve for introducing me a facet...
July 17, 2011 at 9:46 am
You are more likely to get additional tested assistance if you post the table definitions, some sample data and required results. To do this quickly and easily read the...
July 16, 2011 at 1:41 pm
A question, when performing the select do use either a UNION or UNION ALL statement(s) in the T-SQL ?
Next if you would post your T-SQL along with table...
July 16, 2011 at 12:34 pm
It has been too many years since I last touched ACCESS, but if memory servers me correctly isn't the text data type (ACCESS), limited to 255 characters.
My only suggestion would...
July 15, 2011 at 5:21 pm
And the Author hasn't defended his position?
What is there to defend.. it is an obvious goof, should have been caught before being scheduled. Steve use to do...
July 15, 2011 at 4:12 pm
Trey Staker (7/15/2011)
Good question thanks! (SSC must of fixed it by reading previous comments.)
[Rant]
Yes they appear to have changed the answer to the correct values, but as far as...
July 15, 2011 at 11:45 am
Sorry but do not understand the problem, do you mean to say that the CONTENTS of the SQL column are NULL for all rows in that table, or that the...
July 15, 2011 at 11:35 am
Some thing seriously incorrect about this:
Correct answer: Standard, Enterprise .
Explanation: In SQL Server 2008 R2, database snapshots are only supported in Enterprise and Data Center...
July 14, 2011 at 9:06 pm
Viewing 15 posts - 1,096 through 1,110 (of 3,221 total)