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, 1435🔥, 0💬
Popular Posts:
How To Change the Password for Your Own User Account in MySQL? If you want to change the password of...
How To Format DATETIME Values to Strings with the CONVERT() Function in SQL Server Transact-SQL? SQL...
Where to find answers to frequently asked questions I am new to Oracle database. Here is a list of f...
Where to find answers to frequently asked questions on Transaction Management: Commit or Rollback in...
Where to find answers to frequently asked questions on Conditional Statements and Loops in SQL Serve...