SOreadytohelp

Sean Lange questions

Sean Lange answers

• How to create schema bound, cross-database view in SQL Server
• Modify SQL Trigger to work with BULK INSERT
• How to solve Msg 8115, Level 16, State 2, Line 2 Arithmetic overflow error converting expression to data type int.?
• SQL Proc 'Conversion failed' from varchar to int. Why the conversion?
• named parameters in sp_executesql
• Primary key of temp table already exists
• Advantages to storing UserId instead of Username in sql audit columns such as CreatedBy/ModifiedBy [closed]
• Risk and effects of changing database collation in SQL Server
• compare columns only when NOT NULL
• When are check constraints evaluated?