nathan_jr questions

nathan_jr answers

• Programmatically generate SQL script to create database without PRIMARY statement .. using scripter
• Prevent rows with same col1 and different col2
• Can you pivot and aggregate on two columns with a Sql PIVOT query
• Error while trying to create a new SQL Server 2008 database project
• Embed Images in emails created using SQL Server Database Mail
• In SQL, how to delete a row from one table if it doesn't have a corresponding row in another table?
• Dapper: Not able to parse floats (Error parsing column)
• Get hash values from SQL Server and Oracle and compare them?
• Create a One-to-Optional-One constraint in SQL Server
• SQL-'08: Are multiple Replace statements a bad practice/is there another way to write this query?