none
Query to copy data from a table in SQL Server database to SQL Server Compact Edition 4.0 in my desktop application

    Question

  • Hi I need a single Query to copy few column data from a table in SQL Server database to columns in a table in SQL Server Compact Edition 4.0 in my desktop application..

    I'm aware I can do it in 2 steps through datatable.

    Is there any single query to do it. with optimized performance.

    If so, post some sample query.

    Application is in .NET 4.0, C#.

    I cannot create any SP in the SQL Server db I have mentioned.

    Thanks


    ~ Loveson

    Wednesday, April 04, 2012 1:01 PM

Answers