Dynamic Query

Question

Post reply

Dynamic Query

Samith C

Mr or Mrs. 500

Points: 519
More actions
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]

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

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

Ron McCullough SSC Guru Points: 63877 More actions · Answer 1

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]

Mr. Kapsicum SSCertifiable Points: 6128 More actions · Answer 2

Mr. Kapsicum

SSCertifiable

Points: 6128

September 23, 2013 at 10:28 pm

#1652556

easy one to start the day

kapil_kk SSC-Insane Points: 21316 More actions · Answer 3

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/

Bangla Hall of Fame Points: 3137 More actions · Answer 4

Bangla

Hall of Fame

Points: 3137

September 23, 2013 at 10:38 pm

#1652558

Nice and simple one.

Anipaul SSC-Insane Points: 24681 More actions · Answer 5

Anipaul

SSC-Insane

Points: 24681

September 23, 2013 at 10:40 pm

#1652559

Good basic question.

Samith C Mr or Mrs. 500 Points: 519 More actions · Answer 6

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]

Hany Helmy SSChampion Points: 13921 More actions · Answer 7

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

Carlo Romagnano SSC-Insane Points: 22749 More actions · Answer 8

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

Hany Helmy SSChampion Points: 13921 More actions · Answer 9

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

Jamsheer Ten Centuries Points: 1136 More actions · Answer 10

Jamsheer

Ten Centuries

Points: 1136

September 24, 2013 at 1:03 am

#1652578

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

sqlnaive SSCoach Points: 17437 More actions · Answer 11

sqlnaive

SSCoach

Points: 17437

September 24, 2013 at 1:17 am

#1652580

Nice easy question for me.

ksatpute123 Hall of Fame Points: 3325 More actions · Answer 12

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

psingla Hall of Fame Points: 3840 More actions · Answer 13

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/

Koen Verbeeck SSC Guru Points: 259155 More actions · Answer 14

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

Dynamic Query

Cookies on SQLServerCentral