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 Interview Question and Answer »
SQL Server Interview Question and Answer
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 Server TEMPORAL TABLE
SQL Server Temporal tables (system-versioned tables) allow us to track data changes. It was introduced in SQL Server 2016.
It allows SQL Server to maintain and manage the history of the data in the table automatically, So we can get all information about the data that was stored at any specified time rather than just the data that is current.
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 FOR JSON Clause
SQL Server FOR JSON Clause
SQL Server FOR JSON Clause is used to format query result to JSON format or export data from SQL Server as JSON format. It was introduced in SQL Server 2016 version.
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.
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 Verbose Truncation Warnings
SQL Server Verbose Truncation WarningsÂ
Sometimes we receives data truncation error in SQL Server such as “String or binary data would be truncated” and it does not specify exact source of error in terms of Database name, table name , column name and truncated values.
How to find Nth Highest Salary in SQL Server
This is one of the most commonly asked question in SQL Server interview that how to find the Nth highest salary of employee with their… Read More »How to find Nth Highest Salary in SQL Server
SQL Server @@SPID
SQL Server @@SPID
SQL Server @@SPID is a SQL Server configuration function that is used to return the session id of current user process.
SYNTAX
@@SPID
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
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.
How to get the sizes of all databases on a SQL Server
How to get the sizes of all databases on a SQL Server ?
SQL Server Lead Function
SQL Server LEAD() function is a Analytics function that provides access to a row at a specified physical offset which follows the current row.
Basically, LEAD() function provides access to a row at a given physical offset that follows the current row.
SQL Server Synonyms
A synonym is a database object that allows an alternative name for another database object, referred to as the base object, that can exist on a local or remote server.