Forum Replies Created

Viewing 15 posts - 4,036 through 4,050 (of 5,356 total)

  • RE: ADO and Joins

    Hi Brian,

    can you post what you've got so far? SQL Statement, Delphi code...

    Cheers,

    Frank

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

  • RE: Passwords stored in columns

    Do you store unencrypted passwords in a db?

    Seems to be pretty challenging! Something like 'Overclocking your server'

    Now being serious.

    Your users need to have access...

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

  • RE: >100,000 Members ? HippHippHurray !!!

    Thanks Dale

    quote:


    My congrats to James Travis (Antares686), Frank Kalis, and Allen Cui for your valuable and entertaining contributions!


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

  • RE: SQL Server Mag User Study

    Hi Brian,

    quote:


    I completed it again. I liked the SQL Server hat and my son won't give it up.


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

  • RE: Can we 'tie' two or more threads together?

    quote:


    I agree about moving or merging threads. But let us say I see a post about datetime datatype and I know of...

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

  • RE: Acumulated sums...

    quote:


    There are many solutions to most problems and of course you can use a cursor in this case. However another option depending...

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

  • RE: Shrinking Data file

    Hi control,

    quote:


    I have a database (2000 version) that the data file grow so large. I have shrink the file using shrinkfile command....

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

  • RE: Seeking Sql Server Experts in Brighton UK

    quote:


    Try the UK Sql Server User Group which can be found at http://www.sqlserverfaq.com/


    I always thought...

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

  • RE: QOD 8/29

    Hi Brian,

    quote:


    What is the outcome of this dispute? I think those of us who chose answer (1) should be credited with...

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

  • RE: building a select query in a stored procedure

    quote:


    If you use the Exec command with a parameter, you may wish to validate the input for sql injection

    e.g.

    exec p 'master..syslogins ;...

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

  • RE: Can we 'tie' two or more threads together?

    Hi SQLBill,

    quote:


    I have seen the same or similar threads many times. For example, in the Question Of the Day forum there are...

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

  • RE: Reporting Services Forum

    quote:


    Ok. Guess I need to look over the structure and see what else needs to be added/dropped.


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

  • RE: Reporting Services Forum

    Hi Andy,

    quote:


    Ok. Guess I need to look over the structure and see what else needs to be added/dropped.


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

  • RE: I would like to create a function that......

    Hi Lenard,

    quote:


    I ended up using a cursor approach. What I do, is read in my list an item at a time,...

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

  • RE: A virtual drink for everyone !!!

    quote:


    [font=Comic Sans MS]Frank, the photo was for a Microsoft thing. I doubt that it is still on-line. It was years ago (I've...

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

  • Viewing 15 posts - 4,036 through 4,050 (of 5,356 total)