Forum Replies Created

Viewing 4 posts - 1 through 5 (of 5 total)

  • RE: Stop error being reported.

    Kelvin Phayre (10/9/2009)

    This indeed would be a solution if I was using 2005!

    Well if you are using SQL 2000 then in that case I believe the @@ERROR can be of...

    Thanks,
    Dhimant

    October 10, 2009 at 1:08 am

    #1064435

  • RE: How the query is being executed if WHERE returns FALSE?

    Garadin (10/8/2009)

    Just because your query doesn't return any rows, it doesn't mean that the server didn't have to read through a large amount of data to come to the conclusion...

    Thanks,
    Dhimant

    October 9, 2009 at 1:13 am

    #1063892

  • RE: How to find largest value in a subquery

    How about this ?

    DECLARE @Table_A TABLE( id INT IDENTITY ( 1 , 1 ),data VARCHAR(25) )

    DECLARE @Table_B TABLE( id ...

    Thanks,
    Dhimant

    October 9, 2009 at 1:02 am

    #1063888

  • RE: Stop error being reported.

    I'm not sure whether you're already doing it or not, but you can use the try...catch block to achieve this. Below is a small sample.

    CREATE PROC testerror

    AS

    BEGIN TRY

    SELECT...

    Thanks,
    Dhimant

    October 9, 2009 at 12:37 am

    #1063879

Viewing 4 posts - 1 through 5 (of 5 total)