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

You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?

0 Answers  

---

How to swap the data of two columns in a table. both the columns containing varchar values.

9 Answers  

---

Can we use trigger new in before insert?

0 Answers  

---

What is a Linked Server?

1 Answers  

---

how to find number of columns in a table in sql server 2000 and 2005 also

7 Answers   HCL, Virtusa,

---

If we use where clause in the left outer join then how the query would behave/act?

1 Answers  

---

How can a database be repaired?

0 Answers  

---

How many levels of sp nesting are possible?

0 Answers  

---

Who is the owner of a schema in ms sql server?

0 Answers  

---

What are the methods used to protect against sql injection attack?

0 Answers  

---

What are the triggers in sql?

0 Answers  

---

You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?

0 Answers  

---