Forum Replies Created

Viewing 15 posts - 4,591 through 4,605 (of 5,356 total)

  • RE: tracking updates on tables

    quote:

    oh, and one more thing - (this is classic) - put in a trigger on the table that will randomly show managers...

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

    July 18, 2003 at 6:43 am

    #466009

  • RE: Smily question

    quote:

    EIGHTBALL

    'Eightball' is a highly uncomplimentary slang word standing for a rather objectionable character ('gold brick', 'goof'). The word owes its origin to...

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

    July 18, 2003 at 4:42 am

    #465996

  • RE: comparing specific rows

    No insult, Andrew!

    quote:

    Very dry Frank, thanks.

    Next time I want to speak to a comedian Ill go on a joke site...

    If riding in...

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

    July 18, 2003 at 4:38 am

    #465995

  • RE: comparing specific rows

    Hi Andrew,

    quote:

    Declare @@var varchar(255)

    select @var = t1.datefield from Table1 t1

    Where t1.Primarykey=8439

    I presume 8439 is merely a random number youve picked out.........how can...

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

    July 18, 2003 at 4:35 am

    #465992

  • RE: comparing specific rows

    Hi Andrew,

    quote:

    I presume 8439 is merely a random number youve picked out.........how can i make it so it works for any instance...

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

    July 18, 2003 at 4:29 am

    #465990

  • RE: user permissions for tables

    quote:

    I wanna support Oracle,MSSQL,Sybase , and i wanna to execute query or stored procedure to get the tables so that i can...

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

    July 18, 2003 at 4:14 am

    #465989

  • RE: How can i find a the date of birthday ?

    quote:

    Oh, another thought. What day will you use for people who were born leap-day. I didn't account for that.

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

    July 18, 2003 at 4:09 am

    #465985

  • RE: user permissions for tables

    Hi anilkumarsh,

    quote:

    how can we find out all tables which as select permissions for a particular user,

    I wanna load all the tables, which...

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

    July 18, 2003 at 4:06 am

    #465983

  • RE: Review: EditPlus

    quote:

    hm ... UltraEdit is better than Edit plus ... IMHO ... I'm using UE from 6.x version and UE is my preferred...

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

    July 18, 2003 at 3:46 am

    #465979

  • RE: comparing specific rows

    quote:

    Cheers for the humour Frank! Must be the German hospitality that Im oh so fond of..Regards

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

    July 18, 2003 at 2:53 am

    #465975

  • RE: comparing specific rows

    Hi Preethi,

    quote:

    The point is this:

    Since you are getting the value into a variable, (Which can hold only one value at a time)...

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

    July 18, 2003 at 2:45 am

    #465973

  • RE: comparing specific rows

    Hi Andrew,

    quote:

    Where does this line of code come from:?id=

    (SELECT MAX(id) FROM svrmonitor)

    originally from the keyboard,...

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

    July 18, 2003 at 2:36 am

    #465970

  • RE: comparing specific rows

    Hi Andrew,

    quote:

    Is there a way to assign each of the values, i.e. t1.datefield to a variable....

    i beleive the code would be

    DECLARE @var...

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

    July 18, 2003 at 2:27 am

    #465968

  • RE: Review: EditPlus

    Hi there,

    another free editor is http://www.meybohm.de/index.html Phase 5.

    Don't panic, when going to this site. Although it look like one, it isn't a hacker's site

    Let me...

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

    July 18, 2003 at 2:22 am

    #465965

  • RE: Windo authentication &SQL7/SQL2000 in a applic

    Hi freewarefw

    quote:

    Shas3, you're right. there is that I am thinking. We need a blind login to have the right to connect to...

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

    July 18, 2003 at 12:58 am

    #465959

    • Viewing 15 posts - 4,591 through 4,605 (of 5,356 total)