If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????

0 Answers  

---

What is a temporal data type?

0 Answers  

---

Do we need to rebuild index after truncate?

0 Answers  

---

what is 'mysqlshow'? : Sql dba

0 Answers  

---

Is sqlexception checked or unchecked?

0 Answers  

---

In testing where do we use sql language and how it helps in testing?

2 Answers  

---

What is the example of procedure?

0 Answers  

---

what is the difference between varray and table data type..please expalain with some examples... under what situation you will go for varray..instead of index by table...

1 Answers   HCL, Satyam,

---

What is package in pl sql?

0 Answers  

---

What is sql select statement?

0 Answers  

---

List different type of expressions with the example.

0 Answers  

---

Practice 1: Changes to data will only be allowed on tables during normal office hours of 8.45 in the morning until 5.30 in the afternoon, MONDAY through FRIDAY. A. Create a procedure called SECURE_DML that prevents the DML statement from executing outside of normal office hours, returning the message: “you may only make changes during normal office hours” b. Create a statement trigger on the PRODUCT table which calls the above procedure. c. Test it by inserting a new record in the PRODUCT table.

1 Answers   Tech Mahindra,

---