DataTypes

Technical Article

Identify Column Data Types

  • Script

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,504 reads

External Article

Security for SQL Server User Defined Data Types

  • Article

I have a group of developers that I support and they are reporting they cannot see columns within their tables. I have granted them db_datareader permissions which is a standard at my company for QA environments. Why can't they see their column definitions? Check out this tip to learn more.

2013-07-12

3,682 reads

External Article

SQL Server Data Type Precedence

  • Article

I am executing a simple query/stored procedure from my application against a large table and it's taking a long time to execute. The column I'm using in my WHERE clause is indexed and it's very selective. The search column is not wrapped in a function so that's not the issue. What could be going wrong?

2012-09-04

2,480 reads

Blogs

Create and Verify Microsoft Fabric Capacity

By

From June 1, 2023, Microsoft Fabric (preview) capacities are available via the Azure portal....

What is Always Encrypted and how does it work?

By

Always Encrypted was a new encryption feature added to SQL Server with the 2016...

Power BI – Empowering Users to Disable Tooltips

By

Let’s set the scene. You’ve built a wonderful, useful, and descriptive report for your...

Read the latest Blogs

Forums

Falschgeld kaufen in essen WhatsApp….. +17785578351 Kaufen Sie 100 % nicht nachw

By william2244

Falschgeld kaufen in essen WhatsApp….. +17785578351 Kaufen Sie 100 % nicht nachweisbare gefälschte Banknoten...

Display columns from multiple rows in single

By gjoelson 29755

Hello,  Im looking for assistance. I have this query and need to display the...

Azure Datawarehouse or SQL Pools and profiler equivalent...

By digdave7

I added the Profiler module to AZure Data Studio in our ("Microsoft Azure SQL...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Refresh Limits

See possible answers