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, 1436🔥, 0💬
Popular Posts:
How To Select All Columns of All Rows from a Table with a SELECT statement in SQL Server? The simple...
How To Convert a Unicode Strings to Non-Unicode Strings in SQL Server Transact-SQL? Since Unicode ch...
How to set database to be READ_ONLY in SQL Server? Databases in SQL Server have two update options: ...
How to set the current database in SQL Server? Once you are connected to the SQL Server, you should ...
How to download and install SQL Server 2005 Sample Scripts in SQL Server? If you want to learn from ...