SQL Server Articles

SQL Server: Date Formats

In this article i am explaining how to get different date formats in SQL Server.

SQL Server: Joins - Cartesian Product

In this article i will explain what Cartesian Product in SQL Joins? How to retrieve data from multiple table by using this join with an example?

SQL Server: How to get current week dates

In this article i will explain how to get current week dates in SQL Server with examples? When to use: Example 1: Get current week travelers list Example 2: Get current week interviews list

SQL Server: Inner Join (or) Join

In this article i will explain what is INNER JOIN.

SQL Server: Left Join (or) Left Outer Join

In this article i will explain what is Left Join (or) Left Outer Join.

SQL Server: Right Join (or) Right Outer Join

In this article i will explain what is Right Join (or) Right Outer Join.

SQL SERVER – DDL, DML, DCL and TCL Commands

In this article i will explain what is DDL in SQL Server? And What are DDL commands? what is DML in SQL Server? And What are DML commands? what is DCL in SQL Server? And What are DCL commands? what is TCL in SQL Server? And What are TCL commands?

SQL Server: Split function (or) How to Split string in SQL Server

In this article i will explain how to Split string in SQL Server (or) how to create Split function in Sql Server.

SQL Server: How to get fixed length number format in SQL Server (or) How to prefix zeros to number, to get fixed length number format in SQL Server

In this article i will explain how to get a fixed length number format in SQL Server (or) how to prefix zeros to number, to get fixed length number format in SQL Server.

SQL Server: How to replace string in SQL Server

In this article i will explain how to replace string or text in SQL Server. And how to replace table column values in SQL server.

SQL Server: Insert values into Identity Column

In this article i will explain how to insert values into Identity column in SQL Server.

SQL Server: System Databases

In this article i will explain what are System Databases. And what is the role of each System Database.

SQL Server: How to create a table

In this article i will explain how to create a table in SQL Server.

SQL Server: How to alter table column in SQL Server

In this article i will explain how to alter table column in SQL Server.

SQL Server: How to add a column to table and How to delete a column from table

In this article i will explain how to add a column to table and how to delete a column from table in SQL Server.

SQL Server: How to rename a column and How to rename a table

In this article i will explain how to rename a column and how to rename a table in SQL Server.

SQL Server: Update command

In this article i will explain what is Update command and how to use Update command in SQL Server.

SQL Server: Delete Command

In this article i will explain what is Delete command and how to use Delete command in SQL Server.

SQL Server: Truncate Command

In this article i will explain what is Truncate Command and how to use Truncate Command in SQL Server.

SQL Server: Drop Command

In this article i will explain what is Drop Command and how to use Drop Command in SQL Server.

SQL Server: Identity Column

In this article i will explain how to create a table with auto incremented column in SQL Server.

SQL Server: Differences between CHAR, NCHAR, VARCHAR and NVARCHAR

In this article i will explain differences between CHAR, NCHAR, VARCHAR and NVARCHAR in SQL Server.

SQL Server: Temporary Table

In this article i will explain what is Temporary Table in SQL Server.

SQL Server: Constraints

In this article i will explain what is Constraint. And how many Constraints available in SQL Server.

SQL Server: NOT NULL Constraint

In this article i will explain what is NOT NULL Constraint in SQL Server.

SQL Server: CHECK Constraint

In this article i will explain what is CHECK Constraint in SQL Server.

SQL Server: UNIQUE Constraint

In this article i will explain what is UNIQUE Constraint in SQL Server.

SQL Server: PRIMARY KEY Constraint

In this article i will explain what is PRIMARY KEY Constraint in SQL Server.

SQL Server: FOREIGN KEY Constraint

In this article i will explain what is FOREIGN KEY Constraint in SQL Server.

SQL Server: DEFAULT Constraint

In this article i will explain what is DEFAULT Constraint in SQL Server.

SQL Server: Delete record from parent table when there is Foreign Key relation between parent and child tables

In this article i will explain how to delete record from parent table when there is Foreign Key relation between parent and child tables in SQL Server.

SQL Server: Joins

In this article i will explain what are joins in SQL Server.

SQL Server: Full Join (or) Full Outer Join

In this article i will explain what is Full Join (or) Full Outer Join.

SQL Server: Cross Joins

In this article i will explain what is Cross Join.

SQL Server: Equi Join

In this article i will explain what is Equi Join.

SQL Server: Non Equi Join

In this article i will explain what is Non Equi Join.

SQL Server: Batches

In this article i will explain about Batches.

SQL Server: Anonymous Batches

In this article i will explain about Anonymous Batches.

SQL Server: Named Batches

In this article i will explain about Named Batches.

SQL Server: Functions

In this article i will explain what is Function.

SQL Server: Difference between Stored Procedure and Function

In this article i will explain what is the difference between Stored Procedure and Function.

SQL Server: Triggers

In this article i will explain what is Trigger.

SQL Server: Variables

In this article i will explain Different types of Variables in SQL Server.

SQL Server: Get List of Stored Procedures with Created Date and Modified Date

In this article i will explain how to get list of Stored Procedures with Created Date and Modified Date in SQL Server.

SQL Server: Get List of SQL Jobs

In this article i will explain how to get list of SQL Jobs in SQL Server.

SQL Server: Search for particular keyword in all procedures (or) Get list of procedures where particular keyword or table name is used

In this article i will explain how to search for particular keyword in all procedures (or) Get list of procedures where particular keyword or table name is used in SQL Server.