asp.net - How can we import .xls files into ssms and only those items must be copied in to the database which are new and the old must be deleted automatically? -


I need to manually import Excel files into SQL Server 2008 SSMS and only load those items in the database People who are new ones who are not existing are people. Please find me the SQL query for that

I suggest that you can use SSIS in this situation I think there is no direct examination to handle this situation. First you have to load the data in the staging table and then you only need to move the new record. Please see here for T-SQL commands

Comments

Post a Comment

Popular posts from this blog

python - Assemble mpeg file unable to play in mediaplayer -

I am currently working on a school project and I think that is to gather some problems with the MPEG file I The scope of my project is: 1) Split the MPEG file into pieces of many fixed sizes. 2) Collecting some of them and leaving some part. Problem 1: When I run the file in the media player, it will play the video until it reaches that segment which I left Give it Example: Chunk = ["yui_1", "yui_2", "yui_3", "yui_5", "yui_6"] Duration of each segment: 1 second * If you think I have left the "yui_4" section. * If I went to collect all the parts except "yui_4", then the video will play the first 2 seconds before being hanged throughout the period. Problem 2: When I gather the first part off the part, it is unable to run the full MPEG file is. Duration of each piece: 1 second Example: wheel = ["yui_2", "yui_3", "yui_4", "yui_5", "yui_6"...
Read more

c# - crystal report failed -

I have created a crystal report with parameters, but this does not load the value. It only shows the title, I mean column name only. Please check your code and correct me. And I tried to load that report in PDF format, which shows an error like "Load report failed" Please correct me. Protected Zero Button 2_Click (Object Sender, EventArgs E) {Report Document Reports Document = New Report Document (); Reportdocument.Load (Server.MapPath ("CrystalReport.rpt")); Reportdocument.SetDatabaseLogon ("", "", "Arvind", "My ScamDDB"); Report document. Setpermator val ("mrno", textbox 1. text); CrystalReportViewer1.ReportSource = Report Document; } Secure Zero LinkButton1_Click (Object Sender, EventArgs E) {Exportport (); Private Zero Exports () {MemoriStream Ostream; Response.Clear (); reaction. Buffer = true; Report Document Report Document = New Report Document (); Reportdocument.Load (Server.MapPath ("CrystalReor...
Read more

mongodb - CakePHP paginator ignoring order, but only for certain values -

While pagging my user model in kppp, I can sort with some values, but not others. For example, I can order results from created or email , for example, but username or reputation seems to come back order by arbitrary command for example with a list of users: $ this-> paginate = array ('condition' => array ( 'User.is_active' = & gt; true), 'border' => 24, 'order' => array ('User.created' => DESC)); Works as expected, but $ this - & gt; Paged = array ('conditions' = & gt; array (' user.isIactive '= & gt; true),' border '= & gt; 24,' command '= & gt; array (' user repeats' = ' & Gt; DESC ')); No, no. I first thought that this could be a database issue, but when I search the database directly, sorted as expected. Note: I am using Mangodebi with the Mongo DB plugin of Ichikawa for the KPPHP; Pagnetizing users are used to work properl...
Read more