Saturday , August 18 2018
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

SELECT COUNT(*)
FROM INFORMATION_SCHEMA.COLUMNS where TABLE_NAME = ‘<TableName>’

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

or

 

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

comments

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 …