Forum Replies Created

Viewing 15 posts - 4,501 through 4,515 (of 5,356 total)

  • RE: QOD Cheats

    Hi Ritch,

    quote:

    If people were cheating to achieve something I think it would be a different matter entirely, but how much are they...

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

    July 25, 2003 at 1:47 am

    #466981

  • RE: How To Delete a Default Constraint

    Hi wmp789,

    quote:

    I dropped the constraint successfully 🙂

    Thank you, Frank, for your help.

    I am still confused about DROP DEFAULT...

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

    July 25, 2003 at 12:19 am

    #466971

  • RE: Converting hex to int

    Hi Chris,

    quote:

    Did you try the function I submitted?? damn site simpler! 🙂

    This was a port from an old classic C function

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

    July 25, 2003 at 12:07 am

    #466968

  • RE: Update Query and Joins in EM vs. Query Analyser

    quote:

    You can stay, Frank. I just get queezy when I see the words "Upsizing Wizard".

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

    July 25, 2003 at 12:00 am

    #466967

  • RE: Update Query and Joins in EM vs. Query Analyser

    quote:

    Oh, jeez, Frank. Now you're giving me a headache!

    ohoh,...

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

    July 24, 2003 at 8:55 am

    #466842

  • RE: How to determine persons age

    Hi rgetsy,

    quote:

    Given birthdate in datetime format and a given date in the future, how do I determine the persons age? Remember...

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

    July 24, 2003 at 8:48 am

    #466839

  • RE: Update Query and Joins in EM vs. Query Analyser

    Hi Dale,

    quote:

    Well, I'll be honest with you. When I'm creating complex queries in MS Access, I feel much more secure that...

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

    July 24, 2003 at 8:46 am

    #466838

  • RE: Dynamic Columns

    Hi Richard,

    quote:

    Thanks Frank. I think you've got it but let me make sure. You're saying create the 'Create Table' statement...

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

    July 24, 2003 at 8:39 am

    #466833

  • RE: Converting hex to int

    Hi Timingskey,

    quote:

    Guarddata,

    It didn't work for me. I thought it did, but then I realized that it returned the wrong value.

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

    July 24, 2003 at 7:50 am

    #466806

  • RE: QOD Cheats

    quote:

    Yes. But I thought there were compatibility problems if you tried certain things? Have you had any problems?

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

    July 24, 2003 at 7:43 am

    #466799

  • RE: QOD Cheats

    quote:

    I agree with what has been stated. I use testing,BOL and searching the Web to find answers depending on the question. I...

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

    July 24, 2003 at 7:33 am

    #466793

  • RE: Dynamic Columns

    Hi RKS,

    quote:

    I have a table that has fields 'ColPosition'(int) and 'ColName'(char200) and a 'Jobid'(int). I will not know how many 'ColPosition'...

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

    July 24, 2003 at 7:29 am

    #466790

  • RE: QOD Cheats

    quote:

    It makes a difference. Let's say I only answer using my personal knowledge and never use BOL or any other reference (don't...

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

    July 24, 2003 at 6:58 am

    #466782

  • RE: Converting hex to int

    quote:

    I'm on Standard Edition. Check one of our live servers and surprise, surprise it's not there. Only exists in our dev box....

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

    July 24, 2003 at 4:10 am

    #466750

  • RE: Converting hex to int

    quote:

    In Master. I'm on SQL7 SP4 may be it has been dropped in later versions!

    Same...

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

    July 24, 2003 at 3:40 am

    #466745

    • Viewing 15 posts - 4,501 through 4,515 (of 5,356 total)