SQL- CodeProject

by Elina Blank

When cursors are inside transaction, it is sometimes easy to forget to close the cursor

by Elina Blank

An alternative (simpler way :) ) is:BEGIN TRANDECLARE IdCursor CURSOR FOR SELECT Id FROM MyTable OPEN IdCursor FETCH NEXT FROM IdCursor INTO @CurrentIdWHILE (@@FETCH_STATUS) = 0 BEGIN -- do work IF @@error 0...

by Kabwla.Phone

You also might want to look into the "LOCAL" keyword.This limits the scope of the cursor to the context in which it is created.DECLARE IdCursor CURSOR LOCAL FOR SELECT Id FROM MyTableThis is beneficial for many reasons.

Anonymization of Patients' Data in MySQL

by Elina Blank

To see the default value of the cursor scope:select * from sys.databases(if value of "is_local_cursor_default" is 0 then scope id global, otherwise it is local).The scope is GLOBAL by default (for compatibility reasons).To change default scope use following:ALTER DATABASE...

Amount to Words

by NightWizzard

Convert amounts to their spoken equivalents

by Member 11313437

How to easily anonymize (or pseudonymize, depending on the depth of performing) patients' proper data in clear text in MySQL

Another reason for getting the error “A network-related or instance-specific error occurred while establishing a connection to SQL Server…” in MS...

by Sadeque Sharif

Another way to solve the issue of “A network-related or instance-specific error occurred while establishing a connection to SQL Server…”

Another Way to Get Identity from SQL Server

by nithyananthams

Different options to get Identity from SQL Server and how OUTPUT clause helped me to get the accurate Identity value compare with other options.

Anyone Who Is Querying Ought To Know These

by Shyam S Singh

This is a simple tip to describe how to write an optimized SQL query when we are dealing/working on large amount of data.

Apply Operator in SQL Server

by sandeepmittal11

Apply Operator in SQL Server

Apply Operator in SQL Server Simplified

by Gaurav_Chaudhary

This tip is a brief introduction to Apply operator in SQL server

Applying Database Principal Throughout the Server (for all Databases) for a Particular User

by Manjuke Fernando

How to give db_datareader access to a specific user across all the databases on a particular SQL Server

Applying Running Total to a Result set

by Chamila Nishantha

This tip describes how to add a running total column to a result set

Applying Running Total to a Result set

by Wendelius

This is an alternative for "Applying Running Total to a Result set"

Arbitrary parameters in SSIS for OLE DB

by Ryszard Dżegan

How to get around restrictions for parameters in OLE DB connection type while working with SSIS and BIDS.

Ask Your Database for that Unique ID

by Peter Leow

Get your database to generate unique running IDs for your application

ASP.NET 5 - Connect to SQL Azure Database

by JoaoSousa23

Using MVC, Entity Framework, ASP.NET5 Scaffolding, and Azure SQLServer you can create a web application that stores your information on an SQL Azure database. This demo shows you how to create a web application with MVC and Entity Framework 7, that communicate with a SQL Azure Database

Assign random value in set to column when updating a table

by Haydn Chapman

A method to update a table column with a random set of specified values

Attunity Connectors to Transfer Data from Oracle to SQL Server using SSIS

by Divyant Kulshrestha

This tip is useful when we have to move data from Oracle database to SQL Server database or vice-versa using SSIS.

Auto Backup Of Database in SQL Server 2008 & Above

by Harsh Aggarwal - India

It's about making back up of database in SQL server 2008 and above you can get rid of making bak file manually.

Auto Generate a Lot of Columns in Reporting Services (RDL)

by be05x5

SQL script that will generate XML code that you can copy paste into your RDL file and just do it that way

Auto Increment Column Options in Different Databases

by DiponRoy

How to auto increment column options in databases

Auto Increment Column Value is Not Part of Transaction

by connect ashish yadav

Auto increment column value is not part of transaction

Automatic Missing Indexes Creation Statements

by GabrieleTronchin

Automatic creation of non clustered indexes using system SQL entities

Autosuggest TextBox from database column in Windows Forms

by Deepak_Sharma_

This article will show how to create an auto-suggest TextBox that will suggest data from a SQL Server database column.

Backdoor TFS User Image and Email Manipulation

by ergohack

Do you need to update everyone's TFS picture? Or set the notification email address for that calcitrant employee?

Backup Stored Procedures in SQL Server

by CorvetteGuru

Backup Stored Procedures in SQL Server.

Basic App to Insert the Contents of an XML File into a SQL Table with SQLBulkCopy

by MarcusCole6833

Making XML SQL .NET style!

Basic SQL Auto-Purging for Document Management

by Dan Steuer

This article will help manage automatic database purges according to basic Document Management principles.

Basic Troubleshooting for Microsoft SQL Table Lock

by NaibedyaKar

How to check the query locking the table and to unlock it

Be Very Careful When You Write SQL Trigger

by Mahmud Hasan

Be Very Careful When You Write SQL Trigger

Binding jqxGrid to SQL Database using ASP.NET Web Service ( Responsive & Right-to-Left & Farsi )

by Masoud Ehteshami (Iran)

main source : https://www.jqwidgets.com

Binding of Calendar Controls from Database

by SanSkun

How to bind holiday list and information about those holidays from database

Bitwise OR aggregate

by PIEBALDconsult

Performing a bitwise OR aggregate in SQL Server

Build a Calendar Without Pre-Existing Tables

by #realJSOP

Using common table expressions to build data from thin air.

Build a Date Function

by Rob Branaghan

Just a function to make populating a datetime variable easier!

Build a Date Function

by André Kraak

This is an alternative for "Build a Date Function"

Build Dynamic Order by Clause in LINQ Query in C#

by Ramesh Bevara

An overview of a helper class to build dynamic order by clause in LINQ query in C#

Build Your Own Movie Database with SQL Server

by Aless Alessio

Use the OLE Automation Procedures to retrieve data from a Web Service and parse the JSON response into a table format

Busy Production Database Update Without Timeout

by Prasannakumaran Sarasijanayanan

Load data to temporary table, make any additional update if required, create necessary indices, finally DROP live table and RENAME temporary table to production table.

Calculate aggregates for dynamic columns using UNPIVOT

by Wendelius

This tip describes how to calculate an aggregate for dynamically defined columns using UNPIVOT clause.

Calculate Geo Distance Using SQL Server

by Nirav Prabtani

How to calculate distance between two geolocations or find out distance within a specific radius by SQL Server

Calculating Average Processing Time in Hours Excluding Weekends

by Mohammed A. Mohiuddin

Calculating Average Processing Time in hours excluding weekends

Calling CL Programs on the IBM i on Power from PHP using DB2 Stored Procedures

by Nathan Stiles

Calling CL programs on the IBM i on Power from PHP using DB2 stored procedures.

CASCADE in SQL Server with Example

by vinothharshad

Use the ON DELETE CASCADE option if you want rows deleted in the child table when corresponding rows are deleted in the parent table.

Cascading Dropdown In ReactJS

by Sanwar ranwa

How to create a cascading dropdown using ReactJS and Web API

Case sensitive string comparison in SQL

by Neh.C

select * from table where and column COLLATE SQL_Latin1_General_CP1_CS_AS = 'G%E3%97O%D7'

Challenges in Data Migration Testing

by AgarwalPriyanka, ErGauravSharma

Challenges faced in data migration testing

Challenges in Migrating ASP.NET Apps to Containers #1 – Multiple Active Result Sets

by Mohammad Elsheimy

One of the major issues encountered when connecting to databases after porting ASP.NET app to Docker Linux containers.

Chat / Conversation Balloon Control with datasource

by IssaharNoam

Simple and customizable Chat Conversation control, with DataTable datasource, inspired by SMS application balloons in OnePlus One Android smartphone.

Check Digit Vertical and Horizontal

by Hernán Hegykozi

This tip explains how to calculate the Check Digit Vertical (CDV) and Horizontal (CDH) by SQL Server.

Check if a number is a power of 2 with Sql Server 2012

by Wendelius

This tip shows how to get rows from a table where a field contains a number that is a power of 2 using LOG function.

Check Network V1.0

by mohamedkamaleed

Network check v1.0

Checksum for Database

by Paulo Buchsbaum

A simple way to generate checksum for tables and databases.

Clear a DataRow Item (as opposed to deleting it)

by #realJSOP

One way to effectively zero the columns any DataRow object.

CLR Stored Procedure in SQL Server

by Jignesh G Trivedi

This tip will help you to understand CLR procedure.

CLR-addon for DATE and Split-String

by Levente Kupás

CLR-addon for T-SQL DATE transformation and Split-String

COALESCE and ISNULL in SQL Server

by Uppuluri Aditya

COALESCE VS ISNULL in SQL Server - Part1

COALESCE in SQL Server

by sandeepmittal11

COALESCE in SQL Server

Code Generator for SQL Server

by Homero Ibarra Ramírez

Tool on T-SQL to code basic generator for SQL Server

by Mycroft Holmes

Why do developers insist on separate procedures to do these jobs

by A.J.Wegierski

For Oracle: -------------------------------------------------------------------------------- -- DESCRIPTION -- Universal save -- PARAMETERS IN -- vTRYB: mode: (I)nsert/(D)elete/(U)pdate -- rc: record -- PROCEDURE zapiszObiekt(vTRYB IN...

by thatraja

DescriptionC...

Combining MDX with T-SQL in One Result Set for SSRS (Hybrid Query)

by Dnyanesh Wahiley

CREATE PROCEDURE sp_Insert ( @ID int, @Name char(20), @Mode char(20) ) ASif @Mode='Insert in Employee'Begin insert into Employee(Employee_ID,Employee_Name)values(@ID,@Name)Endelse if @Mode='Insert in Student'Begin insert into...

by Ahmad A.A. Ahmad

Combining MDX with T-SQL in One Result Set for SSRS (Hybrid Query)

Common Table Expression to find all related nodes

by Jobless Creature

CTE To find all the related nodes in a hierarcy

Compare Two Databases, Find Differences and Update using Visual Studio

by Rijwan Ansari

How to compare two databases using SQL Server Database Project (Template) available in VS.

Comparison Chart for Two Different Time Frames in SSRS

by Abu Zafor Khairuzzaman

Comparison Chart for Two Different Time Frames in SSRS

Computing First and Last Day of Current and Previous Month (SQL Server)

by Haroon Ashraf

A quick way to calculate first and last day of curent month and previous month

Concatenate rows with comma separated string

by Ravi Tuvar

Concatenate rows with comma separated string in SQL.

Concatenate many rows into a single text string using SQL Server 2008

by Ramanujam Shankar

Using COALESCE function - concatenate many rows into a single text string output in SQL Server.

Concatenate many rows into a single text string using SQL Server 2008

by e-Lopes

How to concatenate many rows into a single text string using SQL Server 2008.

Concatenate many rows into a single text string using SQL Server 2008

by Sanjay K. Gupta

How to concatenate many rows into a single text string using SQL Server 2008

Concatenate many rows into a single text string using SQL Server 2008

by PIEBALDconsult

See also Stupid CTE tricks -- string concatenation[^]

Concatenate two or more rows with comma (or any you want) in a single string

by Sunasara Imdadhusen

Concatenating Strings with a Custom SQL Aggregate Function

by Daniel Miller

This tip describes the code to create a custom SQL Server aggregate function that concatenates multiple string values into a single delimited value.

Concept mapping between SQL Server and Oracle

by SergioAmorim

SQL Server and Oracle terms may match, but they can have a very different meaning. This article will help you match one system to the other.

Connecting SQL Server 2012 Express from SharePoint 2013 Configuration Wizard

by Rakesh NITian

Connecting SQL Server 2012 Express from SharePoint 2013 Configuration Wizard

Connecting Windows Form Application With ADO.NET in C#

by Bikash Karmokar

Connecting Windows Form Application With ADO.NET in C#

Connection Error While Running Simple ETL Process With Excel using SSIS

by Bhawesh Tiwari

SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager failed with error code 0xC0209303.

Consistent Hash function for SQL Server and .NET

by Pascal Ganaye

Provides a couple of hash functions (string to int) that will return the same value in C# and T-SQL

Continuous Integration and Delivery for Beginners (DevOps)

by Thinira

Continuous Integration and Delivery with VSTS (Visual Studio Team Services)

Control Maximum Number of Rows in a Table

by Wendelius

How to prevent insert for record when maximum number of rows has been reached

Control Not Found in Namespace but App Compiles Fine

by #realJSOP

How to fix this ANNOYING problem

Convert a CSV delimited string to table column in SQL SERVER

by Kumar Pankaj Verma

How to convert a delimited string in SQL Server to a table column.

Convert column into rows without using pivot

by VINEET MISHRA 086

Convert column into rows without using pivot function in SQL

Convert Interval value to calender syntax while migrating DBMS_JOB to DBMS_SCHEDULER

by J Chandra Sekhar Achary

Useful piece of code which will convert the DBMS_JOB interval value to calendar syntax.

Convert RTF to Plain Text (Revised Again)

by NightWizzard

Handling for hex expressions and the trailing '}'

Converting comma separated data in a column to rows for selection

by OriginalGriff

If you have an SQL column which contains a comma separated list of names, you may have wondered how to return it as individual rows in a SELECT statement. It's not too bad, really!

Cool Insert Generator

by Ashkan.hosseini

Stored procedure that generates insert stored procedure for tables

Coping with DBNull

by Midi_Mick

A set of helper functions to cope with DBNull results from database queries

Copy paste complete Table SQL Server

by umairaslam22

Using a very simple query we can make replica of existing table along with full data and datatypes

Copy Table Schema and Data From One Database to Another Database in SQL Server

by Anoop Kr Sharma

How to copy table and its data in SQL Server using Query as well as graphically

Copy/Synchronize Table Data between databases

by Anurag Gandhi

A Query to copy an individual table data between databases

COUNT of DISTINCT Rows in SQL Server

by mravikiran

COUNT of DISTINCT Rows in SQL Server

by Vivek Johari

Nice tip :)But if you have any column say empid which have the unique constraint then it is better to use the following SQL queryselect count(distinct empid ) from employees

