SQL samples and examples

You can make money from this site by posting original and quality articles that comply with Google AdSense policies.. Also, we offer several other reward programs including monthly profit sharing, cash rewards per post, contests & prizes etc to contributing members.

Submit Your Article

Articles

SQL User Friendly - Developer Friendly Queries

This article explains the list of user friendly/developer queries like selecting list of tables starting with specific letter, Searching for specific column in entire database, searching Sp, text and parameter names.

SSIS - Load the Multiple Sheets from Excel File and Load into SQL Table

In this article, I have explained how to load data from multiple Excel sheets to SQL Table or any other destination using SSIS. This can be achieved by using Taks like Foreach Loop Container , Data Flow Task and Components like Excel Source and OLE DB Destination.

Joins and its usages

Use of exists condition

How to use Temporary table in Stored procedure with example

In this article I'm going to explain How to use Temporary table in Stored procedure with example and also I'm explain what is Temporary table and its types. Temporary table are create at run time and then you can do the all kind of operation like normal table.

Using coalesce to build comma separated values as results from SQL Server

This article explain about how to Using coalesce to build comma separated values as results from SQL Server

Convert Money to Indian Currency Format

This is an User Defined Function to convert the Money to Indian Currency Format.

Convert a file into zip using Stored Procedure in SQL

In this we can conver file into zip format using SQL and WINRAR and BATCH command. there are lot of ways to do this. but the simplest way is using 'XP_CMDShell' command.. xp_CMDShell can execute the shell/system command which includes the batch file.

How to interchange the values of two columns in sql

How to interchange the values of two columns in sql In this article I'm going to explain how to interchange column values in database table. In sql server there is no pre defined function for interchange column values.

SQL Function for String values

This article gives a sneak peek into the various SQL functions used for formatting string\varchar values.I hope this article will be useful to you as you can find all the string functions at one place with proper descriptions and examples.

Second Highest and Lowest Salary using SQL Query

Create Insert Stored Procedure Automatically in MS SQL

If you wanted to create insert procedure automatically then this code will help you. You just need to pass the Table name as parameter to this stored procedure. Learn how to Create Insert Stored Procedure Automatically in MS SQL.

Compare Two Tables and insert Record Source Table With Increment ID

Increment ID using Row Number in Sql Server for Compare Two Tables

Create/Select/Insert/Update/Delete store procedures Automatically

when working with database applications much of time is wasted when creating sps and that too if the table is big we need to write each parametrs passing to the sp..

what is the use of Row_Number() OVER in Sql Server?

Row_Number() OVER is used to generate the row numbers automatically. The following query is used to generate the row number automatically in sql server.

Table Value Parameter (TVP) in SQL Server

This article summarize the use of Table Value Parameter (TVP) in stored procedures for DML operations. This list the advantages over the traditional way of passing multiple individual parameter as input.

How to call function from stored procedure in SQL Server?

In this article I'm going to explain how to call function from stored procedure in SQL Server. Here I have written a scalar function named AddionofTwoNumbers that accepts three input parameters and one output parameter. Now I want to call this function in Stored procedure.

How to copy files from one folder to another folder using SQL Server?

In this article I'm going to explain how to transfer files from one location to another location using sql server.

A 'Handy Code' for all - Function that splits string

Database developers often need to split a string. When we need to do so we keep on searching online for the solution as we always look for a quick fix. This code snippet has the function that splits a string and returns the plain text. Also the snippet has the code block where we can format the string. Hope this code will be a very quick reference.

Submit Your Article

SQL samples and examples

Articles

SQL User Friendly - Developer Friendly Queries

SSIS - Load the Multiple Sheets from Excel File and Load into SQL Table

Joins and its usages

Use of exists condition

How to use Temporary table in Stored procedure with example

Using coalesce to build comma separated values as results from SQL Server

Convert Money to Indian Currency Format

Convert a file into zip using Stored Procedure in SQL

How to interchange the values of two columns in sql

SQL Function for String values

Second Highest and Lowest Salary using SQL Query

Create Insert Stored Procedure Automatically in MS SQL

Compare Two Tables and insert Record Source Table With Increment ID

Create/Select/Insert/Update/Delete store procedures Automatically

what is the use of Row_Number() OVER in Sql Server?

Table Value Parameter (TVP) in SQL Server

How to call function from stored procedure in SQL Server?

How to copy files from one folder to another folder using SQL Server?

A 'Handy Code' for all - Function that splits string

How to Generate New GUID Using SQL Server

How to get float value when dividing of two integer number in SQL?

How to execute a stored procedure inside another stored procedure?

How to increase the performance and reduce the execution time of sql query

Different ways of inserting records into tables using SQL query

How to create table in sql server 2005?

About dotnetspider.com

Quick Links

General

Services