Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in tsql

Grouping sets by year, month, and date

Update each row in table

sql sql-server function tsql

ORACLE update with returning OLD and NEW values

sql oracle tsql plsql oracle12c

SQL Server Data Masking Minimum permissions needed to mask

database in restore state

ROWNUM as a pseudo column equivalent in T-SQL?

sql sql-server oracle tsql plsql

Where to use the column-level encryption of SQL?

Why does @@ROWCOUNT return 1 for a NULL statement using sp_executesql?

sql sql-server tsql null

How can I work around SQL Server - Inline Table Value Function execution plan variation based on parameters?

Patterns for stored procedures?

Approximating Page Views Per Tag (or Tag Group) Per Month with Limited Data?

sql sql-server tsql

Table Valued Function where did my query plan go?

sql server, cascade delete and parent/child table

TSQL: Cannot perform an aggregate function AVG on COUNT(*) to find busiest hours of day

How do I find all stored procedures that insert, update, or delete records?

sql-server tsql

Updating table with random data With NEWID() does not work

Capturing SQL STATISTICS TIME and IO into a table

sql-server tsql

T-SQL DateDiff - partition by "full hours ago", rather than "times minutes turned 00 since"

SQL Server 2008 : replace string

sql sql-server tsql string

How to deny delete on a table for all users

sql sql-server tsql