Insert multi language data in table
Sometimes, you need to store multi language or multilingual data in any table column. Inserting a multilingual data into column without following some basics rules,… Read More »Insert multi language data in table
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 Random Number
SQL RAND function is a mathematical function which returns a pseudo-random float value from 0 through 1, exclusive or a random value within any range.… Read More »SQL Random Number
How to insert the result of a stored procedure into table
Sometimes, you want to store the result of a stored procedure into table or temp table instead of returning the output. Storing output of stored… Read More »How to insert the result of a stored procedure into table
Delete Horizontal White Space in SQL Serve
When you are required to import data received from different different file format such as .txt, .csv., or excel files, sometimes you see a white… Read More »Delete Horizontal White Space in SQL Serve
Date and Time Conversions in SQL Server
Sometimes you need to format a date in specific format such as format a date time string YYYY-MM-DD hh:mm:ss. mmm to date MM:DD:YY. SQL Server… Read More »Date and Time Conversions in SQL Server
Get Row Counts for all tables in SQL Server
Sometime you are required to validate the row counts for each tables in database. So getting a row counts for each tables either through using… Read More »Get Row Counts for all tables in SQL Server
Object_Id Metadata Function
Object_ID is a SQL Server Metadata function which returns the database object identification number of a schema-scoped object. It can not be used for object… Read More »Object_Id Metadata Function
Dynamic Data Masking in SQL Server
Dynamic data masking also known as DDM is a security feature in SQL Server which helps you to prevent the access of unauthorize users to… Read More »Dynamic Data Masking in SQL Server
PARSENAME Function
PARSENAME function is a SQL Server Metadata function which returns the specified part of an object name. The parts of an object that can be… Read More »PARSENAME Function
How to get Ordinal Number in SQL
If any number that is written like as 1st, 2nd, 3rd and so on.. is called an ordinal number, and it is read as 1st(… Read More »How to get Ordinal Number in SQL
SQL Code Snippets
SQL code snippet is a template which contains the basic structure of a Transact-SQL statement or block, so that you can quickly write queries without… Read More »SQL Code Snippets
DROP IF EXISTS
SQL Server 2016 has released an optional IF EXISTS clause with DROP statement that can be used as DROP IF EXISTS. DROP IF EXITS verify… Read More »DROP IF EXISTS
SQL Server Saving Changes is not permitted error
You might have faced an error as shown below, when you make some changes in table from design mode in SQL server management studio (SSMS).… Read More »SQL Server Saving Changes is not permitted error
Script table in SQL Server
You can script a table from database using a SQL Server Management Studio. SQL Server Management allows you to script out tables from database using… Read More »Script table in SQL Server
Generate Database Scripts With Data in SQL Server
You can generate a database scripts including the schema and the data by using the Generate Scripts option available in SQL Server Management Studio (SSMS),… Read More »Generate Database Scripts With Data in SQL Server
Table Value Constructor
Table Value Constructor (TVC) allows to group multiple rows of data in a single DML statement. It can be used as a part of either… Read More »Table Value Constructor
Change the column name and data type of result set of stored procedure
SQL Server 2012 has released a new feature WITH RESULT SETS, which allows column names and their data types to be changed in the result set… Read More »Change the column name and data type of result set of stored procedure
How to get TOP N records for each category
Selecting a top n records for each category from any table, can be done easily using row_number function which generates a sequential integer to each… Read More »How to get TOP N records for each category
IDENT_CURRENT Function
The IDENT_CURRENT function returns the last IDENTITY value generated for any specific table or view on an identity column in any session and any scope.… Read More »IDENT_CURRENT Function
SQL ROLLBACK Transactions
SQL ROLLBACK transaction statement rolls back an explicit or implicit transaction to the beginning of the transaction. If a savepoint is specified, it rolls back… Read More »SQL ROLLBACK Transactions