Mark Chaffin

Mark Chaffin is Data Warehouse Architect for Encore Development (http://www.encoredev.com) and has developed numerous decision support systems for clients in such industries as technology, mortgage banking, retail, financial services and insurance. He also has experience in clickstream analytics, data mining, transactional application architecture, Internet application architecture, database administration and database design. He has completed a book about Data Transformation Services with Brian Knight (http://www.sqlservercentral.com/columnists/bknight).

All authors

All authors

Blogs

Advice I Like: Failure

By

If it fails where you thought it would fail that is not a failure....

Data Conferences – Worth Every Dollar

By

Some of the best career enhancers you can buy.   Why I Go to...

SQL Server 2025 RegEx and AI

By

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

Read the latest Blogs

Forums

SQL 2022 stuck on xp_delete_file

By PJ_SQL

SQL 2022 hangs on xp_delete_file, it works for a while when sever is rebooted...

Select @ for different fields

By bswhipp

I have a need where I need to pass a field name to a...

Getting the Object Code

By Steve Jones - SSC Editor

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

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