Home>> MS Sql >>Basic SQL Interview Question and Answer



Recent Post

How to Format integer to 2 digit string in SQL SERVER?

Jan 31, 2018  |   Views (10)  |   MS Sql  |  

How to DISTINCT for only one Column in MS SQL SERVER?

Jan 11, 2018  |   Views (10)  |   MS Sql  |  

How to Update int column in table with unique incrementing values in sql

Nov 30, 2017  |   Views (10)  |   MS Sql  |  

@@TRANCOUNT (Transact-SQL)

Oct 3, 2017  |   Views (10)  |   MS Sql  |  

SQL Function of manipulate text

Oct 3, 2017  |   Views (10)  |   MS Sql  |  

What is ROLLUP and CUBE Operator and how to use in MS SQL SERVER?

Oct 1, 2017  |   Views (10)  |   MS Sql  |  

What is Difference between SQL @@IDENTITY, SCOPE_IDENTITY, IDENT_CURRENT functions

Sep 21, 2017  |   Views (10)  |   MS Sql  |  

Looping concept in MS SQL SERVER

Sep 21, 2017  |   Views (10)  |   MS Sql  |  

What is Set Operators in SQL Server (UNION, UNION ALL, INTERSECT, EXCEPT)

Sep 21, 2017  |   Views (10)  |   MS Sql  |  

What is uniqueidentifier in MS SQL SERVER?

Sep 13, 2017  |   Views (10)  |   MS Sql  |  

How to rollback or commit a transaction in MS SQL Server?

Sep 13, 2017  |   Views (10)  |   MS Sql  |  

What is the range to store data in date column in MS SQL Server?

Aug 29, 2017  |   Views (10)  |   MS Sql  |  

How to view more than 200 row in editable mode in MS Sql Server?

Aug 24, 2017  |   Views (10)  |   MS Sql  |  

What is the result when table 1 have 4 row 3 column and table 2 have 3 row 3 column?

Aug 22, 2017  |   Views (10)  |   MS Sql  |  

What is Difference Between Row_Number() Rank() And Dense_Rank() In SQL Server?

Aug 22, 2017  |   Views (10)  |   MS Sql  |  

What is Magic Table in SQL SERVER?

Aug 2, 2017  |   Views (10)  |   MS Sql  |  

What is Table Variable in SQL SERVER and How to used it?

Aug 2, 2017  |   Views (10)  |   MS Sql  |  

What is Temporary or Temp table and how to use in MS SQL SERVER?

Aug 2, 2017  |   Views (10)  |   MS Sql  |  

How to add three column and put to 4th column in sql

Aug 2, 2017  |   Views (10)  |   MS Sql  |  

How to update same column name data based on Gender change?

Aug 2, 2017  |   Views (10)  |   MS Sql  |  

What is SQL Transactions and How to use?

Jul 30, 2017  |   Views (10)  |   MS Sql  |  

Copy table data with schema in Sql Server command

Jul 28, 2017  |   Views (10)  |   MS Sql  |  

How to swap Column1 to Column2 and Column2 to Column1 in SQL?

Jul 28, 2017  |   Views (10)  |   MS Sql  |  

What is CTE in SQL Server and How to used?

Jul 24, 2017  |   Views (10)  |   MS Sql  |  

How to delete duplicate record in SQL server?

Jul 24, 2017  |   Views (10)  |   MS Sql  |  

Basic SQL Interview Question and Answer

Jul 18, 2017  |   Views (10)  |   MS Sql  |  

How to specify output parameters when you use the sp_executesql stored procedure in SQL Server

Jun 4, 2017  |   Views (10)  |   MS Sql  |  

What does @ and @@ suffixed by property names specify?

Apr 10, 2017  |   Views (10)  |   MS Sql  |  

How can I set a Microsoft SQL field as identity column but to START with a certain number?

Dec 13, 2016  |   Views (160)  |   MS Sql  |  

How to Split and convert Comma Separated (Delimited) String to Table in SQL Server?

Dec 4, 2016  |   Views (299)  |   MS Sql  |  

SQL Server String Concatenation with Null

Nov 8, 2016  |   Views (220)  |   MS Sql  |  

How to Disable Enable Trigger SQL server

Nov 3, 2016  |   Views (231)  |   MS Sql  |  

How to create GUID in sql server 2012, 2008

Oct 13, 2016  |   Views (254)  |   MS Sql  |  

How to way to prevent a Divide By Zero error in SQL

Aug 17, 2016  |   Views (461)  |   MS Sql  |  

SQL cast() inside avg() for decimal value

Aug 7, 2016  |   Views (304)  |   MS Sql  |  

SQL Server 2008 Date Format

Jul 17, 2016  |   Views (355)  |   MS Sql  |  

How to using IF ELSE statement based on Count to execute different Insert statements

Jul 11, 2016  |   Views (266)  |   MS Sql  |  

How to Add Dynamic Column that pass by variable in MS Sql?

Jul 3, 2016  |   Views (307)  |   MS Sql  |  

SQL Server 2012 Auto Identity Column Value Jump Issue

Jun 29, 2016  |   Views (294)  |   MS Sql  |  

Unable to attach sql database (Microsoft SQL Server, Error: 5120)

May 11, 2016  |   Views (375)  |   MS Sql  |  

Rename object in Sql Server

Apr 14, 2016  |   Views (415)  |   MS Sql  |  

MSSQL Orderby a number Nulls and Zero last

Apr 2, 2016  |   Views (446)  |   MS Sql  |  

How to Add unique constraint to combination of two or more columns

Mar 11, 2016  |   Views (545)  |   MS Sql  |  

How to restore database in sql server

Feb 29, 2016  |   Views (484)  |   MS Sql  |  

sp_help in Sql

Feb 27, 2016  |   Views (484)  |   MS Sql  |  

How to select data based on Row Number

Feb 27, 2016  |   Views (551)  |   MS Sql  |  

Convert string to datetime sql

Feb 26, 2016  |   Views (4747)  |   MS Sql  |  

How to rollback after wrong update statement in sql server 2008R2

Feb 26, 2016  |   Views (437)  |   MS Sql  |  

What is sql Profiler?

Feb 10, 2016  |   Views (535)  |   MS Sql  |  

What is the difference between adhoc queries from stored procedures?

Feb 9, 2016  |   Views (660)  |   MS Sql  |  

About the author

Krishan Kumar Singh, dotnet360.in

Hello!  I'm Krishan Kumar Singh author, .NET Framework and have more than 6+ years of hand over Microsoft .NET technologies.

I am the co-founder of  DOT NET TRICK    http://dntrick.com/


I love to work with web, window and mobile applications  of Microsoft technology
including ASP.NET, C#.Net, Ado.Net,  MVC, MS SQL Server, WCF, Web API, Razor, Entity Framework, Firebase, Oracle, HTML, CSS, jQuery,  Angular.js, JSON and many more web technologies.