SQLMenace questions

SQLMenace answers

• SQL Server: how transactions work
• Is it possible to write an "insert into" statement for a single column table?
• Scripting your database first versus building the database via SQL Server Management Studio and then generating the script
• SQL Query based on a while loop
• Why is this unwanted ">" character being displayed when displaying this PHP document in a browser?
• SQL Server slow down after duplicating database
• CSV (or sheet in XLS) to SQL create (and insert) statements with .Net?
• 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