Count(*) or Count(1) vs Count(Column Name) in SQL Statement

by Pinakpani Dey

Count(*) or Count(1) vs Count(Column Name)

Counting All Rows of All Tables in a Database

by Antonio Soares

This tip shows three alternatives (an intuitive and less efficient, a more efficient one and a third more efficient one) to count all rows of all tables in a database.

Counting the number of occurrences of one string inside another in SQL

by Chris Maunder

I had a need to count the number of times a certain string appeared within a column in a SQL table. I came up with this simple function that may be of use to others

Counting the number of occurrences of one string inside another in SQL

by Chris Maunder

This is an alternate to my tip n trick article-ette. Times 2. Again!

Counting the number of occurrences of one string inside another in SQL

by Andrew Rissing

Using the pattern that Microsoft SQL Server Management Studio creates, it would be something along the lines of:IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[com_CountString]') AND type in (N'FN', N'IF', N'TF', N'FS', N'FT'))DROP FUNCTION...

Counting the number of occurrences of one string inside another in SQL

by phillipvoyle

CREATE FUNCTION [dbo].[com_CountString](@Input nVarChar(max), @SearchString nVarChar(1000))RETURNS INTBEGIN if @Input is null or @SearchString is null return 0 DECLARE @InputLength INT, @SearchLength INT SELECT...

Create & Populate Time Dimension with 24 Hour+ Values

by Mubin M. Shaikh

Create time dimension with 24 hour plus values and time buckets in your data warehouse

Create .NET MVC Web Application using Visual Studio on Mac OS [Part 2]

by Uladzislau Baryshchyk

Application that can be used to work with subd and connecting Amazon RDS to the project

Create Calendar by T-SQL

by grandtree

Create a calendar by inputting month

Create Clone Schema in postgre

by Praveen_Kumar Gupta

Clone Existing DB Schema to New Schema by plpgsql in PostgreSQL

Create CRUD Stored Procedures Without Writing One Line Code

by mitchellguzman

Create your common Insert, Delete, Update and Select stored procedures on a single table

Create CSV File in Microsoft SQL

by Rajesh_K_Sharma

How to create CSV file in SQL

Create Insert SQL Statement from the Records in an Existing Table

by markkang

This tip describes how to generate insert SQL statement from the records in an existing table in SQL server database

Create New Jobs In SQL 2012

by apachearun

How to create new jobs in SQL 2012

Create Query Shortcuts in SQL Server Management Studio

by saddam_msp

Shortcuts to execute your query faster while working or debugging T-SQL statement

Create SQL Contained Database Users using EntityFramework Code First

by Islam Refaei

How to create contained DB users to be used among your application

Create SQL Job for SSIS Package by using C#

by Sandeep Kumar Tripathi

How to create SQL Server Agent Job to schedule SSIS Package

Create Table and Stored Procedure in SQL Server and connect it from ASP.NET using C#

by Prakash Lekhak

We will create a Table and Stored Procedure in Sql Server 2008R2 and data will be inserted and retrieved by using Asp.net using C#

Create Table SQLite and MariaDB (Mysql) from JSON Object using PHP PDO.

by Member 4206974

A PHP class that uses PDO for creating a table from JSON Objects

Create Your Own Web Panel For Your Application

by Rogai Lorenzo

How to create a web panel for your application.

Create, Run, Debug and Deploy SQL CLR Function with Visual Studio 2013 Database Project

by Sunil_Pawar

Learn how quickly you can Create, Run, Debug and Deploy SQL CLR function using integrated features of Visual Studio 2013.

Creating a Database Driven Auto Complete TextBox Using jQuery for ASP.NET Websites

by AshishChaudha

This tip talks about creating an auto complete textbox using jQuery.

Creating a SQL Server Database Programmatically

by Roger Wright

A simple example of creating a new database on a SQl Server instance

Creating a SSRS Report With Microsoft Dynamics CRM On-line

by coded007

Designing reports with Dynamics CRM

Creating a Windows Azure SQL Database

by Malak Zia Nasir

Cloud computing is the trend of nowadays; this article provides some basic steps to create and connect a Windows Azure SQL Database to a simple application.

Creating and Usage of View in SQL

by Poonamchand Soni

A view is virtual, the data from a view is not stored physically. It is a set of queries that, when applied to one or more tables, is stored in the database as an object. A view encapsulates the name of the table. A virtual table contains column and data from multiple tables.

Creating Dynamic Grid-view Worked Like Excel Sheet

by Rojalin Sahoo

Creating dynamic grid-view worked like an Excel sheet

CRM to CRM Leads Qualification by Aggregated Leads Indicator Using Office 365 and Microsoft CRM Online

by CRMcoaching

In this article I will demonstrate an advanced topic that can improve bussiness processes that start in one CRM and continue in another CRM.

Cross check your DBML file for any invalid stored procedure or function in it

by B.Panchal

CRUD in ASP.NET MVC 4 with KnockOut.JS

by Indresh_Prajapati

This tip will help beginners to implement CRUD operations in ASP.NET MVC 4 with scripting language as KnockOut and Database as MS SQL 2008R2.

CRUD in ASP.NET MVC 5 using WebAPI 2 with AngularJS

by Indresh_Prajapati

This tip will help beginners to implement CRUD operations in ASP.NET MVC 5 using WebAPI 2 with scripting language as AngularJS and Database as MS SQL 2008R2.

CRUD operation with Entity Framework 6 Database First using MVC 5

by TalentTuner

In this article, I’ll describe how to perform basic CRUD operations in an MVC5 application.

CTE Query in SQL Server

by Nirav Prabtani

CTE Query for optimizing complexity of query in sql server

Cursors Vs. Sets

by Sums Mohs Eds

A brief discussion of when to use cursors and when to use sets.

Custom Control for Effective Paging and Page Navigation for GridView with Full Source

by Sreedhar Puligundla

Creating custom control for gridview paging and page navigation

Custom Paging using Ajax

by HardikPatel.SE

Paging using AJAX

Custom Paging using AJAX with Sorting

by HardikPatel.SE

Paging and Sorting with AJAX

CYYMMDD (Integer) to DATE in DB2 for iSeries

by davidshenba

Conversion of 7 digit integer date format to SQL date format

Dapper.NET Sample with MVC 4- Add,Edit,Update,Delete

by Gihan Liyanage

Simple Dapper.NET Example with MVC

Data Services - Best practices in Business Intelligence Development: SSIS, T-SQL

by Bertin @nonodata.com

It is often important to have general guidelines when putting together a Data Analysts Team.

Database Driven Dynamic Menu Control

by Yugal Pandya

Database driven N-Level Dynamic Menu Control using C#.NET and SQL Server with stylesheet CSS

Database Driven Dynamic Menu Control

by Muhammad Ahmed Azam

"Database Driven Dynamic Menu Control"

Database Object Model

by databaseobjectmodel

A Sample ORM project

DataGridView: Make Enter Key Move to Next Column

by Jαved

DataGridView: Make Enter Key Move to Next Column

DataSet to T-SQL Script

by Brad Joss

Export a System.Data.DataTable/DataSet into a T-SQL script that when run creates a #TEMP table of the same definition filled with data.

Date & Day Name of Current Month in SQL Server Stored Procedure

by Biswa Bhusan Dash

SQL Server Stored Procedure

DB Independent Code using Wrappers

by Amol M Vaidya

A simple Data Connection Library to avoid rewriting code when the DB changes

DBMS Models

by Sonali Agarwal

There are different types of Database Management System models used for organizing the logical data. Relational model is most popular and widely used model in DBMS.

Debug ASP.NET MVC Application with Glimpse

by Muhammad Hassan Tariq

Glimpse Extension for server side debugging and diagnostic information of ASP.NET applications

Default Dimension Members Generator (T-SQL)

by Miljan Radovic

T-SQL script which generates and executes INSERT statements for missing default dimension members (Unknown, Not Available, Not Applicable)

Delete All Rows in a Table in Entity Framework

by DiponRoy

Delete all the records from the table using EF

Delete Duplicate Rows in SQL Server

by Arkadeep De

How to remove duplicate records using CTE in SQL

Deleting Multiple Rows in GridView in ASP.NET

by sourabhdev14

The GridView control in ASP.NET is used to represent information from a database in tabular format.

Designing Business Intelligence Reporting & Dashboards with Tableau Desktop using Microsoft Dynamics

by Venkat Chaitanya Kanumukula

Tableau is one of the powerful reporting tool which is on the market for over a decade. Here's a quick tour in designing BI reports with Tableau using Microsoft Dynamics AX 2012 R3/ Microsoft Dynamics 365 Finance and Operations.

Detects Differences Between Databases

by GabrieleTronchin

Compare two databases to detect which object has been modified from an old version of the same database.

Determine Column Name

by Corporal Agarn

Using imported tables that may have a different column name to determine what it is.

Difference between CROSS APPLY and OUTER APPLY of SQL XML

by jsd24

The difference between CROSS APPLY and OUTER APPLY of SQL XML

Difference Between Two datetime Values in Hours, Minutes, etc.

by Wendelius

This tip shows how to calculate a difference between two datetime values and to express the difference in years, days, hours, minutes and so on.

Display number or amount with commas but no decimal places or extension displayed

by Silver Lightning

Display number or amount with commas but no decimal places or extension displayed

Displaying a Bar Chart using SELECT command in Oracle

by Azim Zahir

This tip demonstrates using the Select command to display a bar chart.

Documenting SQL Stored Procs in C# Code

by #realJSOP

Yes, you CAN document your stored procs in C# code.

Does 'GROUP BY' Confuse - SQL ?

by Shyam S Singh

This is a simple tip to describe the GROUP BY clause and when we use this in our SQL statements with and without using HAVING clause.

Download SQL Server Sample Databases including SQL Server 2012

by Dhananjay Kumar Upadhyay

Download SQL Server Sample Databases including SQL Server 2012

Drop all Triggers belonging to any schema in MS SQL Server

by Matthew Taylor

How to remove Microsoft SQL Server triggers associated with a custom schema.

