SQL Swimmer

Blog Post

Don’t Forget To Take Break

So many times we get sucked into a rabbit whole when fixing/troubleshooting things we forget to take a break.  More often than not this leads to the “not seeing...

2019-01-23

4 reads

Blog Post

Speaking at DataGrillen

After speaking at SQL Saturday Iceland last year, which is a smaller event that I absolutely loved (you can read about that adventure here), I decided I wanted to...

2019-01-04

4 reads

Blogs

SQL Server 2025 RegEx and AI

By

One of the language changes in SQL Server 2025 that I’ve seen a lot...

T-SQL Tuesday #192: SQL Server 2025 Backup Changes

By

I hosted this month, but I decided to put my own entry in as...

Why Databases Still Fascinate Me

By

I get asked a lot about why or how I began working with databases...

Read the latest Blogs

Forums

Getting the Object Code

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Getting the Object Code

T-SQL in SQL Server 2025: Concatenating Strings

By Steve Jones - SSC Editor

Comments posted to this topic are about the item T-SQL in SQL Server 2025:...

Being Mindful of Design Time

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Being Mindful of Design Time

Visit the forum

Question of the Day

Getting the Object Code

What happens when I run this on SQL Server 2022 in the AdventureWorks2022 database? 

SELECT OBJECT_DEFINITION (OBJECT_ID(N'dbo.uspGetBillofMaterials')) AS [Object Definition]; 
GO

See possible answers