How to get all tables those are having a primary key
How to get all the tables in database those are having primary key constraints ?
Home » SQL Server Tutorial »
SQL Server Tutorial
This website provides a SQL server Tutorial, 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 SERVER IF..ELSE
SQL Server IF..ELSE block is a control-of-flow that allows you to execute or skip a statement block based on a specified condition.
SYNTAX
IF Boolean_expression
{ sql_statement | statement_block }
[ ELSE { sql_statement | statement_block } ]
SYNTAX
IF Boolean_expression
{ sql_statement | statement_block }
[ ELSE { sql_statement | statement_block } ]
SQL Server WHILE
SQL Server WHILE loop sets a condition for the repeated execution of an SQL statement or statement block.
SQL Server UNPIVOT
SQL Server UNPIVOT allow us to transform columns of a table-valued expression into column values that is rotating columns into rows.
It performs a reverse operation of SQL Server PIVOT.
SYNTAX
SELECT …
FROM …
UNPIVOT (
FOR
[ … ]
SQL Server Stored Procedures Vs User Defined Functions
What is the difference between SQL Server Stored Procedures and User Defined Functions (UDF)?
Following are the some major difference between Stored procedures and User Defined functions
Return a value
Stored procedure may or may not return a value while UDF function must return a value.
SQL Server NCHAR
NCHAR data type is used to store Unicode string data of fixed-length.
NCHAR data type is used to store Unicode string data of fixed-length.
It stores data at 2 byte per character.
It supports up to 4000 characters.
SQL SERVER NVARCHAR
SQL Server NVARCHAR is used to store uniqcode string data of variable length, it can store both unicode and non unicode strings.
SQL SERVER VARCHAR
SQL Server VARCHAR Data Type is used to store non-unicode string data of varaible length.
Generate calendar table in SQL Server
How to Display calendar dates for any n numbers of years in SQL Server?
SQL Server Download links
Following are the links to download SQL Server 2019 and Database sample files
How to split comma separated string values into columns
SQL Server CHAR data type is used to store non-Unicode string data of fixed-length.
SQL Server OFFSET FETCH
SQL Server OFFSET FETCH clauses are used to set the limit to number of rows returned by a query.
SQL Server PATINDEX
SQL Server PATINDEX function is a string function that returns the starting position of the first occurrence of a pattern in a specified expression.
SQL Server @@Version
SQL Server @@Version is a configuration function that returns system and build information for the current installation of SQL Server. SYNTAX @@Version Return Type of… Read More »SQL Server @@Version
SQL SERVER SP_MONITOR
SP_MONITOR is a SQL Server Database Engine system stored procedure which is used to Display statistics about Microsoft SQL Server.
SYNTAX
EXEC sp_monitor
SP_RENAME in SQL Server
SQL Server SP_NAME is SQL Server Database Engine stored procedure that is used to Changes the name of a user-created object in the current database. This object can be a table, index column or alias datatype.
SQL Server Format Function
The SQL Format function is a SQL Server string function which is used to format the specified value in the given format such as to format the date/time values and number values.
How to display currency symbol in SQL Sever
How to Display currency symbol in SQL Sever?
Sometimes we are required to display a currency symbol along with the amount in query result set, It becomes challenge to displaying a currency symbol with amount.