Collections:
Assigning NULL Values to Variables or Columns in SQL Server
How To Assign NULL Values to Variables or Columns in SQL Server Transact-SQL?
✍: FYIcenter.com
The rule for assigning NULL values to variables or table columns is simple: Use keyword "NULL" directly as normal values.
The tutorial script below gives you some good examples:
USE FyiCenterData; GO -- assign NULL values to variables DECLARE @birth_date DATETIME; SET @birth_date = NULL; SELECT @birth_date; GO ----------------------- NULL -- assign NULL values to columns UPDATE fyi_links SET notes = NULL; GO (8 row(s) affected) -- assign NULL values to parameters EXEC sp_help NULL; GO Name ---------------- fyi_links_dump fyi_links_top fyi_links_view ...
⇒ NULL Values Involved in Arithmetic Operations in SQL Server
⇐ What Are NULL Values in SQL Server
2017-02-05, 1475🔥, 0💬
Popular Posts:
What Is an Oracle Tablespace in Oracle? An Oracle tablespace is a big unit of logical storage in an ...
How To List All Stored Procedures in the Current Database in SQL Server Transact-SQL? If you want to...
How to download Microsoft SQL Server 2005 Express Edition in SQL Server? Microsoft SQL Server 2005 E...
What Happens If the UPDATE Subquery Returns Multiple Rows in MySQL? If a subquery is used in a UPDAT...
How To Connect ASP Pages to Oracle Servers in Oracle? If you are running Windows IIS Web server and ...