What is the use of sign function?

0 Answers  

---

How to declare a cursor with "declare ... Cursor" in ms sql server?

0 Answers  

---

What is the difference between a "where" clause and a "having" clause?

0 Answers  

---

What is the server name for sql management studio?

0 Answers  

---

i have table students with fields classname,studname select * from students classname studname 1 xxxxx 1 yyyy 1 zzzz 2 qqqq 2 tttt 3 dsds 3 www i want the output should be No of students in class 1 : 3 No of students in class 2 : 2 No of students in class 3 : 2

5 Answers   HCL, ZX,

---

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  

---

What are the properties of the transactions?

0 Answers  

---

Can we write a distributed query and get some data which is located on other server and oracle database?

0 Answers  

---

How will you fine tune a stored procedure or what are the steps that should be taken to fine tune or optimize a stored procedure?

1 Answers   Logitech, Mphasis,

---

How to use subqueries with the in operators in ms sql server?

0 Answers  

---

What is rolap and its advantage? : sql server analysis services, ssas

0 Answers  

---

What are the types of constraints?

1 Answers  

---