SQL SERVER EXCEPT
The SQL EXCEPT clause is used to combine two SELECT statements and returns rows from the first SELECT statement that are not returned by the second SELECT statement.
Home » SQL SERVER »
SQL SERVER
SQL Server Tutorials| Basics & Advance Concepts | Interview Question & Answer Series | SQL Server Tricks & Tips
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.
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 Unique Key Constraint
A unique key constraint is a set of one or more than one columns of a table that uniquely identify a record in a database table.
SQL Q & A on SELECT Statement
Q 1 > SELECT Count(1) as Output 1> NULL 2> Error 3> 1 4> Invalid select statement Answer Q 2 > SELECT Count(*) as… Read More »SQL Q & A on SELECT Statement
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 ?
Truncate VS Delete statements in SQL Server
What is the Difference between SQL Truncate and SQL Delete statements in SQL Server ?
How to access a data of table from another database in SQL Server?
How to copy a data of table from another database in SQL Server?
Suppose, you have a database1 and table1 and one another database2 and table2 in SQL server.
Now you are required to select data of a table1 of database1 from database2 of table2.
What would be a query for that?
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 STUFF
SQL STUFF() function is used to delete a sequence of given length of characters from a string and inserting the given sequence of characters from the specified starting index.
Syntax
STUFF(String, Start, Length, Newstring)
String – It is the string to be modified.
Start – The starting index from where the given length of characters will be deleted and new sequence of characters will be inserted.
Length -The number of characters to delete from string
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)
