Technical Article

Script to determine if all chars are same in field

This script is a fix to the "Script to determine if all chars are same in field"posted by Harvard Kinkead (hneal_98) . That script doesn't handle strings with trailing spaces (e.g. set @repeat = 'bbbb ')It happens because of the nature of Len function. To bypass this limitation my script concatenates one character to tested […]

2003-05-29

69 reads

Blogs

Daily Coping 27 May 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Daily Coping 26 May 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Seeding an Availability Group Replica from Snapshot

By

Background If you’ve been using Availability Groups, you’re familiar with the replica seeding (sometimes...

Read the latest Blogs

Forums

Fill missing rows in dataset

By Ombir

I have data in table like this. I want to fill/insert the rows with...

Sign all stored procedures with a Certificate.

By HanYolo

Hello, My company is going about ever increasing our security on all our Servers/databases....

Upgrading SQL Server 2008 R2 to 2017

By stinger27

Do you guys recommend upgrading SQL Server 2008 R2 to 2017 by just running...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers