Viewing 11 posts - 1 through 11 (of 11 total)
Scenario 2 doesn't have a NOT IN in the original statement...I believe it belongs here:
select DISTINCT Name
from Production.Product
where ProductID IN (Select ProductID from Purchasing.ProductVendor
...
February 26, 2015 at 8:24 am
Glad to hear the system thinks for its authors...LOL
December 18, 2009 at 3:27 pm
OK, so I didn't think the second statement was true, and apparantly it is...
That isn't my problem with the question, my problem is (as stated before) authors don't know how...
December 18, 2009 at 3:06 pm
We need to define a column that will contain externally provided identifiers. Their
(1) length will vary from seven to ten characters
(2) all English letters
(3) both upper and lower case...
November 2, 2009 at 4:02 pm
In computer science, a B-tree is a tree data structure that keeps data sorted and allows searches, insertions, deletions, and sequential access in logarithmic amortized time. The B-tree is a...
October 5, 2009 at 11:59 am
http://msdn.microsoft.com/en-us/library/ms187366.aspx
SQL Server 2008 Books Online (August 2009)
@@DBTS (Transact-SQL)
"Returns the value of the current timestamp data type for the current database. This timestamp is guaranteed to be unique in...
September 24, 2009 at 10:21 am
I too answered 'no' based upon the example...perhaps the example shouldn't have been given and just the question asked, but if you ran the given statement, it would certainly fail...
September 24, 2009 at 9:51 am
That is good to know the next time I want to:
A.) Convert an interger to a varchar then
B.) Convert that varchar to a smaller varchar then
C.) Cast...
August 20, 2009 at 3:59 pm
None of the Above???
I received this as my results:
1899-12-31 00:00:00.000
Did the question change over time, too?
July 9, 2009 at 11:34 am
if you have ever worked with localization, the answer is clearly nchar(1)...
July 9, 2009 at 10:31 am
We were unable to get any of these remedies to work. What we ended up doing (on a 64-bit Server - may have been the Jet Driver problem to...
November 20, 2008 at 4:15 pm
Viewing 11 posts - 1 through 11 (of 11 total)