Syntax question for INSERT statement

[ddub]

Hi,

What would the proper syntax be if I wanted to replace 'smith' with the current user name in the following INSERT statement?

INSERT INTO smith.tblTemp
SELECT * FROM tblSource

This statement is part of my stored procedure that allows whoever's executing it to create a table and then insert values into it.

 

[aalmeida]

Declare @User Varchar(20)
Declare @sql varchar (200)

set @sql = 'INSERT INTO '+@Usewr+'.tblTemp SELECT * FROM tblSource'

exec (@0sql)
AL Almeida
NT/DB Admin
"May all those that come behind us, find us faithfull"

 

[tlbroadbent]

Just do an insert using the table name only. If you leave off the owner, the user name will be assumed.

INSERT INTO tblTemp
SELECT * FROM tblSource
Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.

 

[ddub]

Thanks for both tips, aalmeida and tlbroadbent. The syntax from aalmeida worked for me. I had tried it the way tlbroadbent had suggested earlier, but it would not work. Maybe this was because I gave the users only the db_ddladmin role and not db_datawriter also.