The different use of ISNULL functions in Transact-SQL and VBS

Source: Internet
Author: User
Tags documentation expression functions sql reference
sql| function

Just looked at the functions isnull in the SQL Server section of Transact-SQL Reference online documentation and found that there are different uses of the common IsNull function:

The isnull syntax described in the VBS is ISNULL (expression);

In MSSQL T-SQL, however, such use occurs: ISNULL (check_expression, Replacement_value), which is described in the online documentation as:

Parameters

Check_expression

An expression that will be checked for null. Check_expression can be of any type.

Replacement_value

An expression to be returned when check_expression is null. Replacement_value must have the same type as check_expresssion.

found that the IsNull in T-SQL is more flexible, shared out, so as to learn T-SQL friend for reference.



Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.