Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in tsql

How FOR XML PATH('') works when concatenating rows

Why does en-dash (–) trigger illegal XML character error (C#/SSMS)?

c# sql-server xml tsql

SQL Convert Week Number to Date (dd/MM)

sql sql-server tsql

SQL: Use multiple values in single SELECT statement

tsql sql

How to find the derived column types of a view in SQL Server 2005?

sql-server-2005 tsql

Using SELECT to obtain only fields with alphanumeric data (and certain punctuation) in SQL Server

sql-server tsql

T:SQL: select values from rows as columns

sql sql-server tsql pivot

string equivalent of Sum to concatenate

SQL Server query to find clustered indexes

Grant user insert permission after create table command

sql-server-2005 tsql

TSQL - Update table from itself

sql-server tsql

T-SQL Scripts to copy all table constraints

sql tsql ddl

What is the most efficient way to concatenate a string from all parent rows using T-SQL?

Group and Count in SQL Server 2008

T-Sql Declare and set

sql-server tsql

T-SQL recursive query - how to do it?

sql sql-server tsql

Determine varchar content in nvarchar columns

Check if DateTime in DB is more than 90 days old via Stored Procedure

Anyway to create a SQL Server DDL trigger for "SELECT" statements?

UPDATE is not allowed because the statement updates view "table_name" which participates in a join and has an INSTEAD OF UPDATE trigger