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,

---

What are the different types of normalization?

0 Answers  

---

Please give me the SP for the below scenario. I have two tables named Table1 and Table2...I need to fetch record by record from Table1 and insert the record in to table2 where the value in the sno column of the table1 is even number.

4 Answers   Value Labs,

---

What is the difference between varchar and varchar(max) datatypes?

0 Answers  

---

How to define output parameters in stored procedures?

0 Answers  

---

---

in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration

0 Answers  

---

create table with fields ID, reserved_by,res_date res_date is datefield like 2010-03-09 00:00:00.000 from 2005 to 2006 any date assume based on res_date need to slect table and display based on month (full jan details in database irrespective of date and year

3 Answers  

---

What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration

0 Answers  

---

What do you understand by intent locks?

0 Answers  

---

Why do we need different type of parameter?

0 Answers  

---

When would you use the stored procedures or functions?

0 Answers  

---

Where do we generally create INDEX?

1 Answers   Ernst Young, Thomson Reuters,

---