What is USING keyword in SQL Server 2008?
Asked Answered
S

0

3

I know the beautiful usage of the SQL clause "USING": it is similar to NATURAL JOIN but you must detail the join columns; you can join more simply (and faster) the tables that have the same key and foreign key, and the output of queries doesn't contain redundant fields.

However SQL Server 2008 doesn't support the JOIN with the USING keyword, but, as you can see in the link, it uses this keyword. Why?

Supervisory answered 17/5, 2013 at 20:3 Comment(2)
USING is part of MERGE. Don't assume that an entry in the list of reserved keywords means that it functions the same as it does in some other platform...Checkmate
yes it is! you are rightSupervisory

© 2022 - 2024 — McMap. All rights reserved.