Rich Yarger


Technical Article

Identify Column Data Types

Use the following queries to list a result set of all column data types to any specified database. In the 2nd query, you will see a result set based on all text based data type columns in your database (XML data type not included). Modify accordingly.

2.67 (3)

You rated this post out of 5. Change rating

2014-04-07 (first published: )

1,611 reads

Blogs

Using SQLFluff

By

I thought I didn’t care about linting, and lately, I haven’t written a lot...

Marketing Analyst: The Data-Driven Superhero Your Company Needs

By

Want to blend your love of marketing with the power of data? Becoming a...

Can You See Table Valued Parameters in Extended Events?

By

I live for questions and this was an interesting one. Can you see Table...

Read the latest Blogs

Forums

Dynamic T-SQL Script Parameterization Using Python

By omu

Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...

Azure SQL database import permissions

By Jo Pattyn

What the required permissions are for "Database import" on an Azure SQL database  ...

Migrating MDS model individually using MDS UI

By jaango123

Hi All,   Is there a way i can create package for an individual...

Visit the forum

Question of the Day

Column Adds and Drops

I run this batch on SQL Server 2022. What happens?

ALTER TABLE dbo.Accounts
 ADD AccountAccessType INT
GO
ALTER TABLE dbo.Accounts
 DROP AccountAccessType
GO

See possible answers