SQLMenace questions

SQLMenace answers

• 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
• Validate if a column has a null value
• What is the fastest way to copy data from one table to another
• SQL Server 2008 - How fast are table joins across databases (same server) vs. tables in the same database?