Other than truncate statement, which other command can by-pass the trigger on the tables?

0 Answers  

---

What is the system function to get the current user's user id?

3 Answers   TCS,

---

explain databases and sql server databases architecture? : Sql server database administration

0 Answers  

---

How to see the event list of an existing trigger using sys.trigger_events?

0 Answers  

---

How extra digits are handled with numeric data type literals?

0 Answers  

---

---

What is the difference between clustered index and primary key?

0 Answers  

---

How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?

0 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

0 Answers  

---

How many tables can be joined in SQL Server?

0 Answers   Cap Gemini,

---

What is 'write-ahead log' in sql server 2000 ?

0 Answers  

---

1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.

0 Answers   Aptroid,

---

i have a table student like sname ----- ram ram ram raj raj raj i need the output like sname ----- ram raj ram raj ram raj

9 Answers   IBM,

---