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

WHERE

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