Follow Us
Categories
- Azure (8)
- DBA (17)
- Festive Greetings (2)
- Interview Questions (29)
- Miscellaneous (10)
- SQL Server (100)
- Imp SQL Difference (6)
- Most Imp SQL Concepts (13)
- SQL ACID Rule (1)
- SQL Advanced (17)
- SQL Basic (10)
- SQL Basic Concepts (17)
- SQL Best Practices (2)
- SQL CTE (2)
- SQL Cursor (1)
- SQL Data Types (1)
- SQL Database Backup (1)
- SQL Database Mirroring (1)
- SQL Database Restoration (3)
- SQL DDL, DML, DCL, TCL (1)
- SQL Derived Table (1)
- SQL Functions (17)
- SQL Group By Having (1)
- SQL Indexes (7)
- SQL Isolation Level (1)
- SQL Joins (1)
- SQL Log Shipping (1)
- SQL Merge Command (1)
- SQL Normalization (5)
- SQL Output Clause (1)
- SQL Pivot and Unpivot table (1)
- SQL Primary Key Constraint (2)
- SQL Queries Sub-queries (1)
- SQL Ranking Function (1)
- SQL Replication (1)
- SQL Server Exception handling (1)
- SQL Stored Procedure (4)
- SQL Temporary Tables (3)
- SQL Triggers (3)
- SQL Union Function (1)
- SQL View (1)
- SQL While loop (1)
- SQL Tips (5)
-
Recent Posts
- Happy New Year 2024 January 1, 2024
- SQL Joins Tricky Interview Questions April 17, 2019
- Point In Time Restore for Azure SQL Database January 8, 2019
- Azure – Creating an Azure SQL Database December 27, 2018
- Merry Christmas December 24, 2018
- SQL Triggers – An Introduction December 8, 2018
- Migrating SQL Database To Azure SQL Instance using Microsoft Database Migration Assistant (DMA) Tool November 25, 2018
Archives
- January 2024 (1)
- April 2019 (1)
- January 2019 (1)
- December 2018 (3)
- November 2018 (6)
- October 2018 (1)
- April 2018 (1)
- March 2018 (4)
- August 2017 (1)
- July 2017 (1)
- September 2016 (1)
- December 2015 (1)
- August 2015 (3)
- July 2015 (3)
- February 2015 (1)
- January 2015 (16)
- November 2014 (1)
- October 2014 (2)
- August 2014 (22)
- April 2014 (2)
- March 2014 (1)
- January 2014 (8)
- December 2013 (6)
- November 2013 (2)
- December 2012 (5)
- November 2012 (1)
- August 2012 (2)
- April 2012 (4)
- January 2012 (7)
- August 2011 (1)
- July 2011 (1)
- May 2011 (2)
- September 2010 (2)
- January 2010 (14)
- December 2009 (3)
- November 2009 (2)
- October 2009 (3)
- September 2009 (1)
- August 2009 (1)
Follow Us
Categories
- Azure (8)
- DBA (17)
- Festive Greetings (2)
- Interview Questions (29)
- Miscellaneous (10)
- SQL Server (100)
- Imp SQL Difference (6)
- Most Imp SQL Concepts (13)
- SQL ACID Rule (1)
- SQL Advanced (17)
- SQL Basic (10)
- SQL Basic Concepts (17)
- SQL Best Practices (2)
- SQL CTE (2)
- SQL Cursor (1)
- SQL Data Types (1)
- SQL Database Backup (1)
- SQL Database Mirroring (1)
- SQL Database Restoration (3)
- SQL DDL, DML, DCL, TCL (1)
- SQL Derived Table (1)
- SQL Functions (17)
- SQL Group By Having (1)
- SQL Indexes (7)
- SQL Isolation Level (1)
- SQL Joins (1)
- SQL Log Shipping (1)
- SQL Merge Command (1)
- SQL Normalization (5)
- SQL Output Clause (1)
- SQL Pivot and Unpivot table (1)
- SQL Primary Key Constraint (2)
- SQL Queries Sub-queries (1)
- SQL Ranking Function (1)
- SQL Replication (1)
- SQL Server Exception handling (1)
- SQL Stored Procedure (4)
- SQL Temporary Tables (3)
- SQL Triggers (3)
- SQL Union Function (1)
- SQL View (1)
- SQL While loop (1)
- SQL Tips (5)
Archives
- January 2024 (1)
- April 2019 (1)
- January 2019 (1)
- December 2018 (3)
- November 2018 (6)
- October 2018 (1)
- April 2018 (1)
- March 2018 (4)
- August 2017 (1)
- July 2017 (1)
- September 2016 (1)
- December 2015 (1)
- August 2015 (3)
- July 2015 (3)
- February 2015 (1)
- January 2015 (16)
- November 2014 (1)
- October 2014 (2)
- August 2014 (22)
- April 2014 (2)
- March 2014 (1)
- January 2014 (8)
- December 2013 (6)
- November 2013 (2)
- December 2012 (5)
- November 2012 (1)
- August 2012 (2)
- April 2012 (4)
- January 2012 (7)
- August 2011 (1)
- July 2011 (1)
- May 2011 (2)
- September 2010 (2)
- January 2010 (14)
- December 2009 (3)
- November 2009 (2)
- October 2009 (3)
- September 2009 (1)
- August 2009 (1)
-
Recent Posts
- Happy New Year 2024 January 1, 2024
- SQL Joins Tricky Interview Questions April 17, 2019
- Point In Time Restore for Azure SQL Database January 8, 2019
- Azure – Creating an Azure SQL Database December 27, 2018
- Merry Christmas December 24, 2018
- SQL Triggers – An Introduction December 8, 2018
- Migrating SQL Database To Azure SQL Instance using Microsoft Database Migration Assistant (DMA) Tool November 25, 2018
Archives
- January 2024 (1)
- April 2019 (1)
- January 2019 (1)
- December 2018 (3)
- November 2018 (6)
- October 2018 (1)
- April 2018 (1)
- March 2018 (4)
- August 2017 (1)
- July 2017 (1)
- September 2016 (1)
- December 2015 (1)
- August 2015 (3)
- July 2015 (3)
- February 2015 (1)
- January 2015 (16)
- November 2014 (1)
- October 2014 (2)
- August 2014 (22)
- April 2014 (2)
- March 2014 (1)
- January 2014 (8)
- December 2013 (6)
- November 2013 (2)
- December 2012 (5)
- November 2012 (1)
- August 2012 (2)
- April 2012 (4)
- January 2012 (7)
- August 2011 (1)
- July 2011 (1)
- May 2011 (2)
- September 2010 (2)
- January 2010 (14)
- December 2009 (3)
- November 2009 (2)
- October 2009 (3)
- September 2009 (1)
- August 2009 (1)
Categories
- Azure (8)
- DBA (17)
- Festive Greetings (2)
- Interview Questions (29)
- Miscellaneous (10)
- SQL Server (100)
- Imp SQL Difference (6)
- Most Imp SQL Concepts (13)
- SQL ACID Rule (1)
- SQL Advanced (17)
- SQL Basic (10)
- SQL Basic Concepts (17)
- SQL Best Practices (2)
- SQL CTE (2)
- SQL Cursor (1)
- SQL Data Types (1)
- SQL Database Backup (1)
- SQL Database Mirroring (1)
- SQL Database Restoration (3)
- SQL DDL, DML, DCL, TCL (1)
- SQL Derived Table (1)
- SQL Functions (17)
- SQL Group By Having (1)
- SQL Indexes (7)
- SQL Isolation Level (1)
- SQL Joins (1)
- SQL Log Shipping (1)
- SQL Merge Command (1)
- SQL Normalization (5)
- SQL Output Clause (1)
- SQL Pivot and Unpivot table (1)
- SQL Primary Key Constraint (2)
- SQL Queries Sub-queries (1)
- SQL Ranking Function (1)
- SQL Replication (1)
- SQL Server Exception handling (1)
- SQL Stored Procedure (4)
- SQL Temporary Tables (3)
- SQL Triggers (3)
- SQL Union Function (1)
- SQL View (1)
- SQL While loop (1)
- SQL Tips (5)
Yearly Archives: 2013
Happy New Year 2014
HAPPY NEW YEAR 2014 Wishing all of the readers of this blog a very happy New Year. Thanks for supporting me and my blog last … Continue reading
Deleting Duplicate rows using CTE
Deleting Duplicate rows using CTE Many times we caught in a situation where we have a table where there is no primary or unique column defined in it and rows with duplicate data inserted in the table. In this example … Continue reading
Answer -Question of the Week – 25/12/2013- Question 1
Question:- Suppose we have a table says tbl_students whose structure is given below:- Create table tbl_students(Studentid int identity(1,1) , Studentname nvarchar(150)) Suppose it contains the following data:- Studentid Studentname 1 Vivek Johari 2 … Continue reading
Question of the Week – 28/12/2013 – Question 2
Question:- Suppose we have a table named tbl_charactername have only one column say “charactername”. It contains 10 rows. First 5 rows contains “Vivek Johari” and the next 5 rows contains “Abhinav Golwalkar” tbl_charactername ——————— Vivek Johari Vivek Johari Vivek Johari … Continue reading
Question of the Week -25/12/2013- Question1
Suppose we have a table says tbl_students whose structure is given below:- Create table tbl_students(Studentid int identity(1,1) , Studentname nvarchar(150)) Suppose it contains the following data:- Studentid Studentname 1 Vivek Johari 2 … Continue reading
Ranking Functions in SQL Server
Ranking Function:- Sometimes we need to provide a Row number to the rows in a table or within a partition. For example, suppose we want to give rank to sales man according to their sales amount in a particular month/year. … Continue reading
Stuff VS Replace function in SQL Server
Stuff VS Replace function Stuff Function This function is used to replace string from the given start position, passed as 2nd argument with string passed as last argument. In Stuff function, 3rd argument defines the number of characters which are … Continue reading
Case Statement/ Expression in SQL Server
Case Statement/ Expression in SQL server Sometimes we need to get one result output from multiple possible outcomes based on the evaluation of some expression. This expression can be a simple case expression which compares an expression with a set … Continue reading
Posted in Most Imp SQL Concepts, SQL Basic Concepts, SQL Server
Tagged CodeProject, SQL Basic Concepts
1 Comment