Answer / prashant

FOR SQL Server only -
That depends on where your data (100 rec) is

If it's in a txt file, you may try SQLBULKCOPY:
http://msdn.microsoft.com/en-us/library/7ek5da1a.aspx

else, you may try Data Flow task in SQL Server Integration
Service (SSIS) to upload the data from other source.

What is a partition key?

0 Answers  

---

two tables with table name ship(name,year) and battle (name,year),how to find the latest added year in the table ship

1 Answers  

---

How to Get the last identity value used

4 Answers  

---

what is the basic diffrence betn a col declared in char(1) and in varchar(1)

2 Answers  

---

What is the difference between count () and rowcount ()?

0 Answers  

---

---

I am Having tables T1 and T2 both having same data how to check (or) compare the data in both table are same?

3 Answers  

---

Is it possible to create tables in stored procedures using a variable for the table name?

2 Answers  

---

What does null mean?

0 Answers  

---

Where are sql server usernames and passwords stored in the sql server?

0 Answers  

---

What is a not null constraint?

0 Answers  

---

How many nested transaction can possible in sql server?

3 Answers   Bank Of America,

---

What is the difference between Drop and Truncate

20 Answers   GT Nexus, IBM,

---