Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in sql-server

How to alter a DateTime field when it is updated?

q-gram approximate matching optimisations

How to find out what SQL queries are being blocked and what's blocking them?

Retrieve last row inserted with Uniqueidentifier that it is not IDENTITY

Suggestions on Troubleshooting "FOR XML EXPLICIT" Msg 6833 "requires parent tags to be opened first" Error

Order by and Different Types in a CASE

Elmah not working on IIS7 server

SQL Server - AFTER UPDATE vs FOR UPDATE?

sql-server triggers

How can I add text to my column's select statement

sql-server

Is it ever a good idea to have a record in a reference table in your database that represent "all other records"?

Get the nearest longitude and latitude from MSSQL database table?

Getting current user with a sql trigger

sql sql-server

Is ORDER BY and ROW_NUMBER() deterministic?

sql sql-server tsql

Cannot insert duplicate key row in object with unique index

sql sql-server database

image data types are invalid for local variables (using openrowset cannot make it work)

sql-server tsql openrowset

How to calculate ratio using sql query?

mysql sql-server oracle

How can I create a concatenated message in a SQL Server throw?

SQL Server: weighted average + GROUP BY

sql sql-server tsql

Optimize temporal table with CTE

.NET: SqlDataReader.Close or .Dispose results in Timeout Expired exception