SQLMenace questions

SQLMenace answers

• SQL Server 2005 metadata search to get stored procedure parameters
• What are some best practices for optimizing multiple column LIKE SQL queries?
• Exclude records matching subquery
• Syntax for Alter Column and Add Column in same query
• How do I do batch upserts in SQL Server?
• SQL Server 2005 insert trigger not inserting enough records
• SQL: How to use a column that was just added
• In SQL Server, how do you determine the number of rows per page?
• How to replace CHAR(13) in DB varchar(6000)?
• How can I concatenate a String with a Bit (documentTitle+Archive) SQL server 2005