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 to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?

3 Answers  

---

How dts is used to extract, transform and consolidate data?

0 Answers  

---

What are trace files?

0 Answers  

---

what is denormalization? : Sql server database administration

0 Answers  

---

What is the difference between TRUNCATE and DROP?

0 Answers  

---

What can be used instead of trigger?

0 Answers   ADITI,

---

What is difference between Triggers and store procedure?

2 Answers  

---

Explain basic SQL queries with SELECT from where Order By, Group By-Having?

3 Answers   TetraSoft, Wipro,

---

Explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

0 Answers  

---

What it means to be triggered?

0 Answers  

---

How do we know if any query is retrieving a large amount of data or very little data?

0 Answers  

---

if 3 duplicate records in a table,i want to delete 2 duplicate records by keeping 1 duplicate and 1 original as it is,how?

5 Answers  

---