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

List out the differences between global and local temp tables in sql server?

1038

---

Which operator do you use to return all of the rows from one query except rows are returned in a second query?

978

---

explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

914

---

Write SQL queries on Self Join and Inner Join.

1129

---

What is BCP? When does it used in sql server 2012?

1043

---

What is normalization and what are the advantages of it?

960

---

What is the ‘fillfactor’?

952

---

What are system databases into sql server (2005/2008) : sql server database administration

996

---

If we delete pack Spec what will be the status of pack Body ?

1465

---

What is auditing in sql server?

913

---

What is the difference between Triggers and Stored Procedure?

1081

---

Explain the use of keyword with encryption. Create a store procedure with encryption?

934

---

What are “lock” hints?

1045

---

What is coalesce in sql server?

1038

---

How can you list all the columns in a database?

913

---