Sign in
 
HomeLibraryLearnDownloadsTroubleshootingCommunityForums
SQL Server Developer Center >
> 
> 
Query to copy data from a table in SQL Server database to SQL Server Compact Edition 4.0 in my desktop application

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

  • Wednesday, April 04, 2012 1:01 PM
     
     
    Sign In to Vote
    0

    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

     

All Replies