How do you find the error, how can you know the number of rows effected by last SQL statement?

1 Answers  

---

How to generate random numbers with the rand() function in ms sql server?

0 Answers  

---

What is difference between views and stored procedures?

0 Answers  

---

I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?

0 Answers   IBM,

---

Diffrent types of function

1 Answers   Wipro,

---

Explain what is the use of custom fields in report?

0 Answers  

---

How many full-text indexes can a table have?

0 Answers  

---

when u import an excel file into sql if suppose one column has got a date field with system time attached to it what data type u will use in sql to import it in a table? Note: a condition is the excel file has no primary key defined to a column...also u r importing bulk data into sql

1 Answers  

---

Table student containing 2 columns,Join date,Employee name. Under join date 4 rows r ter =1-jan-2008,2-feb-2008,3-mar- 2008,4-feb-2008.Under Employee name 4 difeerent names jaison,robin,binoy,rahul Result set is, Table containing 4-column name=jan,feb,mar,april,,beneath these months count is given as 1,2,1,0 means these counts representing number of emplooyees joined in a month(january 1employee,february 2 employee,march 1 employee,april 0 employee) Can you give me the required sql query

3 Answers   RND Soft, Wipro,

---

What xml support does the sql server extend?

0 Answers  

---

How to use “drop” keyword in sql server and give an example?

0 Answers  

---

How do I find the sql server version?

0 Answers  

---