Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in t-sql

SQL Server date between LIKE

sql sql-server t-sql

Why would replacing a parameter with a local variable speed up a query

sql sql-server t-sql

Why this T-SQL query doesn't work in Synapse?

Is it possible to get the definition of a Stored Procedure using the name (without having to look in the object explorer)

sql-server t-sql

Declare a table variable within a user defined function

Unicode to Non-Unicode conversion

Why do I have to include the primary key column in this insert statement?

Using IF EXISTS with a stored procedure as argument

Why does query execution continue after RETURN?

sql-server t-sql

SQL - percentage of total rows

sql sql-server t-sql

How does one Remove a Partition from a Table?

Sql Server: How do I unpivot with an alias?

Why does SQL Server perform a clustered scan when IN clause has a subquery?

T-SQL Group by with a where clause

recursive cte - mark all leafs

Scalar Function with CTE Fails

Calculating daily growth using previous row value in new column - SQL Server

sql sql-server t-sql

How can I use JSON_MODIFY to update all elements in an array that match a some criteria

arrays json t-sql

How to remove all special characters from a column name string using regular expressions

sql sql-server regex t-sql

Changing Quoted_Identifier on existing Constraints / Rules / Procedures