SQL RNNR

Blog Post

Ghosts in your Database

Yes Virginia, there are ghosts in your database.  More specifically, there are ghosts in your SQL Server database.  They are...

2018-12-10 (first published: )

2,541 reads

Blog Post

Ghosts in your Database

Yes Virginia, there are ghosts in your database.  More specifically, there are ghosts in your SQL Server database.  They are not there to haunt you.  They are not there...

2018-11-26

3 reads

Blog Post

PowerShell ISE Crashes

Working with PowerShell brings a lot of advantages and power to help manage a server. The more current your PoSh version, the more efficiently you will be able to...

2018-11-19

10 reads

Blogs

T-SQL Tuesday #185: Video

By

This month’s invite is from Erik Darling, who invites you to make a video...

T-SQL Tuesday #185–Being a Video Star

By

This month we have an interesting invite. Erik Darling is the host, and since...

Building Resilience: Leadership Insights from Sports

By

In the bustling world of sports, leadership appears as a beacon of hope and...

Read the latest Blogs

Forums

The Long String

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Long String

Replace calculation in cursor with set based logic

By Chrissy321

Hello and thanks if you can help. The calculation in the cursor is correct....

Snapshot Replication: Pre-application script to check prerequisites

By sqlsauce

Is it possible to write a script that checks a subscriber's environment for prerequisites...

Visit the forum

Question of the Day

The Long String

I have a table (dbo.beer) with this data:

BeerIDBeerNamebrewerbeerdescription
-------------------------------------------------------------------------------------------------------------------------------------
1BecksInterbrewBeck's is a German-style pilsner beer known for its golden color, full-bodied taste, and a crisp, clean finish with floral and fruity hop aromas, brewed according to the German purity law
2Fat TireNew BelgiumToasty malt, gentle sweetness, flash of fresh hop bitterness. The malt and hops are perfectly balanced.
3Mac n JacksMac & Jack's BreweryThis beer erupts with a floral, hoppy taste, followed by a well rounded malty middle, finishing with a nicely organic hop flavor. Locally sourced two row grain and a blend of specialty malts give our amber its rich taste.
4Alaskan AmberAlaskan BrewingAlaskan Brewing Amber Ale is an "alt" style beer, meaning it's fermented slowly and at colder temperatures, resulting in a well-balanced, richly malty, and long-lasting flavor profile with a clean, pleasing aftertaste.
8KirinKirin BrewingKirin Ichiban is a Lager-type beer, which means it is fermented at low temperatures and offers a light and refreshing texture with a smooth and balanced flavor.
Here is the DDL For the table:
CREATE TABLE [dbo].[Beer]
(
[BeerID] [int] NOT NULL IDENTITY(1, 1),
[BeerName] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[brewer] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[beerdescription] [varchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
I run this code:
SET TEXTSIZE 20;
SELECT
  b2.BeerName
, b2.beerdescription
FROM dbo.Beer AS b2;
GO
What is returned?  

See possible answers