Ivan Starostin questions

Ivan Starostin answers

• How can I populate a parent and a child table from another table?
• Execute stored procedure that has parameters with sp_executesql
• Left join to same table SQL
• SSDT project builds much slower with MSBuild than in VS 2013
• SQL how to check prefix in cell with two prefixes
• Inserting nested entities with autoincrement using SQL Server
• Stored procedure with default parameters
• Proper way to restore database transaction level from read uncommitted
• Query fast, but when in a VIEW, it's slow - due to ROW_NUMBER