Viewing 15 posts - 5,251 through 5,265 (of 8,416 total)
Nawar,
Can you confirm that you have followed all the steps exactly as shown in Books Online: http://msdn.microsoft.com/en-us/library/cc645923.aspx?
Paul
March 17, 2010 at 2:03 am
Developer and Enterprise are the same, just the licensing details differ.
March 17, 2010 at 1:58 am
Jeff Moden (3/16/2010)
Most of the ODBC Scalar functions have direct equivalents in T-SQL. But... this one is very interesting...
SELECT d = {fn CURRENT_DATE()}
Yes. Mentioned it a few posts...
March 16, 2010 at 11:18 pm
krakatoa66 (3/16/2010)
You know I am referring to SQLCMD mode inside SSMS, right?
Initially i thought you were referring to the command line tool because using SQLCMD mode within SSMS still...
March 16, 2010 at 11:15 pm
Jeff Moden (3/16/2010)
Was a real SWAG on my part, too! 🙂
Scientific wild-*** guess?
Special Warfare Action Group?
Silly wild-*** guess?
Stuff we all get?
Smart wild-*** guess?
Software wild-*** guesstimate?
Sold without a guarantee?
March 16, 2010 at 10:54 pm
Jeff Moden (3/16/2010)
March 16, 2010 at 10:44 pm
webatxcent (3/16/2010)
March 16, 2010 at 10:26 pm
krakatoa66 (3/16/2010)
Thanks for the suggestion but for a myriad of reasons its just not practical to use SQLCMD for running these type of scripts on our production environment.
You know I...
March 16, 2010 at 10:22 pm
Jeff Moden (3/16/2010)
I assume that by "explicit date" you mean something like '1900-01-01'... and that's not a date either... that's a string that looks like a date. 😛
Aside from using...
March 16, 2010 at 10:14 pm
Jeff Moden (3/16/2010)
Heh... I just can't see writing it this way...
DATEADD(DAY, DATEDIFF(DAY, CAST('19000101' AS DATETIME), CURRENT_TIMESTAMP), CAST('19000101' AS DATETIME))
It's not so bad. How about:
SELECT DATEADD(DAY, DATEDIFF(DAY, {d '1900-01-01'}, CURRENT_TIMESTAMP),...
March 16, 2010 at 10:02 pm
GilaMonster (3/16/2010)
137 - The inverse of the 'fine structure constant'.
...and the 33rd prime number. Retaining the theme of a, you should probably also use 29 (the 10th prime) a...
March 16, 2010 at 9:54 pm
Dehqon D. (3/16/2010)
I'm so sorry that I posted the same massage again and again. I'm totally new, and I didn't realize that my posts are getting to the next page...
:laugh:...
March 16, 2010 at 9:40 pm
Jeff Moden (3/16/2010)
Paul White (3/16/2010)
The tally-table method ... {snip} ... is far, far, superior.Almost as good a a CLR string splitting function in fact.
Heh... keepsake that is right thar...
:laugh: Well,...
March 16, 2010 at 9:35 pm
lmu92 (3/16/2010)
Actually, Goldie already used the Tally solution. I...
March 16, 2010 at 9:34 pm
Viewing 15 posts - 5,251 through 5,265 (of 8,416 total)