Is it possible to create tables in stored procedures using
a variable for the table name?
- 2 Answers
- 5101 Views
- I also Faced
- E-Mail Answers
Answer Posted / skybeaver
create proc ShowMeHow
as
declare @Cities table(
AirportCode char(3) not null primary key,
CityName varchar(255) not null
)
insert into @Cities values('LAX', 'Los Angeles')
insert into @Cities values('ORD', 'Chicago')
select * from @Cities
go
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
How to set database to be single_user in ms sql server?
How do I find my localdb version?
Why I am getting this error when dropping a database in ms sql server?
Define cross join in sql server joins?
How to insert multiple rows with one insert statement in ms sql server?
What is the latest version of microsoft sql server?
What is subquery in sql?
how to do partition in sqlserver
Tell about MOM Tool(Microsoft Operator Manager)?
what stored procedure can you use to display the current processes? : Sql server administration
What is query processing?
What is sparse columns of sql server 2008?
What is difference between primary key and foreign key?
How do I view a procedure in sql server?
what is sql server? : Sql server database administration
