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)
)

Can group functions be used in the order by clause in ms sql server?

0 Answers  

---

Explain the architecture of ms sql reporting service?

0 Answers  

---

What does it mean to have quoted_identifier on? What are the implications of having it off?

2 Answers  

---

What is a data collection table?

0 Answers  

---

When you use @@error and try-catch?

0 Answers  

---

Where can you add custom error messages to sql server?

0 Answers  

---

Tell me what is the order in which the sql query is executed?

0 Answers  

---

Can we insert data if clustered index is disabled?

0 Answers  

---

Explain microsoft sql server functions?

0 Answers  

---

What is CTE in SQL

0 Answers   Infosys,

---

What is exclusive locks?

0 Answers  

---

Can we drop user if user mapped to any logins

1 Answers  

---