I’m using Microsoft SQL Server 2005, and I’m wondering if there’s any way I can validate (parse) a given query without actually executing it using a SQL Command.
PLEASE NOTE: I already know that this can be done in SQL Server Management Studio by just pressing the “Parse” button, but I am not looking to do this in Management Studio. I am looking for a way to do this using only T-SQL commands.
Specifically, is there some kind of syntax like PARSE(‘…’) or something like that? Something that would tell me if the query is valid, but not actually run the query. Thanks.