How to give a user the option of importing Excel and a delimited text file into a SQL Server Database without manually using SQL DTS?

1 Answers   GE,

---

Write query to return all rows sql?

0 Answers  

---

You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?

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,

---

What is factless fact table? : sql server analysis services, ssas

0 Answers  

---

How to find the last update record in SQL Server?

4 Answers  

---

What is store procedure? How do they work? When do you use?

0 Answers  

---

How to disable a login name in ms sql server?

0 Answers  

---

What information is maintained within the msdb database?

0 Answers  

---

sql server has its default date format in da form "yy-mm-dd" its possible to convert da current date format of sql server to desired format. Now my question is dat how to get da previous and comin days date in my desired format??

2 Answers  

---

What happens if null values are involved in comparison operations?

0 Answers  

---

How to Handle the exceptions in Sqlsrver 2005??

3 Answers   Value Labs, Wipro,

---