Dutch postalcode Database with geolocations from BAG

by rafaelpb

Generate a postalcode database for lookups from dutch national data BAG

Dynamic Menu type Control Panel from DataBase

by Roysb

Creating a menu dynamically from a database, with a style type control panel

Dynamic ORDER BY with multiple criteria in T-SQL

by Bob Crowley

How to use a CASE statement in ORDER BY to avoid dynamic SQL

Dynamic Pagination

by RahulAJoshi

Dynamic paging in grids

Dynamic Pivot Query in SQL Server

by Chetan Naithani

Transforming dynamic row-level data into columns

Dynamic Query and Incorrect Syntax Near 'GO' Error

by Moheeb U.

Here, I have tried to figure out some basic concept about dynamic query.

Dynamic Restore SQL Server

by Member 10262330

Dynamic restore SQL Server

Dynamic SQL From DB Table with Parameters

by Johnny L Washington

How to execute store SQL with parameters via Procedure

Dynamically create a Stored Procedure to add a column when it does not exist

by Takso

Dynamically create a Stored Procedure to add a column when it does not exist.

Dynamically Creating an RDLC Report Just Using a DataSet

by Nadir Muhammed

Creating an RDLC report by just binding a Dataset

Easy Database Table Change History

by Johnny L Washington

Capture data changes in history table

Effective Procedure for Updating Table Primary Key Values

by Tore Olav Kristiansen

If you need to change values of db table primary keys during ordinary operations, you probably have a design flaw in your software. In extraordinary situations, it may however be necessary. This tip helps you do so.

by Robby Tendean

How to create an efficient paging using SQL script

by NeoPunk

Hi, what about such solution?DECLARE @pageNumber INTDECLARE @rowsOnPage INTSET @rowsOnPage=5SET @pageNumber=2DECLARE @totalItemsToSelect INTSET @totalItemsToSelect=@rowsOnPage * @pageNumberSELECT TOP (@rowsOnPage) * FROM MainTrans WHERE ID IN( SELECT TOP...

by jeantoledo

Take a look at this:DECLARE @ActualRow = 1; /*Start in first item*/DECLARE @ItensCount = 100; /*100 itens for page*/DECLARE @Page = 1; /*Start in first page*/SELECT * FROM(SELECT *, ROWNUMBER() OVER(ORDER BY Name) as ROWNUM FROM Users) as UsWHERE ROWNUM BETWEEN...

Encode / Decode n-bit Integers into byte[]

by kamiktk123

string Query = string.Format(@"SELECT * FROM (SELECT *, " + @"ROW_NUMBER() OVER(ORDER BY PRODUCT_ID DESC ) AS ROW_NUM FROM({0}) " + @"AS TEMP_INNER) AS TEMP_OUTER WHERE ROW_NUM BETWEEN '{1}' AND " + @"({2} + {3}) - 1", strSql, startRowIndex, startRowIndex, maximumRows);

by mhano

The class allows you to encode / decode 4, 9 or 17 bit (for example, 1 through 31 bit unsigned int supported) integers to and from a byte[].

Encrypt and Decrypt password through SQL query

by atul123321

How to Encrypt And Decrypt a field without writing any frontent code .

Encrypting the passowrd of a connection string in App.config

by Enver Buzoku

Shows how to encrypt only the passowrd of an MS SQL connection string in the App.config of a .NET application.

Enterprise Library 5.0 Logging. Add Support to Log Properies to the Database using a Custom Trace Listener

by aroen kandaswamy

Custom database trace listener that supports logging of properties for enterprise library 5.0

Entity and Mapping Class Generator for EF

by Daniel Miller

This tip provides a simple solution to automate the generation of entity and mapping classes for Entity Framework.

Entity Framework Code First Migrations Alternative

by DiponRoy

How to handle database scheme changes with normal SQL scripts, without migration in Entity Framework code first

Entity Framework on MySQL with nHydrate

by Christopher R Davis

Use model driven development with a MySql backend

Equivalent function of mysql_real_escape_string() in C#

by Member 3783976

Implement function in C# to emulate functionality of mysql_real_escape_string() C API function.

Escaping the IF..THEN Hell in C# with SQL

by David De Leeuw 2021

Refactoring a complicated procedural program, using SQL, Dapper, simple objects, lambda etc.

EXCEPT & INTERSECT command in SQL Server

by Ramanujam Shankar

New Commands in SQL Server Ex: EXCEPT & INTERSECT

Excluding HTML tags from query

by crazie.coder

Sql query for remove html tag from sql table field

Execute an SSIS Package Through SQL Stored Procedure

by Bert O Neill

Execute SSIS Package in C# or SQL Sproc

Executing A Stored Procedure From Excel Sheet

by Mohd Manzoor Ahmed

How to execute a stored procedure from Excel Sheet

Expandable Table like Gridview

by Nirav Prabtani

Virtual Expandable Gridview using Ajax post method

Experimenting with Date and Time data types in SQL SERVER 2008

by John C Rayan

An insight into date and time types in SQL SERVER -

Exploring Further - Date and Time Data Types (SQL Server)

by Haroon Ashraf

Things worth considering when using SQL Date and Time data types

Export data from SQL Server as XML

by seankk

Extending DATEADD Function to Skip Weekend Days

by Emiliano Musso

A quick method to add days to a date, skipping weekend days if the number of days added results in a Saturday/Sunday

Extract Image Files from Database Image Data

by PallavSingh

Converting data column (contains OLE db image binary Format) to image file (.jpg)

Extracting the filename from a full path in SQL Server

by OriginalGriff

Sometimes, you want to extract the filename (with or without the extension) from the full path of a file. It's easy in C# and so forth - just use the Path.GetFileName method. But what if you want it in SQL?

Fast and Simple IDataReader Implementation to Read CSV Files

by shijo joseph

A simple and fast CSV reader which you can directly use against Oracle and SQL Server databases or for any direct implementation

Fast way to deal with foreign keys

by Alexander Konstantinov

Two stored procedures helping developers do less things when they create tables and indeces

Fastest way to find row count of all tables in SQL

by Mihir.D.Shah

Simple Queries to find row count of all tables in a MS-SQL Database

Fetching Data from a Specific Week Relative to a Date in SQL

by OriginalGriff

How do you get last weeks data only? It's a little more complex than you might have thought

Fibonacci sequence in Oracle using sinqle SQL statement

by Wendelius

This tip shows two ways of generating Fibonacci numbers in a single SQL statement

Fibonacci sequence using SQL Server CTE

by Wendelius

Generate Fibonacci numbers using CTE

Fill factor in SQL server.

by Jitendra Ku. Sahoo

In this article we will discuss about fill factor and its effect on query performance.

Find All the Days Between Two Dates

by S.P.Tiwari

Find all the days between two dates using SQL Server

Find and Fix Fragmented Indexes

by Duncan Edwards Jones

Quick tip to allow you to identify indexes that could do with defragmentation

Find Duplicates with Exact Spell and Verbally Same

by Hiren solanki

Retrieve full duplicate rows with some of column value having duplication

Find Missing Date Ranges in SQL Server

by Ramanujam Shankar

Find missing date periods from a table.

Find progress of a database restore using sys.dm_exec_requests

by Liju Sankar

Find progress of a database restore using sys.dm_exec_requests

Find Sp from database which is related to(using) table XXX

by Pranay Rana

Problem : - During project development I got the requirement that I have to modified the column name of the table which is used in the no of procedure i.e i have to found all procedure related to that table and modify it For the above problem following are the solution that i used First ...

Find text in Stored Procedures, View, Trigger, and Function

by Nelson Kosta Souto

Find text in Stored Procedures, View, Trigger, and Function.

Finding the Lowest Common Ancestor in a tree

by Jörgen Andersson

How to find the Lowest Common Ancestor in a tree.

First and Last Occurrence of Day of Week Within a Month using SQL

by Wendelius

This tip describes how to fetch the first or the last occurrence of given day of week within a month by using a single SQL statement.

Fix SQL Server DTC Errors on Duplicated Hyper-V VMs

by Zhuyun Dai

Fix multiple SQL Server DTC errors when we use distributed transactions between VMs duplicated from the same template on Hyper-V

Foreach File Enumerator in SSIS

by Sreekanth Mohan

Foreach file enumerator in SSIS

Forename-Title Profiling

by byapparov

Introduction...

Forgot Password With Check Email From Database

by Muhammad Aqib Shehzad

Forgot Password and Email Check from Database

Format a number (with commas) in SQL

by Chris Maunder

A small function to format numeric values

Formatting child table rows as a list in a single column cell

by Jovan Popovic(MSFT)

This SQL example shows how you can return parent row all child rows as a single cell.

Formatting Local Datetime to UTC in SQL Server

by Ani_0707

This article intends to describe a simple and elegant way of converting local datetime to UTC and store it in DB.

Four Pitfalls of SQL Processing with NULL Values

by Tomas@PawSQL

How to cope with all scenarios regarding NULL value handling in your daily work

Freehand Drawing using Google Map and Spatial Search

by Pablo A Martinez

How to use Google map and Spatial search to do freehand drawing

Freeing Locks on an Oracle Database

by jonyj

Queries and commands to discover what's locking the database

Function to execute SQL script via Sql *Plus from VBA

by byapparov

Introduction...

Fuzzy lib with GUI using mvvm light and OxyPlot

by Søren Gullach

Fuzzy lib that have a GUI and uses Lagrange for member curve generating

General rules on selecting Data Types of SQL Server

by Ahmed Naqibul Arefin

Generate Data Dictionary from SQL Server

by Johirul Islam Tarun

Easily find table description.

Generate Insert Scripts of Existing Rows with "if Exists" Conditions

by Chetan Naithani

Stored Procedure to Generate Insert Scripts

Generate SPA Web App Instantly in Minutes

by Kalvin Lawrence Ernst

Generate a web app instantly, directly from a database(SQL Server)

Generate SQL Script to Set Simple Recovery Model and Shrink Databases

by Tore Olav Kristiansen

When you create a new SQL Server database, the default recovery model is Full. This model takes up a lot of disk space. It is ordinarily not necessary for developer images. This tip has a SQL script that helps you change this.

Generate XML in ASP.NET MVC5 and AngularJs using Database Value

by Md._Mehedi_Hasan

This tip will help you to generate .xml file in AngularJs and ASP.NET MVC5 using XElement of C#.

Generate XML Using FOR XML

by Harsh Gandhi

Generate XML Using FOR XML ; Difference between different modes (AUTO, RAW, PATH, EXPLICIT) of FOR XML to generate XML in SQL Server

Generating a Sequence in SQL

by Manas Bhardwaj, CHill60

Generating a sequence in SQL

Generating a set of random numbers in SQL Server

by Wendelius

Generate a set of random numbers by using CTE

Generating and Splitting a Delimited String Column

by Tharaka MTR

This article describes the easiest way to create and process delimited row using SQL XQuery.

Generating desired amount of rows in Oracle using single statement

by Wendelius

Two ways of generating desired amount of rows in Oracle by using a single SQL statement.

Generating Desired Amount of Rows in SQL using CTE

by Wendelius

How to generate desired amount of rows in SQL Server using CTE

Generating HTML Reports for Dynamic Table Structures

by Sergii Syrovatchenko

This tip describes the most convenient way of process automation of generating HTML reports for dynamic table-structures and sending them to different people.

Generating Random Int SQL Values between Upper and Lower Limits

by jamuro77

This SQL mini-article is about generating random int values between upper and lower limits, in particular, to load data into demo database.

Generation of Dynamic Parameterised Report with DropDown List using SSRS

by Purushotham Agaraharam

Creating a parameterised report using SSRS.

Generic DropDown Control Using LINQ to SQL and Entities using Reflection

by murtaza dhari

A generic dropdown control using LINQ to SQL and Entities using Reflection

Generic Insert for Dapper

by Jakob Lithner

Dapper offers fast database handling with custom SQL strings. This wrapper simplifies life by taking generic POCO objects and creates necessary SQL strings on the fly, and it is still very fast!

Get a Customized Table Structure With Non Null Fields Using Dynamic SQL

by Jesus Carroll

In Data Engineering, supporting Data Science, Data Mining and Reporting tasks, it is useful to get only fields that have data. We don't mind nulls values and we are grateful if this field's structure is dynamic. These ones might be a stat in the set of empty's kingdom.

Get an Accurate Age by Date

by Alaric Dailey

This would work too :)As an explanation, I use datediff to get the number of days, divide that by the correct number of days in a year (keeping track of leap years, there are only 97 in every 400 years) and then FLOOR the result, thus making sure it doesn't get rounded up accidentally....

