Answer / Vivek Anand

{"View Restrictions": "Views can contain joins, aggregations, and calculations but cannot contain DDL statements (CREATE, ALTER, or DROP), triggers, or transaction control statements. Views also cannot be indexed directly; instead, indexes are created on the underlying table that supports the view.","Nested View Restrictions": "SQL Server does not support nested views, except for scalar-valued functions and system views that rely on the SQL SERVER internal implementation of nested views."}

List some major differences between triggers and stored procedures?

1 Answers  

---

What is storeprocedure?Tell me synatx for how to write stored procedure.

1 Answers   Cap Gemini,

---

What action plan is preferred if sql server is not responding?

1 Answers  

---

What is a scheduled job or what is a scheduled task?

0 Answers  

---

What is transcation?Plz give One example?

2 Answers  

---

Can the “if update (colname)” statement be used in a delete trigger?

1 Answers  

---

You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date

1 Answers  

---

whats the maximum size of view state??

1 Answers  

---

What is temporal data type?

1 Answers  

---

How to test subquery results with the exists operator?

1 Answers  

---

How do I find the transaction log size in sql server?

1 Answers  

---

How many types of triggers in sql server?

1 Answers  

---