SQL Server 2012

External Article

CONCAT and STUFF Functions in SQL Server 2012

  • Article

The difference between the CONCAT function and the STUFF function lies in the fact that CONCAT allows you to append a string value at the end of another string value whereas STUFF allows you insert or replace a string value into or in between another string value. Read on to learn more about these functions and their real life usage.

2015-05-01

9,908 reads

External Article

Lead and Lag Functions in SQL Server 2012

  • Article

Arshad Ali discusses how to use CTE and the ranking function to access or query data from previous or subsequent rows. He also shows you how to leverage the LEAD and LAG analytics functions to achieve the same result without writing a self-join query using CTE and ranking function

2014-12-10

8,382 reads

Blogs

Creating a user for a STONITH resource in vSphere

By

I previously blogged about how to create a STONITH resource for a pacemaker cluster...

Default event_file path for Extended Events

By

Foreword Have you ever wondered where the .xel file is saved when you create a...

Query Store Hints in SQL Server 2022

By

Another neat little feature in SQL Server 2022 is Query Store Hints. This is...

Read the latest Blogs

Forums

Display Top N values of a table with calculation next to it

By Soof1234

Hi, In Power BI Report Builder I need to use SSRS code for my...

Package runs in Debug mode but fails otherwise

By Alexp012

Hi We have a SSIS package that uploads data to Blob storage. The package...

Can anyone suggest a plan with backup full and backup log without backup diff ?

By vpmaciel

I need only one backup full at mid night, and one backup log each...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers