Answer / 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

Answer / pradeep

One Can create Table using a variable. As #1 Answer
describe. You can only create a temp (memory) table but can
not create physical table.

It will give an error while attempting to execute : -

Create Table @VariableName( EmpID varchar(10),
EmpNm Varchar(100)
)

How do I run sql server 2014?

0 Answers  

---

What are the differences between stored procedure and view in sql server?

0 Answers  

---

Ms sql server index?

0 Answers  

---

Which tcp/ip port does sql server run on? How can it be changed?

0 Answers  

---

how to rest identity columns in sql server

3 Answers   Matrix,

---

What are the difference between data mart and data warehouse? : sql server analysis services, ssas

0 Answers  

---

What is updatable resultset?

0 Answers  

---

How to list all login names on the ms sql server?

0 Answers  

---

What is replace and stuff function in sql server?

0 Answers  

---

Explain what is the difference between union and union all?

0 Answers  

---

Explain isolation levels that sql server supports?

0 Answers  

---

Hi, I have a table A which has four rows as follows Table A ------- empname salary ------- ------ A 1000 B 2000 C 3000 A 1000 B 2000 D 5000 I need the following output: empname salary ------- ------ A 1000 A 1000 B 2000 B 2000 Thanks in advance

10 Answers   IBM,

---