Get Client IP Address in SQL Server

by Sarvesh Kumar Gupta

How to get the client IP address in SQL Server

Get Column values as comma seperated string

by Manas Bhardwaj

Ever wondered that how to get a comma (pipe or whatever) seperated result for a column in a table.The following statement show a simple example you can take as a starting point.Select (Stuff((Select ', ' + FName From Accounts FOR XML PATH('')),1,2,''))

Get Column values as comma seperated string

by Elina Blank

Another option:declare @commaStringList varchar(max)set @commaStringList = ''select @commaStringList = @commaStringList + ', ' + CAST(ColumnName as VARCHAR) from MyTable -- remove leading commentif len(@commaStringList) > 3 set @commaStringList =...

Get given string instance from SQL database

by That's Aragon

This is a SQL query to search particular string instance from SQL database.

Get Only DateTime Part without using Convert

by RaviRanjanKr

This tip will enable you to get DateTime Part in SQL without using Convert

Get Table Column Value as Comma Separated Value (CSV) in SQL

by Arslan Elahi

Get the Comma Separated Value of one or multiple columns from SQL table

Get Tables List With Its Dependent Tables Names

by Dhol Gaurav

Get Tables List With Its Dependent Tables Names

Get the last working day of the month

by Mycroft Holmes

Gets the last week day of the month

Get time difference in the format "HH:MM:SS" for two different DateTime values in SQL Server

by shivaramakrishnaReddy

Get time difference in the format "HH:MM:SS" for two different DateTime values in SQL Server.

Get Top X rows from a table

by Mahmud Hasan

How to use variable in SELECT TOP SQL command

Glimpse Part 1 - Easy Debugging ASP.NET MVC Application

by Rakhi Shrivastava

This tip explains the step by step approach how we can use Glimpse for easy debugging of the ASP.NET MVC application.

GoFlex Repair And Snooping Around

by marcus obrien

Fix your goflex media server files and have poke around on the device.

Grouping dynamically on different columns in single query

by RahulAJoshi

Grouping dynamically on different columns in single query

Hierarchical Query in Database

by Shamim Uddin

We will learn about hierarchical query in database with real example.

How to add an identity column to a table with data?

by Sudheer Reddy Battula

Add an identity column to a table with data

How to Assign Value to Parameters Used in Query which is Stored in a Variable

by shankeyshankey

How to Attach object to a different data context

by Dev_2580

For the last couple of days, working on my project for my studies I have struggled with this annoying issue regarding LINQ to SQL classes.When we update an entity within a DataContext, we can simple use something likecontext.Entity.Attach(updatedEntityInstance)The proplem is that...

How to backup multiple databases using Perl

by Carlos Luis Rojas Aragonés

How to backup multiple databases using Perl

How to Calculate the Check Digit on a Columbia Gas Account Number

by cattman1970

Function that consumes a Columbia Gas account number of 11+ digits and returns the check digit

How to Calculate the Length of the Largest Text Value in Every Table Column

by Daniel Miller

This tip shows how to display the length of the longest string value in every table and column in your database.

How to Cascade Delete an Adjacency List Model in SQL in C#

by marks-mike

Demonstrates how to cascade delete on a single table that maintains hierarchy by a ParentId that points to the primary key of the same table

How to Check Opened Connection in SQL Server

by Najmul Hoda

Here is the code snippet to check how many database connections are opened in SQL Server.

How to Compare Database Schema in VS 2012, How to Update the Target Database to the Server

by Syed Moula Ali

How to compare database schema in VS 2012 and how to update the target database to the server

How to connect / access remote SQL Server 2005 database via CC Proxy

by kiran dangar

How to connect / access remote SQL Server 2005 database via CC Proxy

How to connect to Analysis Services (SSAS) from a different domain user

by kasiarun

How to connect to Analysis Services (SSAS) from a different domain user

How to Convert a text Value into a date in Oracle SQL

by Database Star

Explanation and demonstration of some Oracle SQL functions to convert text to dates

How to Copy a SQL Server Table?

by Sudheer Reddy Battula

Copy a SQL Server table

How to Copy SQL Table Into Excel and Other Formats

by apachearun

How to copy SQL table into Excel and other formats

How to Count All Tables, Rows, and Rows Per Table

by Daniel Miller

This code snippet shows how to count all the tables and rows in a SQL Server database

How to Create and Use a Self-referencing Hierarchical Table

by E. Scott McFadden

This article explains how to create and use a self referencing key in a SQL Server Table.

How to create Aspnetdb database

by Kamyar

This tip describes a shorter way to create the aspnetdb schema on your database instead of using aspnet_regsql command

How to Create SQL Server Database Project With Visual Studio

by Rijwan Ansari

Learn about SQL Server Database Project (Template) available in VS

How to do a "LastIndexOf" in sql

by Elina Blank

sometimes we need last occurance of the character in the string

How to drop dependency constrations in Oracle for all tables

by Slava Khristich

BackgroundI had to write a script to do some tables alternation and datamodification. I run into the problems where I had disable existingconstraints and re enable them at the end of the process. I wassearching the web for automated script to do that but whatever I foundwas not exactly w

How to empty SQL Server 2005 database using cursor & sys.objects (Deleting All Tables, stored procedures, views & UDF’s)

by kiran dangar

Understrading sys.objectsSys.objects is a system VIEW in SQL Server 2005, for each SQL database there is a separate sys.object view which gets stored within databse itself.Using Sys.objects returns list of all database objects and its types, type can be either of given below:DB OBJECT...

How to empty SQL Server 2005 database using cursor & sys.objects (Deleting All Tables, stored procedures, views & UDF’s)

by VDmitrovsky

1) You cann't drop any object in schemas other than dbo, so you MUST use sys.schemas system view properly.2) You cann't drop tables even in dbo schema if they are referenced by other ones, not dropped so far. Drop all FKs before tables.dva

How to empty SQL Server 2005 database using cursor & sys.objects (Deleting All Tables, stored procedures, views & UDF’s)

by kiran dangar

For Ravi LVS,The way you have suggested to Empty the database by just deleting and recreating it, is not at all smarter way when you are about to empty a remote database located on live database server, There are times when you don't hold such rights of deleting database on Live...

How to Establish Dedicated Admin Connection (DAC) to SQL Server

by Wendelius

Few tips for connecting to an SQL Server instance using DAC

How to fetch data from the previous or next rows in the resultset

by Wendelius

This tip demonstrates the use of LAG and LEAD functions in SQL Server.

How to Fetch Data from the Previous or Next Rows in the Resultset

by Wendelius

This tip demonstrates the use of LAG and LEAD functions in Oracle.

How to find a specific string from stored procedures, triggers and functions in database

by RasikaLB

You can find queries to find a specific string from MSSQL Server

How to find a specific string from stored procedures, triggers and functions in database

by jim lahey

Please see my alternative tip #2:Do the same thing with SMO[^]There's a Microsoft API for all this, it's been around for a while.

How to find a specific string from stored procedures, triggers and functions in database

by Member 2077086

Simply add your search phrase and run to find jobs, Stored Procedures, Keys, Tables, Views, Indexes, Defaults, and Functions.set nocount on declare @Keyword as varchar(200)set @Keyword = 'Search prase'--<---- enter keyword here--Search jobsselect name Job, enabled , description, ...

How to Find Character Repeated in a String Few Times using CTE?

by Maciej Los

This tip shows how to use CTE to find character repeated in a string few times.

How to find column or text in entire stored procedure of a database?

by Rajat-Indiandotnet

Find column or Text in entire stored procedure

How to Find Various Day, Current Week, Two Week, Month, Quarter, Half Year and Year in SQL Server

by KISHANHR

Describes how to find various days, current week, two week, month, quarter, half year, and year in SQL Server which are required in most applications.

How to fix "LocalDB - Requested Login failed"

by Ed Nutting

How to fix LocalDB / SQL Server: "Cannot open database "XYZ" requested by the login. The login failed. Login failed for user ABC"

How to Format Repeating Values in SQL Result Set

by Wendelius

A little tip on how to format repeating values in SQL output using LAG function

How to Generate T-SQL Code by Using Dynamic SQL?

by Sergii Syrovatchenko

T-SQL code generation by using Dynamic SQL for routine tasks automation.

How to get an empty GUID in SQL Server

by nit_singh

A method of comparing with an empty GUID

How to Get on Track with Active Directory

by Alex_2979

How to get on track with Active Directory

How to Get Words Separated in a String Concatenated by Delimiter

by Ankur .K. Vishwakarma

This tip shows you a T/SQL function to split a string concatenated by a delimiter.

How to Guarantee a Fixed Amount of Rows in a Table

by Wendelius

This tip describes how to guarantee a fixed amount of rows in a table by using triggers

How to Guarantee a Fixed Amount of Rows in a Table in Oracle

by Wendelius

This tip describes how to guarantee a fixed amount of rows in a table by using triggers in Oracle.

How to Implement Contact Us Page in ASP.NET MVC (ASP.NET 5 )

by Bipin Paul

Implementation of Contact Us Page using ASP.NET MVC pattern

How to Implement GROUP_CONCAT in SQL SERVER

by Wagner NULL

This tip aims to demonstrate in a simple way how to implement MySQL GROUP_CONCAT function in SQL SERVER.

How to Improve Performance of Query

by Arora_Ankit

This tip will provide you with an idea about basic things that you can use to get better performance from query.

How To Migrate ASP.NET Users From Membership To Identity Provider

by congiuluc

In this article I explain step by step how to migrate users from ASP.NET Membership to ASP.NET Identity

How to prevent SQL Injection in Stored Procedures

by Shao Voon Wong

How to prevent SQL injection attacks when using dynamic SQL in stored procedures

How to Protect from SQL Injection in PhP based website

by chetan dudhagara

How to Protect from SQL Injection in PhP based website

How to Publish ASP.NETCore MVC Web Application to IIS in Less Than 5 Minutes

by O.Nasri

A good tutorial in how you can publish your ASP.NETCore MVC web application to IIS.

How to Query Comma Separated Value Column in SQL

by Karthik_Mahalingam

How to query comma separated value column in SQL

How to remove duplicate rows in SQL Server 2005 when no key is present

by Wendelius

This tip describes how to delete duplicate rows from a table that doesn't have a key.

How to remove duplicate rows in SQL Server 2005 when no key is present

by Costica U

Here is another solution:IF OBJECT_ID( 'tempdb..#TestTable' ) IS NOT NULL BEGIN DROP TABLE #TestTable ENDCREATE TABLE #TestTable ( Column1 varchar(1), Column2 int )INSERT INTO #TestTable VALUES ('A', 1);INSERT INTO #TestTable VALUES ('A', 1); --...

How to remove duplicate rows in SQL Server 2008 when no key is present

by Wendelius

This tip describes how to delete duplicate rows from a table that doesn't have a key.

How to remove duplicate rows in SQL Server 2008 when no key is present

by Ron sikander

Find out the number of duplicates in the table:select count(*), VISTX_ST_FIPS,VISTX_CTY_FIPS,VISTX_TC from TR00.NV_STARTER_INDEXgroup by VISTX_ST_FIPS,VISTX_CTY_FIPS,VISTX_TC having count(*)>1--- Delele them using following statementDELETEFROM TR00.NV_STARTER_INDEXWHERE...

How to rename the column on a DB

by Pavel Yermalovich

That isn't complicated task but i thought this trick is enough usefullSP_RENAME 'YourTable.OldColumnName','NewColumnName','COLUMN'

How to Reset Identity Column Value In SQL Server without Delete Records.

