I have some code in production wherein I am referring different databases and accessing their tables.
so making use of 'USE database' statement and then inserting many columns data into...

I get error with below statement so I tried casting...

   SET @SQLSTR='
    insert into #TEMP1(date_time) values( ' + @STARTTIME + ')';

Thanks Andy,
You are right,  this code needs to only ensure that data at both end is exactly same. And not work on encryption or adding any security feature...
If...

Thanks Andy, Bert for your answers.

Your answers give an indication that there will be a lot of challenges for implementing a scenario like below one...

"A table(in real scenario many tables..)...

No, Application will have its own database and tables which are not accessible from SQL Server.  Application triggers SQL procedure and through it pulls data from SQLServer into their local...

Thanks Drew for your reply.
But I didn't get how OUTPUT clause would serve my purpose as you mentioned that  its used only with INSERT, UPDATE, DELETE & MERGE. And...

Thanks Grant for the details provided.
There is an existing Stored Procedure in SS which when run by an application from a remote location populates the local table within the...