Answer Posted / sandeep modapathi

using cursor datatype

declare an output data type
@my_cursor CURSOR VARYING OUTPUT

Can you create a logon trigger in sql server 2005 express edition?

1073

---

how many layers of tcp/ip protocol combined of? : Sql server database administration

990

---

How column data types are determined in a view?

951

---

How can you control the amount of free space in your index pages?

1052

---

Can you please differentiate between a primary key and a unique key?

1001

---

What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration

1009

---

List out different types of normalizations in sql server and explain each of them?

917

---

Does a sql server 2005 select statement require a from?

1012

---

You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?

997

---

what is denormalization? : Sql server database administration

918

---

What is the difference between executequery () and executeupdate ()?

1021

---

What are rows and columns?

1014

---

what are user defined datatypes? : Sql server database administration

958

---

What is data source view or dsv? : sql server analysis services, ssas

996

---

What is tcl in sql server?

1112

---