sql-server-2012 tutorials

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

Aug 26, 2022

Conditional RowNumber

Oct 31, 2022

sql sql-server sql-server-2012 row-number

Use SELECT result as COLUMN name in other SELECT

Apr 13, 2022

sql sql-server sql-server-2012

Auto Increment a non-identity Column in sql-server

Feb 07, 2022

sql sql-server tsql sql-server-2012

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

Sep 25, 2022

entity-framework entity-framework-5 sql-server-2012

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

May 20, 2019

c# visual-studio-2012 sql-server-2008-r2 sql-server-2012 sql-server-data-tools

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

Apr 13, 2022

tsql sql-server-2012 referential-integrity

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

Nov 20, 2022

sql-server sql-server-2012

SQL Server LCK_M_S only happens in production

Feb 09, 2018

sql sql-server reporting-services sql-server-2012 blocking

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

Aug 22, 2022

c# sql-server-2012

store result of select query into array variable

Mar 19, 2022

sql sql-server sql-server-2012

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

Oct 25, 2022

sql string tsql replace sql-server-2012

Generate Self-signed certificate with Root CA Signer

Sep 13, 2022

powershell sql-server-2012 windows-server-2012-r2

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

Jan 22, 2022

sql-server jdbc sql-server-2008-r2 sql-server-2012 jtds

Select into statement where source is other database

Aug 21, 2022

sql sql-server sql-server-2008 sql-server-2012 sqlbulkcopy

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

Nov 15, 2022

sql sql-server sql-server-2008 sql-server-2012

Entity Framework and SQL Server 2012 Paging

Jul 05, 2019

entity-framework sql-server-2012 entity-framework-5

How can I set an expression to the FileSpec property on Foreach File enumerator?

Nov 04, 2022

ssis sql-server-2012

Query returning all system stored procedures listed by MS SQL Server

Oct 30, 2022

sql sql-server sql-server-2012

Alter table to set the IDENTITY to off

Mar 22, 2020

sql tsql sql-server-2012

New posts in sql-server-2012