Issue with reading CSV file and insert data to database

Posted by Jeena under Sql Server on 6/28/2012 | Points: 10 | Views : 1031 | Status : [Member] | Replies : 2
Hi all

I have a SQL table in which data adds every day and contains around 1 crore data and 40 columns.
I have a requirement like to show the reports based on these records. What are the best options we can add apply ?

I need to simply select the data from table only (Select * from table)

Thanks
Jennifer




Responses

Posted by: Pandians on: 6/28/2012 [Member] [MVP] Silver | Points: 25

Up
0
Down
Yo can apply WHERE clause and apply conditions based on your requirement!

This is what you asking about (or) something else ?

Cheers
www.SQLServerbuddy.blogspot.com
iLink Multitech Solutions

Jeena, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Bhupentiwari on: 6/28/2012 [Member] Starter | Points: 25

Up
0
Down
Use Some Search Condition...where clause

Thanks n Regards
Bhupendra Tiwari

Jeena, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response