Forum Replies Created

Viewing 15 posts - 376 through 390 (of 1,048 total)

  • RE: error

    Voide (7/16/2013)

    riya_dave (7/16/2013)

    hi

    select * from tableA with(nolock) a

    join tableB with(nolock) b

    on a.id = b.id

    where a.date > getdate()

    i am getting error incorrect syntax near a

    As Gail said, why nolocks?

    Also alias...

    July 17, 2013 at 1:18 am

    #1633099

  • RE: delete rows

    Hi Riya, its better if you keep of your old data in some temp table and then insert the new data....

    first insert the old data into a temp table...

    July 17, 2013 at 12:54 am

    #1633090

  • RE: Unexpected Behaviour With SQL Server :,(

    Shadab Shah (7/17/2013)

    kapil_kk (7/17/2013)

    vinu512 (7/16/2013)

    Is Auto Update of Statistics on the Database Disabled??....Check both AUTO CREATE STATISTICS and AUTO UPDATE STATISTICS.........If any of them are disabled then enable them as...

    July 17, 2013 at 12:47 am

    #1633086

  • RE: Unexpected Behaviour With SQL Server :,(

    vinu512 (7/16/2013)

    Is Auto Update of Statistics on the Database Disabled??....Check both AUTO CREATE STATISTICS and AUTO UPDATE STATISTICS.........If any of them are disabled then enable them as follows:

    -- Enable...

    July 17, 2013 at 12:17 am

    #1633081

  • RE: Return

    Hi,

    as per the explanation- The stmt "return (select 5)" gives error because in a batch RETURN with integer_expression is not admitted (note: PARENTHESIS cast the SELECT to an integer_expression for...

    July 16, 2013 at 11:58 pm

    #1633076

  • RE: insert or update according the field value

    sa.ordekci (7/16/2013)

    Should I use below bode?

    set @isexist=(select count(*) from GNL_OgretmenDevamsizlikGirisLog

    where OgretmenID=@ogretmenID

    and DersYiliID=@dersyiliID

    and SinifID=@sinifID

    and DersID=@dersID

    and

    Convert(date,GirisTarihi) = Convert(date,getdate())

    )

    if(@isexist>0)

    begin

    end

    I think Chris have already done your homework... refer his post please

    July 16, 2013 at 6:40 am

    #1632841

  • RE: Not asking for any parameters in stored procedure

    Your stored procedure was executing as you didn't specify any parameters in that sp...

    Please refer Luis post...

    July 16, 2013 at 6:20 am

    #1632833

  • RE: Scan count vs logical reads

    Can you please post the execution plan?

    July 16, 2013 at 5:38 am

    #1632820

  • RE: quick edit data

    Sorry, I am not clear with your requirement 😉

    July 16, 2013 at 3:01 am

    #1632794

  • RE: Role Permission

    yes, you can create database and database objects with the role dbcreator...

    July 16, 2013 at 1:33 am

    #1632781

  • RE: Handling error message

    Ed Wagner (7/15/2013)

    The RAISERROR simply throws the error. To terminate processing in a stored procedure, you should fire a RETURN.

    yes, that why now am insteady of choosing severity 20...

    July 15, 2013 at 11:19 pm

    #1632753

  • RE: Reset of Identity

    Good start of the day with the easy one 🙂

    July 15, 2013 at 11:18 pm

    #1632752

  • RE: Handling error message

    Actually first I tried with Batch Abort but it did nt work for me.......

    SET XACT_ABORT On;

    select 'yes'

    RAISERROR('yes',20,1)

    select 'yes'

    RAISERROR('NO',16,1)

    SELECT 'NO'

    When error raises then also all select statements gets executed so...

    July 15, 2013 at 6:55 am

    #1632448

  • RE: Handling error message

    Thanks Wegner for your suggestion...

    July 15, 2013 at 6:52 am

    #1632447

  • RE: TSQL-Order by

    Thanks for your replies I got it now 🙂

    July 15, 2013 at 5:17 am

    #1632406

Viewing 15 posts - 376 through 390 (of 1,048 total)