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...

OPENROWSET is a handy tool for retrieving data. Find out how to use the OPENROWSET function for SQL Server and Microsoft Access.  Read more...

This SQL School video from MVP Andy Warren shows you how to use the OpenRowSet command to access data stored outside of SQL Server.  Read more...

OPENROWSET is a T-SQL function that allows for reading data from many sources including using the SQL Server’s BULK import capability.  Read more...

Many times I would like to insert the results of a stored procedure into a table so I can do some extra processing with the result set. I always have to create the table first in order to perform an Insert Into Exec on the desired stored procedure since Exec Into is not an option. Is there a way to do this without having to manually create the table each time?  Read more...