SQL Police

SQL Police has asked 15 questions and find answers to 10 problems.

Stats

About

SQL Police questions

update cascade in self referencing table - best practice?
Will joining on integer be quicker than joining on nvarchar?
How to set primary key when linking with CreateTableDef
What is faster: SUM over NULL or over 0?
WPF Form within a Windows Forms project
How to query current user's roles

SQL Police answers

SAP GUI Scripting "Invalid use of property" Error in VBA
SQL Server stored procedure expects parameter which was not supplied
Find Mondays between 2 dates
FileNotFoundException: Could not load file or assembly System.IO.Ports
How to rollback delete command without using transaction
What does SqlDbType.Structured mean?
How to extend the query to add 0 in the cell when no activity is performed
Python/SQLAlchemy - How to quickly query database with multiple WHERE clauses?
Calling stored procedure with OUTPUT parameter in dynamic SQL
Decimal out of range exception