Note on using T-SQL via R and ODBC

R
Author

Vinh Nguyen

Published

February 9, 2018

Reminder to self: when trying to query data into R using an existing SQL script that uses T-SQL to access data in Microsoft SQL Server, add SET NOCOUNT ON; to the beginning of the script, then add SET NOCOUNT OFF before the last select statement (the query returning the data of interest). If this is not done, an empty is returned instead.