Dear all,
I would like to make a SQL statement with a field concat by some strings. For example, Full_Address = Address1 + Address2 + Address3. But I don't know the syntex of such operati...
I have server A, Server B:
There is a stored procedure in A, and it contains coding like this:
update ServerB.my_database.dbo.remote_table
set name = b.name
from ServerB.my_database.dbo....
What's the MS-SQL Server equivilant of the oracle command Minus.
For those that don't know this command it's similar to a union. here's an exmple
Select field1, field2 from table1
MINU...
