declare @deb nvarchar(200)
set @deb='raw'
insert into table11
select * from @deb.dbo.table2
The above code is not working. Is there any way to use server name as variable?
Add a comment
|
2 Answers
You cannot change a column, table, schema, or database reference in a SQL statement. On the other hand, you can use dynamic SQL:
declare @deb nvarchar(200);
set @deb = 'raw';
declare @sql nvarchar(max);
set @sql = '
insert into table11
select * from @deb.dbo.table2
';
set @sql = replace(@sql, '@deb', @deb);
exec sp_executesql @sql;
1 Comment
Neminath
It is working but storing only one row.In table2 i have 152 records but randomly taking one row
Yes there is, Use Dynamic SQL
declare @deb nvarchar(200)
set @deb='raw'
declare @sql as nvarchar(max) = 'insert into table11
select * from '+@deb+'.dbo.table2'
exec (@sql)
8 Comments
Neminath
executing successfully but no records fetching.
ThePravinDeshmukh
no record fetching? it is suppose to insert all records from
table2 into table1. Is it happening?Neminath
Sorry , only one record fetching.
ThePravinDeshmukh
Really? and you have multiple records in table?
Neminath
in table2 i have 152 records, when ever i execute script the same record inserting in table. Means at a time only one record fetching , that too same record.
|