How to use execute statement using select into in SQL

Question

I tried to search some post but i got no lucky to find like my scenario:

This is my attempt but no luck.

declare @tb varchar(30)
set @tb = 'newtablename'
declare @sql varchar(30) = 'select * into ' + @tb + ' from tbl_3;'
EXEC  sp_executesql  @sql

it returns an error

Procedure expects parameter '@statement' of type 'ntext/nchar/nvarchar'.

Any suggestions will be appreciated.

Thanks in advance.

e_i_pi · Accepted Answer · 2017-05-18 00:58:36Z

2

You're declaring your @tb and @sql variables as type varchar(30). The error clearly warns that it expects ntext, nchar, or nvarchar. Also, your @sql string would be truncated at length 30. I would suggest changing your code to the following:

declare @tb nvarchar(30)
set @tb = 'newtablename'
declare @sql nvarchar(255) = 'select * into ' + @tb + ' from tbl_3;'
EXEC  sp_executesql  @sql

answered May 18, 2017 at 0:58

e_i_pi

4,8605 gold badges32 silver badges47 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to use execute statement using select into in SQL

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related