SQL, SQL, Little Star
  • Home
  • About
  • Search for:

antonbijl

Microsoft SQL Server

varchar vs nvarchar (and text, ntext, char, nchar)

Anyone who’s ever created a table in SQL has probably at some point wanted to add a field to store text values and wondered about the difference between all the various options. These are numerous. The most commonly used are varchar, nvarchar, char, nchar, text, and ntext. You could also Read more…

By antonbijl, 4 years ago 2018-05-27
Microsoft SQL Server

TRANSACT-SQL: JOIN…ON condition or WHERE condition – which is better?

A colleague suggested I write about this topic as she often wonders about it, but doesn’t really understand the implications and has never had a chance to test it. Basically, the question is whether it’s better to add a condition in a query in the WHERE clause at the end Read more…

By antonbijl, 4 years ago 2018-05-26
Search
Recent Posts
  • varchar vs nvarchar (and text, ntext, char, nchar)
  • TRANSACT-SQL: JOIN…ON condition or WHERE condition – which is better?
Tags
char data types JOIN nchar ntext nvarchar ON SQL text Transact-SQL Unicode varchar WHERE
  • Home
  • About
Hestia | Powered by WordPress