Use SqlServerCmdletSnapin100 (installed when you install the SQL Server client tools, 2008 or newer (maybe 2005)) and it gets a lot easier.

Ok, I'm trying to write a query in a stored procedure in SQL Server 2000. Because some of the parts of the query vary based on certain situations I construct a string that contains the query and ...

The new time series engine is capable of responding to queries faster, supporting data analysis of massive database workloads.