char

Sherlee Dizon looks at the basic differences between char, nchar, varchar, and nvarchar, as well as what to be aware of when using each data type.

2016-07-21

5,665 reads

Generate script to change column length of string datatypes in a DB

This script can be used to generate alter column length of any string data type column(s) in a database.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2011-12-27 (first published: 2011-11-22)

1,251 reads

Recently, the world was reminded of just how fragile the internet can be. Two...

In Parts 1-3, I covered how I prepare for a certification exam. In this...

I was chatting with the product managers at Flyway and one asked me whether...

I have a view where I am casting a datetimeoffset(7) field to smalldatetime or...

Hi everyone, We are selling cars and have a range of options at our...

hi for the 2 years i've been here I believe we've had "encryption" turned...

In SQL Server 2025, what does this return?

DECLARE @player varchar(20) = 'Bo Nix',
@num VARCHAR = '10'

SELECT @player || @num