by Abdul Quader Mamun

You have deleted some records from different record position from your identity column table and you wan to reset it without delete records.

How to Reset Identity Column Value In SQL Server without Delete Records.

by Eskern

Some considerations:- Use a table variable instead of #tempTable. Temporary tables create an actual table in the temp database, that needs to be dropped afterwards. When something bad happens, the table will not be dropped.- Use a FAST_FORWARD cursor, when it is read-only. For large tables,...

How to Resolve the "Not a Valid Month" Error with Oracle TO_DATE

by Database Star

The "ORA-01843: not a valid month" error is quite common for Oracle SQL developers, and can be fixed in a few ways.

How to Retrieve Dynamic XML Data from T-SQL

by Bhushan W. Juare

The different ways of retrieving XML data from SQL Server.

How to search between two dates and get all records

by SA - Hibbert

Return all records between two dates that include time in SQL.

How To Select Record Based on Row Number

by Abhishek Sur

It is a common issue of many of the guys on how we can fetch a record based on its record number. It is really easy to get first 10 records usingSELECT TOP 10 * FROM EMPBut when we want to fetch records in such a way say I need to fetch record from 40 to 50. This comes very handy when...

How to set an alternate row color in SSRS 2005

by Ahmed_Said

How to setup database versioning tool RoundhousE

by Rohan Kishor Garud

RoundhousE (RH) is a database migrations engine that uses plain old SQL Scripts to transition a database from one version to another.

How to Shrink SQL Server database files?

by thatraja

How to Shrink SQL Server database files?

How to Shrink SQL Server database log files?

by thatraja

How to Shrink SQL Server database log files?

by Huisheng Chen

DUMP TRANSACTION FooDB WITH NO_LOGBACKUP LOG FooDB WITH NO_LOGDBCC SHRINKDATABASE(FooDB)EXEC sp_dboption 'FooDB', 'autoshrink', 'TRUE'

How to Split Column in T-SQL

by Bhushan W. Juare

This tip shows how to split a column in T-SQL.

How to Tell Which Way a One-to-Many Relationship Should Go

by Database Star

This article explains how to tell if a relationship in a database should be many-to-one or one-to-many.

How to Transfer a MySQL Database between Two Servers using SCP

by Renz Ladroma

A guide to transfer your MySQL databases between two servers using the SCP method

How to truncate log file in SQL Server 2008

by Kumar Pankaj Verma

Truncating log file in SQL Server using T-SQL when log file is too large and database becomes unresponsive.

How to update a row with another row if column values are null in SQL

by ManojKumar19

Update row column with another row column in same table SQL only if it is null.

How to Use a Stored Procedure Inside an SQL Query

by OriginalGriff

How do you call a Stored Procedure inside a query and use the SELECT results? Tricky...or is it?

How to Use Ajax.BeginForm

by Veronica S. Zotali

The tip aims to demonstrate the usage of Ajax.BeginForm

How to Use COALESCE with Different Data Types

by Database Star

Use the COALESCE function with different data types correctly

How to Use Cross Apply Instead of Cursors in SQL Server

by Venkat Krishna Turlapati

How to use cross apply along with a table valued function as an alternative to cursors

How to Use Office365 Email with SQL Server 2000

by MAW74656

This is a drop-in solution that mimicks the functionality of xp_sendmail (including query results), without installing Outlook on the server.

How To Use Oracle's TRIM, LTRIM and RTRIM Functions

by Database Star

How to use these three functions and what the differences are between them

How To Use SQLCMD Utility in SQL Server 2008?

by Bhushan W. Juare

This tip shows how to use SQLCMD utility in SQL Server 2008.

How to use Update query with table variables

by Praveen Meghwal

Things to remember while using Update query with Table variable

How to: Get Data from Multiple Workbooks using One OleDbConnection?

by Maciej Los

This tip shows how to get data from multiple workbooks using one OledbConnection.

Identifying and Deleting Duplicate Records from SQL Server Table

by Aqeeel

Identifying and deleting duplicate records from SQL Server Table

Implement Split A/B pages in your ASP NET project

by TheCardProject.co.uk

Quickly set up the ability to serve up several pages and record which was served in SQL Server

Import a Flat file with Header and Detail Rows in SSIS

by sandeepmittal11

Import a Flat file with Header and Detail Rows in SSIS

Import a MS SQL Database to Amazon RDS

by Uladzislau Baryshchyk

In this article, I'll show you how easy it is to move your MS SQL database to Amazon RDS cloud

Import CSV or txt File Into SQL Server Using Bulk Insert.

by Arvind Singh Baghel

Import CSV or txt File Into SQL Server Using Bulk Insert.

Import Data from excel to SQL server using C# in ASP. NET

by Suraj S Koneri

When the user uploads the Excel file to the server its data must dumped to the SQL server database

Import Data from Excel to SQL Using SSIS 2012 Dynamic Configuration

by sudheer mattapally

How to import data from Excel to SQL using SSIS 2012 Dynamic Configuration

Import Images to SQL Server using SSIS

by sandeepmittal11

Import Images to SQL Server Database using SSIS

Import or Restore BACPAC File using SQL Server Management Studio

by Satya Karki

How to import or restore BACPAC file using SSMS

Improving Backup Performance

by Satnam Singh CapGemini

Improving backup performance

Improving SQL query performance using JOIN

by Krishna P Seetharaman

Faced slow performance in certain stored procedure, which caused timeout error. This was improved using WITH clause and JOINs

Increment the string value letter by letter for every row using SQL server

by chaitanya512

Using SQL Server, we can increment the string value letter by letter for every row

Increment the string value letter by letter for every row using SQL server

by Pascal Ganaye

