Viewing 15 posts - 1,021 through 1,035 (of 3,221 total)
venoym (8/23/2011)
I'm surprised by the number of people who are complaining about the existence of a Test2 db or not. I would...
August 23, 2011 at 6:55 am
Nice to be reminded of basic how things work ....
August 22, 2011 at 8:29 pm
Using OPENROWSET for example:
SELECT * FROM OPENROWSET('Microsoft.jet.OLEDB.4.0','Excel 8.0;DATABASE=c:\temp\items.xls;IMEX=1;HDR=No','SELECT * from
[items$1]')
Note the IMEX setting. If it is NOT present the open rowset reads the first 8 or so...
August 22, 2011 at 10:50 am
Tom.Thomson (8/20/2011)
A nice easy one for Monday morning.I was somewhat surprised to see it before 0100 BST on Sunday, though.
Tom you must have been accessing the QOD when I had...
August 21, 2011 at 2:02 pm
Surprised at the numbers (3 out of 4 incorrect), for what is a rather simple question.
August 20, 2011 at 5:55 pm
To follow up on Lowell's excellent code AND provided that you wanted the 2nd result set from sp_helplogins you could perform the following.
1. Using SSMS, script the code...
August 19, 2011 at 11:10 am
See if this gives you the information you seek.
sp_helplogins
For your information it is located in the Master database.
August 19, 2011 at 8:01 am
Nice question, and even better the first one to answer it correctly ... yea bragging ...... what the heck .....
August 18, 2011 at 8:48 pm
This article on SSC should assist you
http://www.sqlservercentral.com/articles/Advanced+Querying/onthetrailoftheisoweek/1675/
Be sure to read the comments on the article
August 18, 2011 at 6:15 am
Remember:
The @@ERROR function can be used to capture the number of an error generated by the previous Transact-SQL statement. @@ERROR only returns error information immediately after the Transact-SQL statement that...
August 18, 2011 at 6:03 am
You may find the reason by reading this article by Gail Shaw:
http://www.sqlservercentral.com/articles/Transaction+Log/72488/
August 17, 2011 at 8:28 am
August 16, 2011 at 11:43 am
The default time span for Microsoft SQL Server is 1950-2049, which represents a cutoff year of 2049. This means that SQL Server interprets a two-digit year of 49 as 2049,...
August 15, 2011 at 7:05 am
To offset the demise of a few GOOGLE apps, realize that:
Early in the formation of Google.org, Google took the value of 10% of the 3 million shares from Google's...
August 13, 2011 at 3:31 pm
(And the code that splits the string into individual words I have posted is code written by Jeff Moden) that was edited by myself to use your sample data. ...
August 12, 2011 at 3:16 pm
Viewing 15 posts - 1,021 through 1,035 (of 3,221 total)