Concatenation in a table in sql server

Question

0.00/5 (No votes)

See more:

SQL-server-2000

SQL-Server-2005

, +

Hi all,

I have a query something like it.

SQL

DECLARE @execquery AS NVARCHAR(MAX)
SET @execquery =N'
declare @i varchar(50)
set @i=''139''

select * from ASYNCSEARCH_+@i'

Exec (@execquery)

this is not executing when I am running this query. I want to attach a string in table name.

I want the variable of @i to be defined just like I have done.I don't need it outside
Please help

Posted 5-Dec-13 0:00am

Mohd Wasif

Updated 5-Dec-13 0:02am

v2

Add a Solution

2 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2013-12-05T00:04:00

Solution 1

Well, no - it won't...
Look at what you wrote:
SET @execquery =N'
declare @i varchar(50)
set @i=''139''

select * from ASYNCSEARCH_'+@i

SQL

It's a single string, containing the declaration of the variable, then trying to tack the variable on the end of the string it's declared in...
Did you mean:

SQL

declare @i varchar(50)
set @i='139'
SET @execquery =N'select * from ASYNCSEARCH_' + @i

Posted 5-Dec-13 0:04am

OriginalGriff

Comments

Mohd Wasif 5-Dec-13 6:11am

I have updated my question .I am in a condition of creating dynamic query for that on the basis of variable @i there exists a table like if value of @i=123 then table name becomes
ASYNCSEARCH_123.I have to get all records from that table.Can You help me.

OriginalGriff 5-Dec-13 6:30am

Try it the way I suggested - you may find it works...

Ganesh Raja · Answer 2 · 2013-12-05T00:10:00

Solution 2

What is the purpose to declare the @i inside ?
can you try this below,

SQL

DECLARE @execquery AS NVARCHAR(MAX) 
declare @i varchar(50)
set @i='139'
SET @execquery =N'
 
select * from ASYNCSEARCH_'+@i
 
Exec (@execquery)

Posted 5-Dec-13 0:10am

Ganesh Raja

Comments

Mohd Wasif 5-Dec-13 6:16am

Actually I am creating dynamic query that why there is need of declaring variable like that.

Concatenation in a table in sql server

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Concatenation in a table in sql server

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us