Answer Posted / amar

triggers is a block of code where is fired to do something action for insertion or delation of varioue t- sql statement........ where triggers are automatically fired.........

stored procedure is a predefined data types which is stored in a database............ stored procedure has to fire...........

Can primary key be a foreign key?

1049

---

How can a user-defined datatype be created?

983

---

Can I use sql azure as a backup with log shipping or database mirroring?

156

---

What is the boxing and unboxing concept in .net?

913

---

Write query to return all rows sql?

1049

---

Can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible?

1015

---

Why truncate is ddl command?

1056

---

what are constraints? Explain different types of constraints? : Sql server database administration

976

---

What is exclusive locks?

952

---

What languages bi uses to achieve the goal?

998

---

List out a number of the wants to setup a SQL Server failover cluster?

1062

---

Distinguish between nested subquery and correlated subquery?

1037

---

Does transparent data encryption provide encryption when transmitting data across the network?

1031

---

What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas

1258

---

How to use subqueries in the from clause in ms sql server?

1159

---