Follow Us
Categories
- Azure (8)
- DBA (17)
- Festive Greetings (1)
- Interview Questions (29)
- Miscellaneous (10)
- SQL Server (99)
- 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
- 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
- How to migrate SQL Database to Azure SQL Database using SSMS Export/Import November 19, 2018
Archives
- 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)
Category Archives: SQL Basic Concepts
IN clause in SQL Server
With IN clause, we can specify multiple values in a WHERE clause. For example, in case of “IN”, one can use the subquery to get the multiple values in the IN clause or we can have predefined values. In this … Continue reading
AND and OR Operator in Sql Server
And & Or:- These Operators are used to further filter the recordset return by SQL queries when more than one conditions are specified. In case of “AND” all the conditions must be true and in case of “OR” any of … Continue reading
Except command in SQL Server
Except command in SQL Server returns the distinct values from the left query that are not also found on the right query. For Except command, below basic rules must be followed. The number and the order of the columns must … Continue reading
Intersection command in SQL Server
This function is used to returns distinct values that are returned by both the query on the left and right sides of the INTERSECT operand. For intersection command, below basic rules must be followed. The number and the order of … Continue reading
While loop in SQL server
While loop in SQL server Introduction In While loop, we set a condition for the repeated execution of a Code block. So we use while loop in SQL Server to repeat execution of a SQL Code block or a SQL Statement … Continue reading
Posted in SQL Basic Concepts, SQL Server, SQL While loop
Tagged CodeProject, SQL Basic Concepts, Sql Server, While Loop In SQL Server
13 Comments
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
Adding , Deleting and Updating a Column in a table
Many times we need to alter the table definition by adding , deleting or updating a column in the table. In this article, I am trying to explain the following :- 1. How to add a column 2. How to … Continue reading
SQL Server-Table Variable
Table variable:- SQL Server provides an variable known as table variable which is used to store data in a similar way as we store data in physical tables but with some limitations. Like other SQL variable, it is also declare with the help … Continue reading
Posted in SQL Basic Concepts, SQL Server, SQL Temporary Tables
Tagged SQL Basic Concepts, SQL Temporary table
4 Comments
How to change the database collation
To change the collation of an database following commands can be used: ALTER DATABASE [database name] SET SINGLE_USER WITH ROLLBACK IMMEDIATE ALTER DATABASE [database name] COLLATE Newcollation ALTER DATABASE [database name] SET MULTI_USER For example , suppose if the name of your database is learningdb and you want to change the collation to the collation SQL_Latin1_General_CP1257_CI_AS, … Continue reading