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.
Home » SQL Server »
SQL Server
This website provides a SQL server, SSRS, Power BI, Python, Azure basics and advanced tutorials for beginners and professionals .
You will find out a step-by-step walk through of the basics and advanced topics with practical and include numerous hands-on activities.
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 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.
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 DATEFROMPARTS
SQL DATEFROMPARTS() function is a date function that returns a date value that maps to a year, month, and day values.
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.
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.