Stack Exchange

Dems

United Kingdom

top accounts reputation activity favorites subscriptions
Top Questions
Top Answers
98
Standard use of 'Z' instead of NULL to represent missing data?
stackoverflow.com

27
ALTER TABLE without locking the table?
stackoverflow.com

24
How do I preview a destructive SQL query?
stackoverflow.com

16
When do I need to use Begin / End Blocks and the Go keyword in SQL Server?
stackoverflow.com

16
Is there ever a logical reason to use 1=1 in a where clause?
stackoverflow.com

12
Update with CTE and row-numbers as sequence or TSQL update query with ROW_NUMBER()
stackoverflow.com

11
Are database triggers evil?
stackoverflow.com

11
Getting only Month and Year from SQL DATE
stackoverflow.com

10
sql cross join - what use has anyone found for it?
stackoverflow.com

10
SQL indexing in a key/value database?
stackoverflow.com

10
SQL Server Join In Order
stackoverflow.com

10
COALESCE Function in TSQL
stackoverflow.com

9
Random Weighted Choice in T-SQL
stackoverflow.com

9
How to get difference between two rows for a column field?
stackoverflow.com

9
how to format float value to have only 2 digits after decimal in iOS?
stackoverflow.com

9
Nested Select Statement on LEFT JOIN
stackoverflow.com

9
Subquery inside IN clause
stackoverflow.com

9
sql - select row from group based on multiple values
stackoverflow.com

8
Cascade on Delete or use Triggers?
stackoverflow.com

8
Sql Case Statement when is not null
stackoverflow.com

8
Can I do this kind of join operation with pure SQL?
stackoverflow.com

8
Natural Join Scenario
stackoverflow.com

7
Retain original value in DataBase when NULL value is passed to Stored Procedure
stackoverflow.com

7
Why is open source software banned in some shops?
stackoverflow.com

7
Should I be using SQL transactions, while reading records?
stackoverflow.com

7
why set column to Not Null but still I can insert empty value?
stackoverflow.com

7
Optimizing a category filter
stackoverflow.com

7
SQL: How can I select table entries within the next three available dates?
stackoverflow.com

7
How to ignore trailing slash while joining two string columns in SQL
stackoverflow.com

7
Mixing Bind Variables with Literals in Oracle
stackoverflow.com

1 2 3 4