SQL Server Data Types Tips

Browse Categories

Aggregates

Application Development

Change Data Capture

Constraints

Data Science

Data Types

Database Design

Dates

Debugging

DevOps

Dynamic Management Views

Dynamic SQL

Encryption

Entity Framework

Error Handling

Excel Integration

Full Text Search

Functions - System

Functions - User Defined

Identities

Import and Export

In-Memory OLTP

JOIN Tables

LINQ

Microsoft Access

Microsoft Flow

Paging

Power BI

Python

Query Optimization

Query Plans

Scripts

Service Broker

Spatial Data Storage

SQL Injection

SQL Mgmt Objects (SMO)

Stored Procedures

Synonyms

T-SQL

Table Valued Parameters

Temp Tables

Temporal Tables

Testing

Transactions

Triggers

User Defined Type UDT

Views

XML

All Tips

Comparison of the VARCHAR(max) and VARCHAR(n) SQL Server Data Types

Conversions

Decimal Conversions in SQL Server Change Datatype Format

Cross Platform

Comparing SQL Server and Oracle datatypes

Data

Development

SQL Server differences of char, nchar, varchar and nvarchar data types

Functions

How to get length of Text, NText and Image columns in SQL Server

Hierarchies

SQL Server Data Type Precedence

Import and Export

Handling error converting data type varchar to numeric in SQL Server

Performance

Security

Security for SQL Server User Defined Data Types

Troubleshooting

Row sizes exceeding 8060 bytes in Sql 2005

More SQL Server Solutions

download

get free sql tips