Forum Replies Created

Viewing 15 posts - 631 through 645 (of 790 total)

  • RE: Output from dynamic sql

    Here's an example:

    declare @sqlstring nvarchar(1000), @table_name varchar(25)

    declare @result int

    

    set @table_name = 'pubs.dbo.authors'

    set @sqlstring = 'select @c = count(*) from ' + @table_name

    

    exec sp_executesql @sqlstring, N'@c...


    Cheers,
    - Mark

    July 10, 2003 at 5:12 am

    #464792

  • RE: Sorting a date column

    I can't see why they would be displayed in dd/mm/yyyy format, order from earliest to latest. Can you post an example of out of sequence dates?


    Cheers,
    - Mark

    July 10, 2003 at 5:07 am

    #464787

  • RE: Sorting a date column

    Your query looks ok. When you say you're not getting the desired results, what do you mean? Not the required ordering? Not getting the required output formats?

    ...


    Cheers,
    - Mark

    July 10, 2003 at 2:22 am

    #464769

  • RE: SQL Server Considerations

    quote:

    1) Can I host all the SQL Servers on one powerful machine under windows 2000?


    Cheers,
    - Mark

    July 9, 2003 at 3:09 pm

    #464749

  • RE: Select 2 lines into 1

    You must also note the SQL does not guarantee the order in which results are returned if you have no ORDER BY clause. Even though you may currently be...


    Cheers,
    - Mark

    July 9, 2003 at 6:44 am

    #464676

  • RE: weekly and monthly rollups in 7.0

    I might be misunderstanding the question. COMPUTE BY is available in SQL 7.0. Can you post the SQL2000 query?


    Cheers,
    - Mark

    July 9, 2003 at 3:34 am

    #464644

  • RE: Collation SQL Challenge

    Following on from Nigel's post, your first SELECT could be coded as:

     

    SELECT CAST(THE_ID AS VARCHAR(8)) + THE_VALUE COLLATE DATABASE_DEFAULT FROM @table_a  

    UNION

    SELECT CAST(THE_ID AS...


    Cheers,
    - Mark

    July 8, 2003 at 6:59 am

    #464482

  • RE: Table Variable question

    B) SQL_Latin1_General_CP1_CI_AS


    Cheers,
    - Mark

    July 8, 2003 at 6:50 am

    #464477

  • RE: Backup from Standby

    My guess is that replication will put a much higher load on your production server than just a plain backup will. Replication can also have administrative overheads. IMHO...


    Cheers,
    - Mark

    July 8, 2003 at 6:23 am

    #464462

  • RE: the update() function in a trigger

    No, I was saying that the INSERT INTO command will return true for update() for all columns, regardless of whether NULLS or empty strings are assigned.

    The following will return false...


    Cheers,
    - Mark

    July 7, 2003 at 2:38 pm

    #464387

  • RE: Error 997 GetProxyAccount

    Here's the URL from hell . I hope it posts ok and navigates ok for you. It shows a discussion and resolution for similar symptoms....


    Cheers,
    - Mark

    July 6, 2003 at 3:33 am

    #464225

  • RE: regarding stored procedure looping

    Hard to tell without you posting the actual code. Where does SP3 come into play?

    Have you tried a series of PRINT, SELECT or RAISERROR...NOWAIT statements to track values of...


    Cheers,
    - Mark

    July 5, 2003 at 3:51 pm

    #464221

  • RE: How do I make a stored proc ingore an error?

    SQL Server is checking compliance with constraints before your code checks @@error. It will not allow duplicates in the primary key and so throws the error regardless of how...


    Cheers,
    - Mark

    July 5, 2003 at 3:46 pm

    #464220

  • RE: Role script

    You may have to generate a script larger than intended and then extract the bit you want.

    In EM, right click on DB name, All Tasks, Generate SQL Script, General tab...


    Cheers,
    - Mark

    July 5, 2003 at 3:37 pm

    #464219

  • RE: the update() function in a trigger

    When you UPDATE the row but not SET that particular column to any value


    Cheers,
    - Mark

    July 5, 2003 at 3:23 pm

    #464218

Viewing 15 posts - 631 through 645 (of 790 total)