Does anyone know of a way to verify the correctness of the queries in all stored procedures in a database?
I'm thinking of the scenario where if you modify something in a code file, simply doing a rebuild would show you compilation errors that point you to places where you need to fix things.
For CLR functions, all data types, including CLR user-defined types, are allowed except text, ntext, image, user-defined table types and timestamp data types.
The nonscalar types, cursor and table, cannot be specified as a parameter data type in either Transact-SQL or CLR functions.
In multistatement table-valued functions, @Warning Joining to a multistatement table valued function in a FROM clause is possible, but can give poor performance.