In this article, we learn about SQL Server Snapshot. SNAPSHOT Snapshots are used to create a recent copy of the table. It contains all records or selected records from the table. SYNTAX OF CREATING SNAPSHOT CREATE SNAPSHOT <list of options> AS <select query> Example:- CREATE SNAPSHOT emp_snap AS SELECT *…

In this article, we learn about the SQL Server synonym. SYNONYM A synonym is an alias to the table, view, sequence, stored procedure, and function. There are two types of synonym: Private synonym:- A private synonym exists only in a specified user. The owner controls the availability of synonym to…

In this article, we learn about the sequence. SEQUENCE A sequence generates a sequence of unique integer values. A sequence has different orders like ascending or descending. We can view the sequence object under the Programmability →Sequences. SYNTAX OF CREATING SEQUENCE CREATE SEQUENCE [schema_name . ] sequence_name [ AS…

In this article, we learn about the difference between triggers and stored procedures. TRIGGER A Trigger is nothing but logic. A Trigger is a stored procedure it runs automatically when an event occurs. Syntax: CREATE TRIGGER trigger_name ON table_name AFTER {[INSERT],[UPDATE],[DELETE]} AS BEGIN {sql_statement} END STORED PROCEDURE A stored procedure…

In this article, we learn about Math Functions in SQL Server. ABS The ABS() function returns the absolute value of a number. Syntax: ABS(number) AVG The AVG() function returns the average value of an expression. NULL values are ignored. Syntax: AVG(expression) CEILING The CEILING() function returns the smallest integer value…

In this article, we learn about Date Time Function in SQL Server. CURRENT_TIMESTAMP The CURRENT_TIMESTAMP function returns the current timestamp of the operating system. The returned timestamp is a DATETIME value without the time zone offset. Syntax: CURRENT_TIMESTAMP DATEADD The DATEADD() function adds a time/date interval to date and then…

In this article, we discuss conversion and configuration functions in SQL Server. CONVERSION FUNCTIONS Conversion functions are single row functions that are capable of typecasting column value or an expression. Conversion Functions:- CAST(), CONVERT(), and TRY_CAST(), TRY_CONVERT(), CAST() and CONVERT() CAST and CONVERT functions used to convert one data type…

In this article, we learn about string function in SQL Server. SQL Server string functions process on an input string and return a string or numeric value. ASCII ASCII stands for American Standard Code for Information Interchange. It returns the ASCII code value for the specific character. Syntax: ASCII (…

In this article, we discuss the difference between Inner Join, Cross Join, and Full Outer Join. A Join is used to combine two tables, it depends on the relationship between tables. Joins are used to retrieve data from multiple tables. We join between two or more tables through the primary…