Forum Replies Created

Viewing 6 posts - 1 through 6 (of 6 total)

  • RE: Querying the INFORMATION_SCHEMA

    That does the trick!

    Thanks!

  • RE: Querying the INFORMATION_SCHEMA

    Microsoft SQL Server Management Studio9.00.1399.00

    Microsoft Analysis Services Client Tools2005.090.1399.00

    Microsoft Data Access Components (MDAC)2000.085.1117.00 (xpsp_sp2_rtm.040803-2158)

    Microsoft MSXML2.6 3.0 4.0 5.0 6.0

    Microsoft Internet Explorer7.0.5730.11

    Microsoft .NET Framework2.0.50727.832

    Operating System5.1.2600 (XP Pro 2002 SP2)

  • RE: Querying the INFORMATION_SCHEMA

    Definitely there's some option/setup in SSMS -- even on the builtins, if I put single quotes around the string and press Alt-F1, it gives me the error:

    Incorrect syntax near 'sp_help'.

    I...

  • RE: Querying the INFORMATION_SCHEMA

    It appears that whatever you hightlight is passed to the stored procedure as a single string. It doesn't parse out commas, and positively objects to quotes.

    So I bent to...

  • RE: Best Way to Calculate Age

    Interesting fact to know about DATEDIFF -- seems like the wrong way to code it to me, but oh well . . .

    Actually, none of the answers are right. ...

  • RE: Generate Drop / Create Script for views, stored Procedures

    One can also use this for functions, defaults, rules, and triggers

Viewing 6 posts - 1 through 6 (of 6 total)