WITH tempTable(Column1)AS( SELECT 'chaitanya' [Column1] UNION ALL SELEC`T SUBSTRING(Column1,1,LEN(Column1)-1) FROM tempTable WHERE LEN(Column1)>0)SELECT * FROM tempTable ORDER BY LEN(Column1)Result:cchchachaichaitchaitachaitanchaitanychaitanya

Index and Sort Order

by Mr. Joydeep Das

What the effects of Ordering in Index

Inno Setup Script to Install SQL Server 2008 R2 with Tools

by RickZeeland

Inno Setup script to install SQL Server 2008 R2 with Tools, creating an instance with special rights and displaying the log.

Insert Multiples Records to SQL Server Database

by Ricardo_Torres_Torres

Read text file and insert mutiples records in just one SQL Sentence

Insert/update/delete records in a single statement

by Praveen Meghwal

How we can write a single statement to perform insert, update and delete operation

Install SQL Server 2005 and 2008 on the same computer

by Ravi Tuvar

Installing SQL Server 2005 and 2008 in the same computer.

Instantiating an SqlException

by PIEBALDconsult

Using Reflection to instantiate a System.Data.SqlClient.SqlException

Instead of Triggers in Object-Relational (O/R) Mapping

by h_wiedey

Usage of instead of triggers in Object-Relational (O/R) Mapping

Integrate Google Analytic Data to Local Database using SSIS

by Asanka Perera

This process shows how you can integrate Google analytic data into your reporting server database in order to have daily reports and analysis to include data of your Google analytic account using a free available plugin for SQL Server Integration service called SSIS GoogleAnalyticsSource.

Integrating Perl REST service with jQuery and a database

by User 3776226

This article is a novice level demonstration of using jQuery consuming a REST Web Service written in Perl.

Intelligent Workbook for Generating Basic DAX Formulas used for Time Series Analysis of Measures

by FLouis38

Intelligent workbook for generating time series DAX

Interactive Analysis and Related Tools

by stormpy

Interactive analysis is a cycle analysis procedure of assumption, validation, and adjustment to achieve the fuzzy computation goal.

Introduction to Named Calculations in SQL Server Analysis Services

by Mubin M. Shaikh

Create Virtual Column Using Named Calculation in SQL Server Analysis Services

Is MS SQL Server Service Broker Responding to Read Uncommitted Data?

by Herman.Instance

When using SqlDependency, is it possible that a detected change leads to 0 rows in the SqlDependency results?

Issues after Upgrade to SQL Server 2017 – Cannot Bulk Load Data Into the Table with Primary Key Constraint on it

by Satnam Singh CapGemini

Cannot Bulk Load Data Into the Table with Primary Key Constraint on it

Java & JDBC & SQLite: Read Data from User-selected db Table and Show in JTable

by Emiliarge

A JavaFX/Swing NetBeans 8.0 Project with JFrame created by NetBeans's GUI Builder

JOIN Instead of Repeating a Subquery

by AspDotNetDev

Rather than use multiple subqueries to extract TOP 1 data, this shows you how to use a single TOP 1 JOIN.

JOIN Instead of Repeating a Subquery

by Goutam Patra

As an alternate, I would like to share the following query using the previous table definition using RANK:DECLARE @FirstTable table(FirstName varchar(20))DECLARE @SecondTable table (ID int, FirstName varchar(20), LastName varchar(20), FirstNameHashCode varchar(20), ...

Joomla Remote SQL Call -VB.NET Client

by FrankNight

In this tip, I show a set of helper classes useful to prepare and send messages to the SqlXML Joomla component and execute remote SQL calls to your hosted website.

Kill User Session in Sleep State

by NilayMistry

Know More about SQL Constrains

by Mohammed Nazer

SQL Constrains details and its types

Known Limitation of MySQL Cluster NDB 7.3 and MySQL Cluster NDB 7.4

by Masteramuk

Basic rules for using MySQL Cluster (NDB) from MyISAM or InnoDB

Large Log File SQL 2005

by Ahmed Kahwaji

Lead and Lag Functions in SQL Server

by sandeepmittal11

Lead and Lag Functions in SQL Server

Learn What is Cartesian Product in SQL

by Toma Tsyhan

This article is about understanding the Cartesian Product in SQL followed by some examples.

Len() vs. Datalength()

by Arunprasath Natarajan

Difference between Len() and Datalength().

Linking to an Existing SQLDB in ASP MVC4.0 and EF5.x

by SEJohnson

Linking to an existing SQLDB in ASP MVC4.0 and EF5.x.

Linq Except Operator to Get NonEmployee And Employee collection

by santosh poojari

This is most general collection operation that we come across daily. Its set based operation using LINQ Except Operator.

Linq Queries Examples Using Method And Query Syntax

by Mohd Manzoor Ahmed

Linq Queries Examples Using Method And Query Syntax

LINQ to SQL - Mapping Stored Procedure with Multiple Results

by Hiren Khirsaria

Mapping Stored Procedure with DBML to get multiple results from Stored Procedure

LINQ To SQL Using C#

by Ehtesham Mehmood

LINQ to SQL using C#

List All Tables and Columns in a Database

by AspDotNetDev

This query will show you all tables and columns in a database, and it can be pasted into Excel for easy manipulation.

List blocking processes in SQL server

by Chris Maunder

A quick script to enable you to find the processes that are blocking in SQL server

List blocking processes in SQL server

by Chris Maunder

Here's an alternate version that doesn't use sp_who yet provides a little more information. It also provides the option to kill the blocking processes themself.IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ListBlocking]') AND type in (N'P', N'PC'))EXEC...

List SQL Server table column name as rows

by Chamila Nishantha

Simple query to get table column name as rows

List SQL Server table column name as rows

by PIEBALDconsult

This is an alternative for "List SQL Server table column name as rows"

List SQL Server Table Column Name as Rows

by Wendelius

This is an alternative for "List SQL Server table column name as rows".

Locate SQL Server Instances on the Local Network

by Constantin Chumak

This is an alternative for "Locate SQL Server instances on the local network"

Logging error, debug, info messages into log tables

by SudhirKankal

Log4DB

Logtext with Parameters using sqlite3

by Anthony Lansbergen

Using sqlite3 for a multi language log where logdata can contain parameters.

LPAD and RPAD functions in SQL

by Member 10510822

LPAD and RPAD function works for padding in SQL Server

LPAD and RPAD Functions in SQL

by PIEBALDconsult

This is an alternative for "LPAD and RPAD functions in SQL"

LTRIM RTRIM doesn’t always work

by Israel Cris Valenzuela

LTRIM and RTRIM don't always remove all the whitespace characters in a field such as carriage return or linefeed

LTRIM RTRIM doesn’t always work

by PIEBALDconsult

In SQL Server 2008, I do that with a CLR User Defined Function:namespace PIEBALD.Lib{ public static partial class LibSql { public static string Trim ( string Victim ) { return ( Victim.Trim() ) ; } }}Needs to be built into a...

Manually Run All Subscription Reports in SSRS At Once

by Mubin M. Shaikh

How to manually run all subscription reports in SSRS at once

Merlin Framework 2013

by Marc Leger

ORM, databinding, asynchronous data access, and transactions

Microsoft ASP.NET Identity MerlinFramework 2.0

by Marc Leger

Microsoft ASP.NET Identity MerlinFramework

Microsoft SQL Name capitalize function

by cluengas2k

Microsoft SQL Function To Proper Case A Name From A Given String

Migrating Access Jet Data to SQL Server

by Mike Winiberg

GOTCHAs and tips useful when migrating a complex Access JET application to SQL Server 2012

Model System DB in Microsoft SQL Server

by Keshav Singh

Model System DB in Microsoft SQL Server

Money Precision Issues

by Bohdan Stupak

This tip shows some primary issue which puts a serious limitation on SQL Server MONEY data type.

Monitor Database Changes

by Member 7874525

This how you can monitor your database changes

Monitoring SQL Agent with Alerts for Long Running Jobs

by Member 14691410

Providing admin with an alert mechanism via an SP

More SQL XML, This Time Just Using SQL

by MarcusCole6833

Make some SQL XML dot style another way

MS SQL Scripts Runner

by sluaghtered

Script Runner that can run multiple SQL script files on MS-SQL.

MS SQL SERVER APPLY AND JOIN Keyword

by Dinesh K.S. Kushwaha

Tip on CROSS APPLY and OUTER APPLY

MSSQL doesn’t (completely) support IEEE754 floating points (NaNs and infinity)

by DavidSchmitt

After looking for quite a while (it is unbelievable, no?) I have to accept that Microsoft’s SQL Server 2000, 2005 and 2008 do not fully support IEEE-754 floating point numbers. Specifically NaN (Not-a-Number) and +/- Infinity are not allowed. While the 2000 Server seemingly allows such values to...

MSSQL to MySQL Export

by madagaga

Converting MSSQL database to MySQL

Multiple Actions from a Single VIEW Page in MVC

by sankarsan parida

This is developed for using Index, Create, Edit and Delete operations in a Single View Page

Multiple parameter "FillBy" method in table adapter using ODBC and PostgreSQL

by Amund Gjersøe

Visual Studio Query Builder does not work with PostgreSQL when you want to use filtering parameters. This tip show how to make your own "FillBy" methods.

My Personal Software Development Stack

by James Dale

My Windows Sever 2003 reaches its end of life in 2015. I do not look forward to moving to Server 2012. Surely there has to be a better, portable, and cross platform solution that features zero install and fits on a USB stick.

MyMDb your local IMDB store

by Paw Jershauge

Want your own movie database??? Download IMDB in 20 minutes.

MySQL can’t specify target table for update in FROM clause

by Lopamudra Pradhan

How to fix the error "MySQL can't specify target table for update in FROM clause" while executing an update query.

MySQL Essentials for Beginners

by Masoud AI

Things you need to know before you start working with MySQL

MySQL: DATETIME vs TIMESTAMP

by Suvendu Shekhar Giri

Difference between MySQL DATETIME and TIMESTAMP datatypes

Native Auditing in MS SQL Server 2008

by SatyLepide

MS SQL Server, a popular database management system from Microsoft, is widely used by organizations to store their data and to fetch them when required.

New High-Availability/Disaster-Recovery solution provided by SQL Server 2012

by yuanfeng.ma

New high-availability/disaster-recovery solution provided by SQL Server 2012.

New User Creation And Admin User Creation In SQL 2012

by apachearun

How to create a new user and administer user creation in SQL 2012

Number of different ways to get total number of rows from tables

by Pranay Rana

Getting a SQL Server RowCount Without doing a Table Scan

Optimized way to join tables residing across multiple databases in Oracle

by Karthik Narahari

Querying data from tables across multiple databases when we need data from all those tables in a single query.

Oracle Parameterized Queries for the .NET Developer

by Foothill

A Primer for Writing Parameterized Oracle Queries for the .NET SQL Server Developer

Order by Clause with Column_Index instead of Column Name

by RaviRanjanKr

A tip enable you to learn how to use Column_Index instead of Column Name with Order by clause

Output Clause - SQL SERVER, You Can Replace Some of Your Triggers

by sabindas k s

Output Clause - SQL SERVER, You Can Replace Some of Your Triggers

Paging DataGridView in C# using LINQ

by mohammad amiri

Paging DataGridView using LINQ in C#.

Parse Key Value Pairs from string in SQL

by Sumit Chawla

Describes how to parse and extract key value pairs from a string or column in SQL

Pass OUTPUT Parameter from Stored Procedure to SSIS Precendence Constraints

by Baliram Suryawanshi

Pass OUTPUT parameter from stored procedure to SSIS Precendence Constraints

Passing Object Collections to ASP.NET Web API

by Tom Glick Philadelphia, US

POC to demonstrate passing of collections of complex objects to ASP.NET Web API Controllers.

Perfect Pagination with Repeater Control in ASP.NET C#

by ChienVH

Perfect Pagination with Repeater Control in ASP.NET C#

PHP, VBA and SQL Useful Scripts

by Mirzakhmet Syzdykov

Development process in few steps with the help of scripting software

PHP's Database Operation- Go OO

by Peter Leow

The OO way to writing your database operation code in PHP

Pivot Operator in SQL Server Simplified

by Gaurav_Chaudhary

This tip is a brief introduction to Pivot operator in SQL Server

Pivot Table Using Linq Entity and SQL Server 2008 R2 for Dynamic Columns

by Avinash Narnaware

How to create Pivot Table in SQL Server 2008 R2 and in C# Linq to Entity Framework in a step by step manner with two different instances.

Pivoting on SQL Server Varchar Data Types

by Sifiso W Ndlovu

This tip illustrates a workaround to SQL Server pivoting on variable character data types.

Post on how to do Paging in Oracle

by Santopk

Oracle Paging

Postgres Foreign Table Example

by Carlos Luis Rojas Aragonés

Snippet to get started with foreign tables

PostgreSQL: How to Get 'serial' Value of the Inserted Record and Use with a Variable

by debashishPaul

How to Get 'serial' value of the Inserted Record and Use with a Variable in PostgreSQL

Preventing SQL Injection Attacks

by Nagaraj Muthuchamy

This article gives an introduction on SQL Injection attacks and tips to prevent it.

Programitically retrieve the trigger definition

by Manas Bhardwaj

I ran into this strange situation where I wanted to get Trigger Definition(the SQL content) of a specific trigger from a database. The following SQL query can used to retrieve the trigger definition programitically.SELECT DB_NAME() AS DataBaseName, dbo.SysObjects.Name AS...

Programming DOS Shell

by Ajit Kumar Thakur Microsoft

This tip describes steps to learn DOS batch programming.

Pure SQL solution to Database Table Paging

by DrABELL

Portable solution encapsulated in single SQL query allows to select N rows offsetting M records

Quartz.Net with Multiple Schedulers

by Harshit Gindra

Understanding the use of multiple schedulers to work with one Quartz Scheduler application

Query Excel or CSV files with T-SQL

by Federico Di Marco

Query Excel or CSV files with T-SQL without importing them in a table first

Query Results Column Information

by Dave Elliott

Find the column information of a SQL query

Query that returns list of all Stored Procedures in an MS SQL database

by Sandeep Khairha

Query that returns list of all Stored Procedures

Quick and dirty reporting solution using Excel

by Oshtri Deka

Quick and Easy Date Range Selection

by George H. Slaterpryce III

Easy Between replacement.

Quick-and-Dirty Testing of Microsoft Access Queries

by B. Clay Shannon

How to query Microsoft Access tables

Quickest Way to Create a .NET Database Application

by Subha.N

Tip to create a database application using C# .NET in the shortest time possible.

Random Number Generation using SQL

by Shikur Yennus

Linear congruential is one of methods used to generate random numbers.

Read & Insert Data Using Stored Procedures in C#

by gayani dassa

Read & Insert Data Using Stored Procedures

Read a file using transact-sql.

by Md. Marufuzzaman

How easy to read a file without using of the seven extended stored procedures.

Reading Duplicate Values from the Table

by Indrajeet Sutar

Hi, on many occasions we want to search some repeated values in one or more columns. It is quite simple to do this...select ColumnName, count(ColumnName) as NumberOfTimesfrom TableNameGroup By ColumnNamehaving (count(ColumnName) > 1)At the same time, there is also a requirement...

Real-time Tracing With SQL Server Express

by Pete_H

This tip explains how to do tracing with SQL Server Express using a desktop application written in C#, .NET 4.

Rebuild and Reorganizing the index on SQL Server

by Ram Balak Sharma

Improve SQL server performance by rebuild and reorganizing the indexes

Rebuilding Master Database in SQL Server

by Kareem.S

This tip shows a case study of how to rebuild master database

Recursive CTE in SQL Server Simplified

by Gaurav_Chaudhary

This tip is a brief introduction to Recursive CTE in SQL Server and how to implement it.

Recursive Queries in Microsoft SQL Server 2008

by Sadeque Sharif

Recursive queries in Microsoft SQL Server 2008

Relational Database Design with an Auto Insurance Database Sample

by Prakash Lekhak

Create an ER diagram for complex database

Remove Duplicate Rows with CTE

by Ehtesam Ahmed

This article gives you quick tip about how you can remove duplicate rows easily using common table expression in SQL

Removing the minutes and seconds from a DATETIME

by OriginalGriff

A basic user defined function to remove minute and second from a DATETIME

Rename a Database and its MDF and LDF files in SQL Server

by Tecfield

This tip shows how to rename a database and its MDF and LDF files in SQL Server.

Reorganize and Rebuild Indexes and Update Statistics

by GabrieleTronchin

A simple stored procedure to add at your database to keep it reactive

Replace Cyrillic Letters with Visually Similar Latin Letters Using T-SQL

by Pavel Sinkevich

If data source is populated manually, there is a typical problem: a mix of visually similar Cyrillic and Latin letters. This tip describes how to fix it.

Reports from Reporting Server

by ShajuAntony

List out reports from Reprting Server.

Reset PLSQL sequence value

by Shahriar Iqbal Chowdhury/Galib

Reset PLSQL sequence value

Reset SQL Server SA (System Admin) Password

by Sarathi Balakrishnan

Reset SQL server SA (System Admin) Password when you have lost all possible ways to connect to SQL server and your server has only Windows authentication disabled. You should have Windows administrator permission to do this.

Reset Table Identity

by Sunasara Imdadhusen

SQL SERVER – DBCC RESEED Table Identity Value – Reset Table Identity

REST API Made Easy with Supido

by jseijas2

In this tip, we will see how you make quick REST API from database defining the API in a configuration file.

Restart a SQL Server Scheduled Job If Hanged

by anki.mathur

Restart hanged SQL Server scheduled job

Retreive and update meta property of a table in MSSQL

by barry fat

develop a web based data dictionary

Retrieve Unsaved/Lost SQL Script Files due to SSMS Crash or Accidental SSMS Termination

by Elisha Cornelius

Recover SQL Script files that are lost due to SSMS Crash or whatever the other reasons

Right vs. Left Outer Join

by Patrycja Dybka

The explanation of left and right outer join.

Row_Number in SQL Server

by sandeepmittal11

Row_Number in SQL Server

ROWCOUNT Behavior with Aggregate Functions

by Abhishek Kumar Goswami

Sometimes, you might find different error handling ways inside a stored procedure like some people use the error code to check the behavior of code or some other techniques. In this tip, I am going to discuss one of the techniques and its special behavior in a situation and why.

Rowversion: Version Stamping A Row

by SonuKSingh

rowversion datatype in SQL Server: Track which row has been modified

RSA Encryption in PL/SQL

by Juan F. Paleo

Encrypt data with RSA Public Key

R-script Migration to SQL Server 2016

by Evgeniy Sukhikh

Issues and solutions taken while moving R from cmd to sp_execute_external_script

Run All .sql Files in a Directory for Deployment

by RiniBoo

Run all .sql files in a directory with results returned showing execution being successful or failure

Run All Subscription Reports At Once in SSRS Manually

by Mubin M. Shaikh

Manually Run SSRS Scheduled Reports

Run Single Page Applications (SPA) Template using AngularJS, Web API, Owin Token Based Authentication and Mediator Design Pattern

by Ahmet AYDIN

This post describes step by step how to run a Single Page Application template using ASP.NET Web API 2 and angularJS and how to use Web Application Project whose name is Dalyan.

Running a ClickOnce app as Administrator under Windows 8

by Phil Jeffrey

How to run a ClickOnce app as Administrator on Windows 8 when the app includes a SQL Compact database

Save image with printed text on it

by Sonali Agarwal

Create an ASP.NET page where the user can edit/modify text for an image and then save that image with printed text on it.

Schedule Generation of All Object Creation Scripts for All Specified SQL Server Databases

by CMYork01

How to schedule generation of all object creation scripts

Search in your DB-Objects With Multiple Keywords

by hmdmgd3

SQL code allows you to find objects using multiple keywords in your DB

Searching within all the Stored Procedures in a database

by Saral S Stalin

You can search for any string with in the TSQL scripts of all the Stored Procedures in a database using the syscomments table.

Security Vulnerabilities – How to Find and Fix Them

by datarockets

Finding a vulnerability, using it for data extracting from the database, and fixing it with just one line of code

by MarkLTX

When using LINQ to SQL, it can be very useful to see the SQL commands that are generated by your LINQ expressions. Sometimes the results are surprising and you might be able to improve performance by tweaking the LINQ.All you have to do is set the Log property of the DataContext object. ...

by Henry Minute

Or, there's always Scott Guthrie's LINQ To SQL Debug Visualizer[^].[Edit]While I'm posting links there is a nice utility that can output the generated SQL to the Debug Window in VS written by Kris Vandermotten.You can get it here[^].To use it: MyDataContext db = new...

by Philippe Mori

LINQPad is an interesting tool to try queries.LINQPad[^]Perfect tool to try out some alternatives for complex queries. As we can see generated queries and elapsed time, it help a lot to help having fast queries for complex requests.

Select a column in a comma separated row in SQL

by AspDotNetDev

If you are the type that likes to debug production code, you can use SQL Profiler to find queries generated by your LINQ statements. This is a technique I recently used because it was so simple and did not require me to recompile anything.Note that StefanHam already posted this alternate...

by eceramanan

How to select a column from a comma separated row in SQL

Select a column in a comma separated row in SQL

by pankajupadhyay29

Nice one but it did not handle null values you can change it as following to handle null valuescreate table #TABLE_1 (COLUMN_1 varchar(5))insert into #TABLE_1select 'A'union allselect 'B'union allselect 'C'union allselect 'D'union allselect 'E'union allselect...

Select a Default Row in SQL

by DiponRoy

Select a default row for a query that returns no rows

Select Statement to HTML Table

by Luca Astolfi

User defined procedure for make an HTML table from T-SQL Select statment

Select users with birthdate in the next 10 days

by OriginalGriff

Select users with a birthday in the next "n" days is pretty easy, if you use the day of year. The only slight complication is the need to "wrap" round the year end.

Select, Insert and Delete in MVC using WCF Services

by Pranav_

Performing insert delete and select in MVC 4.0 using WCF services, with one view and different action methods.

Selecting parent records with specific subset of child records

by Jovan Popovic(MSFT)

I will show you how you can select one parent row with two latest child rows using T-SQL

Selecting parent records with specific subset of child records

by Jovan Popovic(MSFT)

If you are using some alternative SQL dialect without common table expression syntax, you can use correlated sub-query as the one in the following example:SELECT * FROM( SELECT Company.CompanyName, Employee.EmployeeName, Employee.DateHired, ROW_NUMBER() OVER( PARTITION BY...

Selecting Valid Records

by Wendelius

This tip demonstrates how to select valid records from a table that contains validity date limits.

Sequence Object in SQL Server 2012

by sandeepmittal11

A sequence is a user defined, schema bound object that generates a sequence of numeric values

Serialized collection of classes or List of objects into XML and bulk insert using OpenXML

by SoumenBanerjee

In this article I have tried to cover a few topics like serialization to XML, bulk insertion, etc.

Session Killer for SQL Server

by mparvez

Session killing from a SQL Server database.

Set global profile for mailing in Microsoft SQL Server 2008

by db_developer

Allows to set default mailing global profile with aid of T-SQL

Setting Up a SmartOS Machine With Node.js and an AMP Stack

by simsam77

How to set up a SmartOS machine with Node.js and an AMP stack.

Setting up an MS Outlook Appointment C#

by DecodedSolutions.co.uk

This is a simple article describing how to create an add an outlook appointment to your MS Outlook Calender.

Setting up SQLite and Entity Framework 6 (Code First and Database First)

by User 10668410

How to get SQLite 1.0.98.1 working with Entity Framework 6.1.3 without a massive headache using the Database First Model and Code First Model.

Shortest Path in SQL Server using hierarchyid

by Mehdy Moini

Implementing a map as a tree, and finding the shortest path, between the streets, is what you will see.

Simple Method to Save Image in Database

by Ankit R Goud

This tip shows you how to insert image in database.

Simple query to get weekdays between two date fields

by GregStevens

How to get weekdays between two date fields without a stored function

Simple Technique to Exclude Column from SELECT * FROM TABLENAME

by SERokon

Exclude Column from SELECT * statement

Simple Way To Use Pivot In SQL Query

by Maksud Saifullah Pulak

Transforming data from row-level data to columnar data.

Single SP for Multiple Search Scenario

by SantanuDebnath

Write one SP for multiple Search

Small function to replace characters with SQL Server

by Wendelius

A small function utilizing CTE to replace undesired characters from a string

SMO Scripting Based on Dependency

by Thava Rajan

Prepare script for specific objects

Snippet and Surround features in SQL Server 2012

by Tigya

Snippet and Surround features in SQL Server 2012.

Solution to annoying error 0029 - Cannot convert type 'T' to 'System.Data.Linq.Link'

by Itai Basel

Finally found a solution to the annoying LINQ to SQL dbml error: CS0029 : Cannot implicitly convert type 'int' to 'System.Data.Linq.Link'.

Some Common Mistakes When Querying SQL Database

by Bohdan Stupak

This tip will cover several interesting issues of SQL

Some internal SQL Sever Queries

by Gaurav Dudeja India

The following query uses the sys.objects catalog view to return all database objects that have been modified in the last 10 days.SELECT name AS object_name ,SCHEMA_NAME(schema_id) AS schema_name ,type_desc ,create_date ,modify_dateFROM sys.objectsWHERE modify_date >...

Sort a Column Inside an Already Created Table

by Joan M

This tip will explain how to sort a column inside a table.

Sort AlphaNumeric Data in Sql

by Anurag Gandhi

I have gone through a lot of examples to sort alpha numeric data in sql. Here is my way:

Sorting column that contains string with numeric value

by Md. Marufuzzaman

Sorting column that contains string with numeric value

Sorting 'Total' After Data Values

by PIEBALDconsult

Interspersing 'Total' rows among summarized data rows in the correct order

sp_who2 to find dead locks in SQL Server

by Liju Sankar

Find deadlocks in SQL Server using sp_who2 (an undocumented and thus unsupported stored procedure)

Speed up SQL Stored Procedure by changing IF...ELSE Block and Loop with SQL Queries

by sukeshchand

Speed up your SQL Stored Procedure by changing IF...ELSE Block and Loop's with SQL Queries

Spilt DateTime Ranges in SQL Server

by DiponRoy

Split date time ranges into days or possibly other ranges using CTE in SQL Server

Split Any Delimited String in SQL

by Ksh_Sr

This tip shows how to separate a string with delimited characters.

Split Any Delimited String in SQL

by PIEBALDconsult

This is an alternative for "Split Any Delimited String in SQL"

Split comma separated IDs to get batch of records through Stored Procedure

by Nasser Malik

Split comma separated IDs to get batch of records through Stored Procedure.

Split function

by db_developer

Split User Defined Function, MS SQL Server 2008

Split function in SQL

by Gauri Chodanker

SQL function in SQL

Split string into Rows / Columns using Delimiters

by kasbaba

This tip is to help anyone trying to split strings in SQL into Rows and Columns based on Row/Column Delimiters

SQL - Converting a varchar parameter to a table

by Glagace_7763

Create a table from a Varchar list value

SQL - Now you see me, now you don't

by Programm3r

ISNULL - COALESCE

SQL 2012 - Newly Introduced Date and Time Functions

by Jinesh Parekh

Newly introduced Date and Time functions in SQL 2012

SQL 2012 Scheduling Auto Backup

by apachearun

How to do scheduling auto backup in SQL 2012

SQL and Sets

by Michael S Rempel

About SQL and sets

SQL Atomic Operation on UPDATE and DELETE

by Robby Tendean

How to do SQL atomic operations on UPDATE and DELETE syntax.

SQL Bulk copy method to insert large amount of data to the sql database

by bluesathish

Fastest and most efficient method to insert large amount of records to a SQL Server database from our system generated datatable.

SQL Bulk copy method to insert large amount of data to the sql database

by THE BLACK TIGER

Thank you for this article, okay it's technical.But we can use other methods considered as more efficient. *For Microsoft SQL Server, we can use bulk copy program(bcp). The tool is embeddedwithin SQL server so you can invoke it inside your application - whatever language you use....

SQL CASE WHEN condition THEN NumericColumn ELSE 0 END

by Niemand25

Be careful with CASE WHEN when dealing with numeric columns and using zero literal

SQL Change Data Capture (CDC) table not working after adding new columns to the source table and Using CDC with a frequently changing schema

by Rajesh Manjarekar

When CDC is turned ON against a table and the underlying table schema changes, such as adding/removing a column, changing datatype etc

SQL CLR Functions

by Sreekanth Mothukuru

SQL CLR functions

SQL CLR Objects Quick Get Started

by S.Sathik Ali

This tip contains the settings and configuration details to quickly get started with SQL CLR objects to create, build, deploy and test.

SQL Convert Simple Names to Proper Case

by PIEBALDconsult

This is an alternative for "SQL Convert Sentence to Proper Case"

SQL COUNT(*) Vs COUNT(column_name)

by Samrat Banerjee

In many case we need to use COUNT function, but always we prefer COUNT(column_name) in placeof COUNT(*) and reason behind that COUNT(column_name) will perform better or faster than COUNT(*).Is this correct?SQL Server can't read just the contents of a single column without reading the...

SQL COUNT(*) Vs COUNT(column_name)

by Dennis Ålund

Well, another major point is that the two variants serve different purposes by definition. -- Count rows where 'column_name' is NOT NULLSELECT COUNT(column_name) FROM Table_Name-- Count ALL rows in Table_Name SELECT COUNT(*) FROM Table_Name-- ... which you just as well can...

SQL cursor without using real cursor

by Evgeny Bestfator

Sometimes for processing rowsets we need a cursor, but we may not use standard cursor, we can create our pseudo cursor with much more simple syntax...

SQL Database Access

by Martin Vorbrodt

SQL database access

SQL database backups by batch file (using SQL script and batch script)

by Charitha Athukroala

Creating SQL database backups through batch scripts and SQL scripts.

SQL Dependency using Entity Framework in WPF

by CyberMakarov007

SQL table dependency with entity framework in WPF

SQL Dependency with C#.NET and SQL Server 2012

by Charaf Dadoua

SQL dependency with C#.NET and SQL Server 2012

SQL Executer to run SQL Queries

by dontumindit

Installing Oracle or SQL Server just to practice SQL Queries is not a good idea. They occupy a lot of space and also slow down the normal processing of the PC.

SQL for Listing Field(s) on Columns

by Member 4206974

A tip to get a data list on 2 (or more) columns.

SQL function to return CSV as a table

by Neh.C

/*************...

SQL Get the last date of the month

by Mycroft Holmes

Select dateadd(day, -1, dateadd(month, 1, dateadd(day, 1 - day(@Date), @Date))

SQL Get the last date of the month

by Asif Mushtaq

An alternative version of "SQL Get the last date of the month"

SQL Injections and their Prevention

by Shivangi_K

SQL injections and their prevention

SQL one to one relations

by FDW

How to define a one to one relation

SQL Optimization Tip

by Talking Dotnet

Use SET NOCOUNT ONWhenever we write any procedure and execute it a message appears in message window that shows no of rows affected with the statement written in the procedure and we become very happy to see that our procedure is working. But do you know that this message creates an extra overhead o

SQL Queries to Know the Instance Messages State

by tanmoysarkar

SQL queries to know the instance messages state

SQL Query Tool for Google Fusion Tables

by István Smrtnik

A Google fusion tables SQL front end for quick query hacks. Comes with code completion, syntax and error highlighting plus some extra commands like DROP TABLE. Antlr4 grammar included.

SQL Schema Support Multi Version Tables

by Simon Korenfeld

SQL schema with multi version tables support

SQL script for creating an ASP.NET Identity Database

by Mr.Thursday

SQL script for creating ASP.Net Identity Database

SQL Script to Drop and Re-create All Foreign Keys in SQL Server

by Nitinpatel

This SQL script will generate a script to drop and create all foreign keys in database.

SQL Server - Linked Server Query - Unexpected Catastorphic Failure

by TheSqlGuy

This briefly goes over an issue experienced when executing a query against a linked server to Oracle from SQL Server.

SQL Server 2008 - Loop through/split a delimited string

by Ganu Sharma

Loop through/split a delimited string.

SQL Server 2008 Error: Saving changes is not permitted

by Prasad CM

How to fix this error.

SQL Server 2008 Transactions Usage Template

by AlexCode

A starting point for your transaction-aware SQL Server scripts

SQL Server 2008 User Defined Table Types and Table-Valued Parameters

by PIEBALDconsult

Simple demonstration of using UDTTs and TVPs to pass DataTables to SQL Server 2008

SQL Server 2012 Auto Identity Column Value Jump Issue

by S. M. Ahasan Habib

From SQL Server 2012 version, when SQL Server instance is restarted then its auto Identity column value is jumped based on identity column datatype.

SQL Server 2012 Metadata

by Ajit Kumar Thakur Microsoft

This tip explains SQL Server metadata information. It will provide internal details of all available SQL Server 2012 Metadata.

SQL Server Assembly Creation

by deepakaitr12345

How to create an assembly in SQL Server and store it in the database.

SQL Server Backup Utility

by Charles T. Blankenship

Backup and Restore SQL Server utility (where there is no SMSS onsite)

SQL Server Connection Dialog (Extensible)

by Chris Winkelmann

Display a SQL Connection Dialog with extensible functionality to persist the resulting connection string to any location...

SQL Server Culture Mapping with .NET Framework

by Shemeer NS

How to do SQL Server culture mapping with .NET Framework

SQL Server Data Tools to Visual Studio 2013 - Database Reverse Engineering

by JoaoSousa23

SQL Server Data Tools to Visual Studio 2013 - Database Reverse Engineering

SQL Server Database Backup Status Report

by Dathuraj Pasarge

Know whether your databases are backed up successfully in the last 24 hours or not !!!

SQL Server database backup using a Batch file

by Charitha Athukroala

This article will help you make a Batch file which can easily backup SQL Server databases.

SQL Server Database Inventory using PowerShell

by Dathuraj Pasarge

Extract SQL Server DB inventory\baseline using TSQL and PowerShell scripts

SQL Server export to CSV

by Muhammad Magdi

This tip contains how to Export SQL Data to CSV files using normal ways and mainly using SQLCM.

SQL Server failed to load assembly with PERMISSION_SET = EXTERNAL_ACCESS or UNSAFE

by Keith Barrow

The message is a piece of crap. Is not appropriate for anything technical here, no matter how true it is.If you want this tip/trick approved you should :a) Get rid of that last sentenceb) You state the problem, but you should outline the exact steps that fixed it. Regards,Keith

SQL Server Function - SP_RENAME and NEWID

by Khanna_Varun

Getting overview of new SQL Server functions

SQL Server Health Check Script with Powershell

by Atul_Kapoor

Perform SQL Server Instance health check simultaneously on more than one server using Powershell

SQL Server Health Check Up

by Shivangi_K

SQL Server health check up

SQL Server Lock Critical Section

by Hernán Hegykozi

Marks a statement block as a critical section by obtaining the mutual-exclusion lock

SQL Server Recursive Fetch From Self Referencing Table

by Anish M

CREATE PROC GetChildNodes (@ID uniqueidentifier)ASBEGINWITH PermissionList (PermissionID, PermissionName, Level)AS(SELECT ap.PermissionID, ap.PermissionName, 0 AS LevelFROM Permission AS apWHERE PermissionID = @IDUNION ALLSELECT ap.PermissionID, ap.PermissionName, Level + 1FROM

SQL Server StringPadding (String function)

by Surender Singh (CodeToastDev)

Custom StringPadding functions for SQL Server

SQL Server: Doing String Split And Join

by DiponRoy

How to do string split and join in SQL Server

SQL Server: Find Table Order/Generation And Relation Details

by DiponRoy

A utility query to find table generations in SQL Server relational database

SQL Server: Find Week Start And End DateTime

by DiponRoy

Finding week start and end date time from a given date time

SQL Server: Get All Databases Size

by aasim abdullah

A simple query to get all databases size on a given instance.

SQL Server: How to Get All Indexes List With Involved Columns Name

by aasim abdullah

Get all indexes list in detail, with their involved columns

SQL Server: Keeping Log/Alert for Job Disable/Enable Status

by aasim abdullah

How do you know, if someone disabled your job at production database server. Who is the calprit. How to send a mail alert for this change ??

SQL Server: Select Single Row From Each Group

by DiponRoy

Selecting single row from a group of rows

SQL Server: SQL script to find upcoming birthdays

by prashant0556.s.more

The script helps to find out upcoming birthdays even when days cross a year.

SQL Subqueries

by Patrycja Dybka

This tip describes what a subquery is and covers some basic examples.

SQL Synonyms :.: Avoiding Dynamic SQL

by Claudio cespon

A first approach to avoid Dynamic SQL in stored procedures

SQL Totals for this week and other useful time periods

by OriginalGriff

Getting totals for a specific period: this week, this month, this year. And last week, last month, and last year.

SQL TVP Made Easy

by Mason Kuck

I walk you through how to make use Table-valued parameters with one value

SQL Zip Compression, RegEx and Random Functions

by Brad Joss

SQL CLR Functions for Zip Compression and Regular Expression evaluations

SQL: Column Values as Comma Separated String

by Srinivas Kalabarigi

Column values as comma separated string in SQL

sql-functions for better estimation of route-distances and traveling times in pure sql (without routing)

by Peter BCKR

a simple way to estimate as accurately as possible route-distances and traveling times without exact route calculation in sql

SqlServer Clr Functions Utility

by Member 10262330

I developed this DLL to have a more powerful utility and to simplify SP and query.

SqlServer: Parameterized Query With IN() Clause C#

by DiponRoy

A utility class to send parameters for IN() operator in SQL using parameterized queries

SSIS 2008 drop last data row from *.csv or *.txt file while import data using SSIS DataFlow Task..

by Rajesh Manjarekar

I found out that a possible cause is the difference between the SSIS 32 bits and 64 bits environment

SSIS: Load Data in Dimension Table Using SQL

by mparvez

Load data in Dimension Table using SQL.

SSIS: Normalize Table by Lookup

by mparvez

How to normalize a table by using lookup transformation.

SSIS: Transform data using Regex

by mparvez

Transform data by using regex and Script Component.

Steps to install Microsoft SQL Server 2008 Express Edition (Standard or with Advanced Services)

by Jesus Carroll

This brief article show how to install quickly Microsoft SQL Server 2008 Express Edition Standard or with Advanced Services

Store Large Amounts of Data using FCKeditor

by mparvez

How to insert and load large amounts of data with formatting using FCKeditor

Stored Procedure Generator For SQL Server

by Mahesh Bailwal

This is a stored procedure generator for SQL Server

Stored Procedure Returns No Fields Even After Refresh Fields

by Member 10295860

Using stored procedure type for binding data to dataset in SSRS or adding entity to Entity data model

Streamlined [Data Model-less] Record Editing with a SQLite Data Object Window Base Class

by ergohack

This SQLite Data Object Window base class automates the data updates and the data bindings between the XAML presentation and the SQLite database allowing the minimum of code needed to present and edit SQLite database records.

String concatenation in Transact-SQL

by Anton Burtsev

Performing fast concatenation of strings from different records

String concatenation in Transact-SQL

by AspDotNetDev

I like the original solution, especially when compared to this (which I am posting just to show that there are other solutions):-- Initialize table.CREATE TABLE #BigStrings( StringID bigint IDENTITY(1,1) NOT NULL, StringValue text NOT NULL, CONSTRAINT PK_BigStrings PRIMARY KEY...

Strongly Typed Stored Procedures for .NET

by dibley1973

Call stored procedures in a type safe way using my StoredProcedureFramework for .NET

Survey/Polling System Using RadioButton List

by uspatel

An article to demonstrate a polling/survey system in ASP.NET using a RadioButtonList.

Table Auditing (Created By, Creation Date, Last Modified By, Last Modification Date)

by Mina Talaat Ghaly

Add the auditing properties with one SQL query and fill them from one place.

Table Value Parameters, SQL Server 2008, and ASP.NET

by Adittya Gupta

Table Value Parameters in SQL Server 2008 with ASP.NET.

Template to Handle Error in SQL Server

by Jitendra Ku. Sahoo

Below is one template to handle error in SQL server.

Temporary Table in PostgreSQL

by Patrycja Dybka

Temporary table is a special table that is bound to a transaction or to a session. It means that the data in the temporary table and the definition lasts till the end of the transaction or session.

TFS Backward Migration from (2012SP1\SQL 2012 ENT) to (2010 SP1\SQL 2008 R2 STD)

by Sushil Pandit

Process for backward migration of code from TFS 2012 to TFS 2010

The Best Table Finder (The BestCube Problem)

by BharatRamV

Finds the Best Table for a given set of columns

The Difference Between ROW_NUMBER(), RANK(), and DENSE_RANK()

by Arif H Shigri

This tip will discuss the difference between ROW_NUMBER(), RANK() and DENSE_RANK().

by #realJSOP

Just say no to SELECT * in your SQL

by wizardzz

It also limits SQL's ability to find a proper index to use, hence hindering performance. I wasn't aware of this aspect until a SQL consultant made mention of it. Unfortunately we haven't adopted the policy of dropping the *.

by Rutvik Dave

I 100% agree with this.Another trick is *if possible* add audit columns at the time of creating/designing the database, i.e.:CreatedOnCreatedByLastModifiedOnLastModifiedByThis could prevent people from using Select *, because generally we don't display such information anywhere, and...

by Ennis Ray Lynch, Jr.

As a counter, relative indexing from SELECT * queries is most often the cause of the "evil". Although we live in a day and age of autogenerated DAL's, using the data reader's indexor that accepts a string is a valid and acceptable alternative to the never use a SELECT * query, in fact, when...

by Sander Rossel

Another 'weird feature' of select * is that in Views select * does not select all columns from a table. It selects all columns from a table that were in the table at the time that the View was created. I found that out when I added some columns to a table and wanted to map those columns in a...

by RichYards

I agree with this. However, typing all of the columns can be tedious! Now imagine you are working with a table with DOZENS of columns?! SELECT * FROM DENORMALIZEDTABLE1If you are using MS-SQL or writing a query in MS Visual Studio then there is a trick. You can: * write the select *...