SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag OPENQUERY Rss

Search for any content tagged openquery

   Items 1 to 3 of 3   
 

Insert Stored Procedure Results Into New Table Without Using OPENQUERY

OPENQUERY arrives with a lot of baggage. Try this alternative technique to inserting stored procedure results into a new table.  Read more...
By Orlando Colamatteo 2017/09/22 (first published: 2016/03/22) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 7,827 reads

Insert Stored Procedure Results Into New Table Without Using OPENQUERY

OPENQUERY arrives with a lot of baggage. Try this alternative technique to inserting stored procedure results into a new table.  Read more...
By Orlando Colamatteo 2017/09/22 (first published: 2016/03/22) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 7,827 reads

Dynamic SQL execution on remote SQL Server using EXEC AT

In this tip I am going to start my brief discussion with OPENQUERY and OPENROWSET table functions, its limitation and how the new EXEC AT command overcomes them.  Read more...
By Additional Articles 2009/06/09 | Source: MSSQLTips.com | Category: openrowset
Rating: (not yet rated)  Rate this |   Briefcase | 4,952 reads
   Items 1 to 3 of 3