Thursday , February 21 2019
Home / DataBase / SQL SERVER / Every Sql Server Developer Should know this Tips

Every Sql Server Developer Should know this Tips

Every SQL Server Developer Should Know this tips

1.Query Execution Order in Sql Query:-
1.From clause
2.Where clause
3.Group by clause
4.Having clause
5.Select clause
6.Order by clause

2. Find  Number of Tables In a Single DataBase


3.Find All Number of Columns In a DataBase

4.Find Number of Columns In a Single Table


5.Find All Number of Views In a Database

6.Find Number of Views On a single Table 


7.Find All Number of Stored Procedure In a Database 

8.Find All Number of  Functions  In a Database

9.Find All Number of  Triggers  In a Database

10.Find All Number of  Indexes In a Database



don’t worry we will add more important sql server tips and query in this post keep read with us.

Print Friendly, PDF & Email

Give us your valuable feedback


About Samba

Check Also

sql server backup script

Backup all databases in SQL Instance with one script

Backup: A copy of SQL Server data that can be used to restore and recover the …