Viewing 10 posts - 346 through 355 (of 355 total)
Matt Marston (9/30/2009)
September 30, 2009 at 10:07 am
Warren Gilbert (9/30/2009)
September 30, 2009 at 9:03 am
I don't understand how it could return both the current and the last timestamp used. According to MSDN, @@DBTS returns the last-used timestamp value of the current database. A...
September 23, 2009 at 8:24 am
This one caught me too. In 2000, it was a table but they switched it to a view in 2005 for backwards compatibility. The question specifically asks about...
August 28, 2009 at 5:05 am
This one tricked me. I didn't know all three versions used different exe files so when I saw the one I recognized, I selected it and got it wrong....
July 31, 2009 at 9:47 am
Although I got the question right (I did not notice the extra comma), I agree this is a bad question. When you get the error message, no records get...
July 17, 2009 at 5:45 am
Suppose it depends on which query tool you use. If you use the one built into Microsoft SQL Server Management Studio, it does display in scientific notation.
SQLDBX displays as...
June 26, 2009 at 7:58 am
SQL 2005 actually displays the answer as 1234567936. I tested this to make sure. The scientific notation might only be displayed depending on your local configuration options.
June 26, 2009 at 7:12 am
Here's the ultimate method.
I tried to create an example using the identity column but it required additional queries which wasn't so efficient. Still, it was more efficient than creating...
May 26, 2009 at 4:24 am
If I'm not mistaken, since this uses the identity column, it might not always produce the same number of columns. For example, if you deleted a couple rows in...
May 22, 2009 at 8:39 am