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 a sql query to get zero records from a table having n number of records?

0 Answers   TCS,

---

what is the use of database index(apart from the last searching of records) and what is the use of composite key?

1 Answers  

---

In join, which clause in not used?

4 Answers   HCL, NIIT, TCS,

---

What is sql server schema compare? How we can compare two database schemas?

0 Answers  

---

what is a transaction and what are acid properties? : Sql server database administration

0 Answers  

---

Can you pass expressions to stored procedure parameters?

0 Answers  

---

Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)

0 Answers  

---

Does sql server 2016 have ssms?

0 Answers  

---

How to set database to be read_only in ms sql server?

0 Answers  

---

Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.

0 Answers  

---

What is explicit mode in sql server?

0 Answers  

---