Note on using T-SQL via R and ODBC

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.

About Vinh Nguyen

Statistician

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>