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.
Please mark as answer, if this was it. Visit my
SQL Server Compact blog
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?