SQL SERVER INTERSECT
The SQL INTERSECT clause is used to combine two SELECT statements, but returns rows only from the first SELECT statement that are identical to a row in the second SELECT statement.
Home » SQL Basics Tutorial for beginners »
SQL Basics Tutorial for beginners
SQL SERVER User Defined Table Type and Table Valued Parameters
The Concept of User Defined table type and table valued parameters were introduced in SQL server 2008.
Get the definitions of Stored procedures, User Defined functions and Triggers in SQL
How to get the full text descriptions / definitions of any stored procedures , UDF or triggers in SQL ? There are many ways to… Read More »Get the definitions of Stored procedures, User Defined functions and Triggers in SQL
SQL FOREIGN KEY Constraint
A foreign key is a key used to link two tables together. This is sometimes also called as a referencing key , usually a primary key table is considered as a parent table while a foreign key table is considered as a child table .
SQL Query to get the list of files in a folder in SQL
How to get the list of all the files in a folder into SQL table ?
SQL LOGON Trigger
It fires in response to LOGON events of SQL Server is raised .
A LOGON Triggers can be useful in may ways, such as to restrict number of connection made by a Login or to prevent a user from logging-in outside .
SQL Triggers
SQL Server triggers are special kind of Stored Procedures that invokes whenever a special event in the database occurs.
SQL Server uses two virtual tables INSERTED and DELETED, whenever a trigger is called . These table is used to capture the data of the modified row before and after the event occurs tables , these tables are called as magic tables or virtual tables.
SQL DML AFTER TRIGGER
After Trigger (using FOR/AFTER CLAUSE)
This type of trigger fires after SQL Server finishes the execution of the action successfully that fired it.
SQL TRANSLATE()
The SQL TRANSLATE() is a string function that is used to replaces a sequence of characters in a string with another sequence of characters.
The function replaces a single character at a time. Until SQL Server 2016, we used use REPLACE() function to replace each character.
SQL SPACE
SQL SPACE() is a string function that replicates the number blanks that we want add to the given string.
Syntax
SPACE(number)
CREATE DATABASE
Database in SQL Server is a collection of tables that stores a specific set of structured data. You can eaisly interact with data such as you can Select, Update and Delete the data in tables.
How to check if User table or Temp table exists in database?
How to check if User table or Temp table exists in database?
SQL DATENAME()
The DATENAME() function returns a string, navarchar type, that represents a specified date part of date ,it can be a day , month ,year or time of specific date.
SQL CASE STATEMENT
The CASE statement has the functionality of an IF-THEN-ELSE . It goes through conditions and returns a value when the first condition is met . So, once a condition is true, it will stop reading and return the result.
Schedule a Job in SQL
The SQL Server Agent job is the specified action or series of actions that the SQL Server Agent will execute at any specific date time.
SQL LIKE CLAUSE
The SQL LIKE clause is used to match a value to a similar values using wildcard operators. It is used with Where Clause.
There are two type of wildcards used in conjunction with the LIKE operator.
The percent sign (%) that is used to represent zero , one, or multiple characters.
The underscore (_) that is used to represent a single number or character.
USER DEFINED FUNCTIONS
SQL Server allows us to create our functions called as user defined functions in SQL Server.
How to display Cumulative total in SQL ?
A Cumulative total or running total refers to the sum of values in all cells of a column that precedes the next cell in that particular column