Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
-
Economics & Finance
Articles by Samriddhi Sharma
2 articles
How To Reset Identity Column Values In SQL
What is an Identity Column? The Identity column of a table is a column whose value increments consequently. This can be used to create unique identifiers, such as primary keys. Syntax Following is the syntax to create an Identity column. The initial setting for identity is represented as IDENTITY (1, 1). IDENTITY [ ( seed , increment ) ] Where − Seed: The seed determines the initial value of an ID, with a default setting of 1. Increment: This denotes the step value for ID increments, which also defaults ...
Read MoreHow to Set a Column Value to Null in SQL?
Setting a Column Value to Null To set a column value to NULL, use the SQL UPDATE statement, which allows modification of existing records in a table. The basic syntax for setting a column value to NULL is − Syntax UPDATE table_name SET column_name = NULL WHERE conditions; Where − table_name: Replace this with the name of the table you intend to update. column_name: Substitute this with the name of the column to be updated. NULL: Denotes the NULL value in SQL. ...
Read More