linkserver Query syntax

SELECT CONVERT(varchar(30), Org_Insert_Date, 103) AS Expr1, Org_Insert_Date
FROM NewBusiness_Listing
WHERE (BList_Id = 10012)




CONVERT(varchar(30),, 103)




frmReports obj = new frmReports();
obj.Owner = this;
this.Visible = false;
obj.Visible = true;


SELECT:

select * from openquery(’my_linked_server’, ’select * from table_schema.table_name’)

INSERT:

insert openquery(’my_linked_server, ’select column_1, column2 from table_schema.table_name’)
values (’my_value1', ‘my_value2')

UPDATE:

update openquery(’my_linked_server, ’select column_1, column_2 from table_schema.table_name where pk = pk_value’)
set column_1 = ‘my_value1', column_2 = ‘my_value2'

DELETE:

delete from openqueryopenquery(’my_linked_server, ’select * from table_schema.table_name where pk = pk_value’)