Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in sql-server-2012

Parsing SQL Server number literal with underscore

ALTER ROLE to drop all members

Converting rows to XML format in SQL Server

Is it best practice to use a static database connection across multiple threads?

Conditional RowNumber

Use SELECT result as COLUMN name in other SELECT

Auto Increment a non-identity Column in sql-server

How to get the next Sequence number in Sql Server Express using Entity Framework?

Unable to compare database schema using SSDT Visual studio 2012 "Unable to determine the database platform type. The database may be unavailable.."

Query to find all FK constraints, and their referenced table columns

Login failed for user 'Domain\UserID'. Reason: Could not find a login matching the name provided

SQL Server LCK_M_S only happens in production

Is this a 'thread-safe' way to update and return a row in SQL from a queue?

c# sql-server-2012

store result of select query into array variable

SQL: Remove part of the string from all the entries returned by the SELECT statement

Generate Self-signed certificate with Root CA Signer

JTDS driver not working for Sql Server 2008R2 and Denali Native SSPI library not loaded. Check the java.library.path system property

Select into statement where source is other database

Why is there no `select last` or `select bottom` in SQL Server like there is `select top`?

Entity Framework and SQL Server 2012 Paging