Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in tsql

How can I prevent date overlaps in SQL?

sql tsql sql-server-2008-r2

T-SQL try ... catch and multiple batches (2 begin...end, if...else)

TSQL top 1 parameter assignment issue

How do I make sure a string column has no spaces?

sql-server-2008 tsql ssms

How can I return variable column lengths via LINQ to SQL

c# .net sql linq tsql

The argument 1 of the XML data type method "value" must be a string literal

xml tsql

Group by column A but comparing column B

What is the effect of having XACT_ABORT on/off in parent/child stored procedures respectively?

How do I select just a portion of huge binary (file)?

Export database project as SQL script

SQL Server 'FOR XML' getting value into "row" element node

sql-server xml tsql for-xml

T-SQL: Converting NTEXT to VARCHAR to INT/BIGINT [duplicate]

SQL Server Pivots... Can I show the last five orders for a series of order types

sql-server tsql

How can I capture the print message from a SQL Server stored procedure? [duplicate]

Challenging recursive T-SQL query

sql-server tsql recursion

Is there a way around the 8k row length limit in SQL Server?

Conversion failed when converting the nvarchar value to data type int

sql sql-server tsql

does it worth switching a PRIMARY KEY from the type NVARCHAR to the type INT?

T-SQL Pivot with multiple aggregates on the same column

sql-server tsql

t-SQL Use row number, but on duplicate rows, use the same number

sql sql-server tsql