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,

---

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  

---

If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?

0 Answers   Facebook,

---

What are a scheduled jobs?

0 Answers  

---

What is log cache in sql server?

0 Answers  

---

How do you implement one-to-one, one-to-many and many-to- many relationships while designing tables?

4 Answers   Credit Suisse, GCU, Symphony, TCS,

---

What is the difference between a local and a global variable?

5 Answers  

---

Who is the owner of a schema in ms sql server?

0 Answers  

---

Mention the differences between substr and charindex in sql server.

0 Answers  

---

How To Change Column Ordinal Position in SQL Server 2005 using Query i.e I Want To Add Column at Particular Ordinal Position in SQL Server 2005

2 Answers  

---

What are the differences between UNION and JOINS?

3 Answers   CarrizalSoft Technologies,

---

What are different types of table joins?

0 Answers  

---