SQL Blogs

SQL

Learn SQL, a language to query and manipulate relational database management systems.

Blogs

Remove Duplicate rows in a table

Remove Duplicate rows in a table.
Siva Ganesh Rongala May 06, 2013
Call or execute a Stored Procedure from Select Statement in SQL Server using OPENROWSET

Call or execute a Stored Procedure from Select Statement in SQL Server using OPENROWSET.
Sachin Kalia May 03, 2013
Remove Last Character from a String in SQL Server

Remove last character from a string by using some SQL functions.
Pradip Pandey Apr 30, 2013
How to upgrade a database file to use LocalDB

This blog is about how to upgrade a database file to use LocalDB
Raj Kumar Apr 29, 2013
How to Create Function in SQL Server

Here, You will see how to create function and then call in SQL Query in SQL Server 2008.
Yogesh Bajpai Apr 29, 2013
Case Statement in SQL Server

This blog defines the case statement with a simple example in SQL Server.
Yogesh Bajpai Apr 29, 2013
Call Stored Procedure Inside Another Stored Procedure

SQL query example, how to call a stored procedure inside another stored procedure in SQL Server.
Pankaj Pandey Apr 22, 2013
Difference Between Stored Procedure and Functions

in this blog we will learn what is Between Functions and Stored Procedure
Vithal Wadje Apr 18, 2013
How To Import CSV File Into SQL Server

Learn how to import a csv file into a SQL Server using bulk import using SQL.
Pankaj Pandey Apr 11, 2013
SQL Query To Copy All Data From A Table Into A New Table

Here are the steps required to copy data from a database table into a new table using SQL.
Pankaj Pandey Apr 11, 2013
Difference between In and Between Operator in SQL

In this blog I will tell you that what is the difference between In and Between Operator in SQL.
Akash Garg Apr 11, 2013
How to use MAX() and MIN() Function in SQL

In this blog I will provide a quick overview of how to use the max and min functions in SQL.
Akash Garg Apr 10, 2013
Calculate Number of Working Days Between Two Date by Using SQL

In this blog we calculate the working days in a company by using SQL.
Akash Garg Apr 09, 2013
Findout First Day and Last Day With Time Of The Previous Month By Using SQL

We can find out the first and last day with time of the previous month by simple step.
Akash Garg Apr 09, 2013
Difference between SQL Server 2008 and SQL Server 2012

In this blog differences between SQL Server 2008 and SQL Server 2012 are shown
Akash Garg Apr 08, 2013
Triggers in SQL SERVER

Triggers can be classified as a special type of stored procedure that executes automatically in response to some triggering action like INSERT, UPDATA, DELETE etc
Jatin Nagpal Apr 03, 2013
Difference between @@IDENTITY, SCOPE_IDENTITY() , IDENT_CURRENT

Sql server table identity column in different session and scopes.
Nitesh Singhal Mar 31, 2013
Deleting Duplicate Records in SQL Table

Deleting Duplicate Records in SQL Table.
Kunal Vaishya Mar 25, 2013
How To Call A SQL Function In C#

Functions in SQL Server are code modules that can implement business logic and execute code.
Pankaj Pandey Mar 20, 2013
Difference Between Except and Not In and Not Exist

These are Sql keywords we usually used to filter data between two tables mostly.
Nitesh Singhal Mar 18, 2013

201 - 220 of 498