Sorry, this is a SQL Server forum: you won't have many people answering c# questions here.

I suggest that you post your question in places like stackoverflow.

To connect to a default instance, you don't need to specify "MSSQLSERVER" as the instance name: instead of Server=SERVERNAME\\MSSQLSERVER use Server=SERVERNAME

That stored procedure does exactly what you need to do.

You mean me? Wow, that's quite a way to disagree... 🙂

MERGE is a widely known deadlock generator: https://www.mssqltips.com/sqlservertip/3074/use-caution-with-sql-servers-merge-statement/

In the "SELECT" part of the query, SQL Server has no idea what [DB].[dbo].[TABLE1].Report_Run_Date is, because it is not part of the query.

This might be similar to what you're after:

INSERT...

No, I'm sorry. You need to restore the database and then set up replication from scratch. You can always script the publication from the production database and use that script...

Anything that Google can't help you with?

Are you lloking for something in particular?

This is a SQL Server forum, not a MySQL forum. You'll have better luck with MySQL forums: http://forums.mysql.com/

Sorry, but it is unclear to me what you're trying to do.

Please post table scripts, sample data and expected output.

See http://spaghettidba.com/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum/ for guidance.

Compare the two execution plans. If the plans are simple, you can do that visually/manually.

If the plans are complex, you can look for subtle changes using SSMS: https://blogs.msdn.microsoft.com/sql_server_team/comparison-tool-released-with-latest-ssms/

Absolutely possible, but don't focus on the read/write or read-only status of the database: look for differences in the query plans and sorting/hashing operations spilling to tempdb.

This: https://blogs.msdn.microsoft.com/buckwoody/2009/07/30/code-collapse-and-expand-feature-in-sql-server-management-studio-2008/

What's your question?

The query you posted is invalid. Try something like this:

SELECT (

SELECT PARTY_NAME

FROM...

What you need here is a table valued parameter:

CREATE TYPE ParamCountry AS TABLE (name varchar(200));

GO

CREATE PROCEDURE FindingCityNames @CountryNames ParamCountry READONLY

AS

SELECT CityName,Capital, Countryname

FROM TableCountries

WHERE CountryName IN (

SELECT name

FROM @CountryNames

)

GO

DECLARE...