is it possible to use a variable in a query with the IN clause (a,b,c..z), without getting quotes or conversion errors?

2 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  

---

Explain the difference between function and stored procedure?

0 Answers  

---

State the difference between union and union all?

0 Answers  

---

create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration

0 Answers  

---

What are the differences between stored procedure and view in sql server?

0 Answers  

---

Explain about thread and memory management process of SQL?

0 Answers  

---

If there is failure during updation of certain rows, what will be the state?

2 Answers  

---

What is difference between view and materialized view?

0 Answers  

---

Explain insert into select statement?

0 Answers  

---

What all db objects can be found in MSDB database of a SQL Server instance?

2 Answers   Accenture,

---

How to fetch the next row from a cursor with a "fetch" statement?

0 Answers  

---