SSMS - Query Designer

This option will be really helpful for beginners and even for advanced T-SQL developers if they are joining more number of tables.

You can find this option in SSMS - > Query - > Design Query in Editor ... 
or press CTRL+SHIFT+Q

Using this option,you can

add tables to be joined,
specify columns to be selected,
assign type of joins between tables,
mention sort type,
specify table alias names

you can copy the generated query in the designer and run it on new window .

No comments: