Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in tsql

Is there a simple way to create a unique integer key from a two-integer composite key?

Update all SQL NULL values in multiple columns using Column level WHERE clause?

Showing what quarter of a financial year a date is in

How to convert Float to Varchar in SQL

sql sql-server tsql

What's faster IN or OR?

SQL to find first non-numeric character in a string

sql-server tsql string parsing

Chek IF column EXISTS within an inline SELECT statement [duplicate]

How to "pick" random records with T-SQL

sql sql-server tsql

In SQL Server, how do I create a reference variable to a table?

How do I map true/false/unknown to -1/0/null without repetition?

cfquery crashes when there are tsql comments

Generate an increment ID that is unique for a given value of a foreign key

sql sql-server tsql

Why some system functions in T-SQL without parameters have parenthesis while others don't?

sql-server tsql function

What can cause 'rows affected' to be incorrect?

How to get owner and locked object from locks_lock_timeouts_greater_than_0 event in SQL Server?

Randomly assign work location and each location should not exceed the number of designated employees

Sequential SQL inserts when triggered by CROSS APPLY

sql-server tsql cross-apply

Compressing row set using CLR and GZIP