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 .
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:
Post a Comment