I have a sql 2008 server in work and want to sync it with webserver 2008. At the moment I have attached the web server as a linked server. But seems slow, plus i am stuck when i try and do a delete query using a left join query.
FROM [LinkedWebServer].DB_2454.dbo.Products Webserver LEFT JOIN [ProductDatabase].[dbo].[Products] localserver ON Webserver.ProductRef=localserver.ProductRef
(i get an error of Incorrect syntax near the keyword 'LEFT'.)
I have tried microsoft's localdatabase cache datasync but then have to sync the .mdf file with my server then sync the mdf file with the webserver, which seems a waste of time plus have a few problems on a few computers where this method just hung. Can you do this directly with the 2 servers?
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple. The final solution for this task involved creating a custom text parser and then reading…
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables.
Make a table:
Update a specific column given a specific row using the UPDATE statement:
Remove a set of values using the DELETE s…