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'

Leave a Comment