SQL Server common functions and techniques

Using SQL Server for a long time, today especially want to summarize, is a review it!

Common functions:

1. ISNULL (columnName, ")

First determine if the field is empty, if it is empty, return '; Otherwise, the value of the field is returned.

2. DATEDIFF (datepart,startdate,enddate)

No wordy, direct reference link

3.

Useful statements:

1. Sometimes there are more stored procedures defined in the project, and it is necessary to determine which stored procedure is used for a given table, and there are two ways to do so:

A. SSMs interface, select the table you want to check, right-click to find dependencies, it will be displayed

B. Using the statement:

2.

SQL Server common functions and techniques