Things to Observe on SQL

A) While writing the Queries using in SQL Query Analyzer tool we need not to follow any particular case.Because SQL is case insensitive language.
B)After writing the Query,we need to select that query using either mouse or keyboard.
C)Now Press F5.
D) Then the results are displayed in a separate window called Result window or Result Pane.
E) Use Ctrl+R to Hide/Show the result window or result Pane.

1) SQL SERVER can handle nearly 32767 Databases.
2) Each Database can handle nearly 20000 Tables.
3) Each Table can handle nearly 1024 Columns.
4) Each Table can handle nearly 2lacks Rows.

No comments: