Post reply

Dynamic Query

  • September 23, 2013 at 8:59 pm

    #280020

    Comments posted to this topic are about the item Dynamic Query

    [font="Verdana"] There is no Wrong time to do a Right thing 🙂 [/font]

  • September 23, 2013 at 9:03 pm

    #1652543

    oops

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • September 23, 2013 at 10:28 pm

    #1652556

    easy one to start the day 🙂

  • September 23, 2013 at 10:36 pm

    #1652557

    While using SELECT it will give the output in a commented lines while using EXEC it gives the error :crazy:

    declare @var Varchar(1000)

    set @var = '-- /* select ''Samith'' name

    */'

    select @var

    --Output: '-- /* select 'Samith' name */'

    set @var = @var + ' select ''sas'''

    select @var

    --Output:' -- /* select 'Samith' name */ + select 'sas''

    _______________________________________________________________
    To get quick answer follow this link:
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

  • September 23, 2013 at 10:38 pm

    #1652558

    Nice and simple one.

  • September 23, 2013 at 10:40 pm

    #1652559

    Good basic question.

  • September 23, 2013 at 10:45 pm

    #1652560

    Change to Text mode [Ctrl+t]

    and check the result

    You can see the difference 🙂

    [font="Verdana"] There is no Wrong time to do a Right thing 🙂 [/font]

  • September 24, 2013 at 12:47 am

    #1652573

    kapil_kk (9/23/2013)

    While using SELECT it will give the output in a commented lines while using EXEC it gives the error :crazy:

    declare @var Varchar(1000)

    set @var = '-- /* select ''Samith'' name

    */'

    select @var

    --Output: '-- /* select 'Samith' name */'

    set @var = @var + ' select ''sas'''

    select @var

    --Output:' -- /* select 'Samith' name */ + select 'sas''

    True.

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

  • September 24, 2013 at 12:52 am

    #1652576

    kapil_kk (9/23/2013)

    While using SELECT it will give the output in a commented lines while using EXEC it gives the error :crazy:

    declare @var Varchar(1000)

    set @var = '-- /* select ''Samith'' name

    */'

    select @var

    --Output: '-- /* select 'Samith' name */'

    set @var = @var + ' select ''sas'''

    select @var

    --Output:' -- /* select 'Samith' name */ + select 'sas''

    Maybe, you have the resultset in grid mode! Change it to text mode and you'll see the "*/" at newline

  • September 24, 2013 at 12:54 am

    #1652577

    Although I was pretty sure that this is another tricky question and my answer will be wrong when I pressed Submit button; but surprisingly it was correct 🙂

    exec @variable; hmmm always good to refresh the mind with hidden & forgotten basics.

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

  • September 24, 2013 at 1:03 am

    #1652578

    I LOVE TRICKY QUESTIONS ALWAYS... THANKS SAMITH..

  • September 24, 2013 at 1:17 am

    #1652580

    Nice easy question for me. 🙂

  • September 24, 2013 at 1:42 am

    #1652584

    I had to think about it for a while before answering. Good one.

  • September 24, 2013 at 1:53 am

    #1652589

    ksatpute123 (9/24/2013)

    I had to think about it for a while before answering. Good one.

    same here.Thanks Smith

    Pramod
    SQL Server DBA | MCSE SQL Server 2012/2014
    in.linkedin.com/in/pramodsingla/
    http://pramodsingla.wordpress.com/

  • September 24, 2013 at 2:01 am

    #1652592

    Very nice question, thanks.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

Viewing 15 posts - 1 through 15 (of 37 total)

You must be logged in to reply to this topic. Login to reply