Open Sql Query
For Get Data
SELECT * FROM OPENQUERY([MYSQLDB],'SELECT * FROM barcodedb.Location')
For Insert Data
insert into OPENQUERY([MYSQLDB],'SELECT * FROM test.employee')values('1003','Test','Test','1234567890')
insert into [dbo].[Product](product_id,product_cat_id,product_scat_id,product_type,product_name,product_price,product_status) select * from OPENQUERY([MYSQLDB],'SELECT product_id,product_cat_id,product_scat_id,product_type,product_name,product_price,product_status FROM dbo.s_product')
For Delete Data
delete from OPENQUERY([MYSQLDB],'SELECT * FROM test.employee') where Emp_ID='1003'
For Update Data
update OPENQUERY([MYSQLDB],'SELECT * FROM test.employee') set Name='Ankur' where Emp_ID='1003'