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

SQL

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

17 Sep 2012 by aasim abdullah

Get all indexes list in detail, with their involved columns

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

1 Oct 2012 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: Get All Databases Size

2 Oct 2012 by aasim abdullah

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

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

17 Dec 2010 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.

SQL

Adding Time in HH:MM Format - Useful SQL Query

10 Feb 2012 by abdul sami

select aday, code, convert(varchar(5), min(atime), (108))MinTime, convert(varchar(5), max(atime),(108)) MaxTime from testgroup by aday,codeorder by aday asc

SQL

SQL-Server

SQL-Server-2005

ROWCOUNT Behavior with Aggregate Functions

3 Dec 2014 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.

SQL

How To Select Record Based on Row Number

20 Jan 2010 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...

SQL

SQL-Server

SQL-Server-2005

Comparison Chart for Two Different Time Frames in SSRS

22 Jan 2015 by Abu Zafor Khairuzzaman

Comparison Chart for Two Different Time Frames in SSRS

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

17 Dec 2013 by Adittya Gupta

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

SQL

.NET

ASP.NET

Why Use ASP.NET for Web Development

13 Sep 2014 by Afzaal Ahmad Zeeshan

A slight comparison of ASP.NET upon other (web) programming languages in the market and a discussion of me and some other (web) programming language developers.

Challenges in Data Migration Testing

12 Jan 2016 by AgarwalPriyanka, ErGauravSharma

Challenges faced in data migration testing

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

27 Sep 2014 by Ahmad A.A. Ahmad

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

Large Log File SQL 2005

25 May 2010 by Ahmed Kahwaji

SQL

file

General rules on selecting Data Types of SQL Server

23 Nov 2011 by Ahmed Naqibul Arefin

SQL

server

How to set an alternate row color in SSRS 2005

26 Aug 2010 by Ahmed_Said

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

23 Mar 2016 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.

SQL Server 2012 Metadata

31 Mar 2015 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

SQL-Server-2012

Programming DOS Shell

1 Apr 2015 by Ajit Kumar Thakur Microsoft

This tip describes steps to learn DOS batch programming.

SQL

Windows

DOS

Get an Accurate Age by Date

19 Feb 2010 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....

SQL

Build Your Own Movie Database with SQL Server

24 Oct 2016 by Aless Alessio

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

How to Get on Track with Active Directory

7 Oct 2014 by Alex_2979

How to get on track with Active Directory

SQL

Fast way to deal with foreign keys

18 Jun 2010 by Alexander Konstantinov

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

SQL

SQL-Server-2008

SQL-Server

Windows 7 Files

12 Nov 2014 by Alexandros Pappas

Lists the files that are installed with Windows 7 on a Virtual PC

SQL

Windows

server

SQL Server 2008 Transactions Usage Template

20 Nov 2011 by AlexCode

A starting point for your transaction-aware SQL Server scripts

SQL

Write error log in a text file for Custom Assembly being used in Reporting Services

19 Sep 2013 by alifaraze

writing error in a text file is very easy but writing error from a custom assembly in reporting services requires permissions

Type Preference with UNION in SQL Server

10 Dec 2013 by Amey A khedekar

A scenario with data type of the resultant select columns with UNION.

WITH (NOLOCK) example

20 May 2013 by Amey K Bhatkar

The use of With (NoLock) hit with a simple example.

SQL

DB Independent Code using Wrappers

20 Aug 2014 by Amol M Vaidya

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

A Git Query Language written in Rust

28 Jul 2023 by AmrDeveloper

Introduce GQL (A Git Query Language) to perform SQL like queries on .git files

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

15 Feb 2011 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.

SQL

ODBC

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

3 Jul 2010 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...

SQL

Build a Date Function

26 Nov 2012 by André Kraak

This is an alternative for "Build a Date Function"

T-SQL

SQL

Formatting Local Datetime to UTC in SQL Server

17 Jul 2012 by Ani_0707

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

SQL

SQL-Server

Dev

SQL Server Recursive Fetch From Self Referencing Table

19 Nov 2009 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

recursion

Restart a SQL Server Scheduled Job If Hanged

15 Jul 2014 by anki.mathur

Restart hanged SQL Server scheduled job

ADO.Net Connectivity using Stored Procedure and Output parameters

10 May 2015 by Ankit Bansal MVP

This articles explains the insertion of data into SQL Database using Stored Procedures with Output Parameters. Some Bootstrapping is also used to create a good looking HTML.

Simple Method to Save Image in Database

29 Aug 2013 by Ankit R Goud

This tip shows you how to insert image in database.

SQL

server

How to Get Words Separated in a String Concatenated by Delimiter

14 Apr 2014 by Ankur .K. Vishwakarma

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

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

6 Oct 2013 by Anoop Kr Sharma

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

SQL

Logtext with Parameters using sqlite3

15 Aug 2016 by Anthony Lansbergen

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

SQL

SQLite

String concatenation in Transact-SQL

5 Mar 2011 by Anton Burtsev

Performing fast concatenation of strings from different records

SQL

SQL-Server

Using SCOPE_IDENTITY with CommandBuilder and DataAdapter

23 Nov 2011 by Antonino Porcino

How to use T-SQL function SCOPE_IDENTITY() to retrieve inserted rows identity values with CommandBuilders and DataAdapters

Counting All Rows of All Tables in a Database

28 Sep 2015 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.

Sort AlphaNumeric Data in Sql

23 Aug 2011 by Anurag Gandhi

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

Copy/Synchronize Table Data between databases

16 Mar 2012 by Anurag Gandhi

A Query to copy an individual table data between databases

SQL 2012 Scheduling Auto Backup

9 Jul 2013 by apachearun

How to do scheduling auto backup in SQL 2012

SQL

New User Creation And Admin User Creation In SQL 2012

10 Jul 2013 by apachearun

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

SQL

How to Copy SQL Table Into Excel and Other Formats

10 Jul 2013 by apachearun

How to copy SQL table into Excel and other formats

SQL

Create New Jobs In SQL 2012

14 Jul 2013 by apachearun

How to create new jobs in SQL 2012

SQL

Using only TCP/IP for connecting to SQL Server 2008 and Changing the SQL Server 2008's default TCP/IP port

9 Apr 2014 by Aqeeel

Implementing security in SQL Server by only allowing TCP/IP Network Protocol and changing default TCP port

Identifying and Deleting Duplicate Records from SQL Server Table

1 Jun 2016 by Aqeeel

Identifying and deleting duplicate records from SQL Server Table

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

17 Jul 2017 by Arif H Shigri

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

SQL

SQL-Server

database

Delete Duplicate Rows in SQL Server

26 Oct 2014 by Arkadeep De

How to remove duplicate records using CTE in SQL

SQL

SQL-Server

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

9 Sep 2014 by aroen kandaswamy

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

SQL

.NET

VS2013

What is the Difference between ROW_NUMBER(), RANK() and DENSE_RANK()?

26 Sep 2014 by Arora_Ankit

This tip will explain the difference between these three functions.

SQL

paging

How to Improve Performance of Query

8 Oct 2014 by Arora_Ankit

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

SQL

SQL-Server-2008R2

performance

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

9 Mar 2016 by Arslan Elahi

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

SQL

SQL-Server

CSV

Len() vs. Datalength()

27 Sep 2012 by Arunprasath Natarajan

Difference between Len() and Datalength().

SQL

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

21 May 2014 by Arvind Singh Baghel

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

Integrate Google Analytic Data to Local Database using SSIS

31 May 2015 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.

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

27 Jan 2013 by AshishChaudha

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

Cool Insert Generator

26 Sep 2013 by Ashkan.hosseini

Stored procedure that generates insert stored procedure for tables

SQL Get the last date of the month

17 Nov 2009 by Asif Mushtaq

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

SQL

JOIN Instead of Repeating a Subquery

2 Feb 2011 by AspDotNetDev

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

SQL

String concatenation in Transact-SQL

9 Mar 2011 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...

SQL

SQL-Server

See the SQL Generated by LINQ

18 Jul 2011 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...

SQL

.NET

LINQ

List All Tables and Columns in a Database

20 Jul 2013 by AspDotNetDev

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

SQL

MS-Excel

SQL-Server

Encrypt and Decrypt password through SQL query

15 Apr 2013 by atul123321

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

SQL Server Health Check Script with Powershell

3 Dec 2014 by Atul_Kapoor

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

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

20 Nov 2014 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.

Displaying a Bar Chart using SELECT command in Oracle

4 Aug 2012 by Azim Zahir

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

Quick-and-Dirty Testing of Microsoft Access Queries

28 Jan 2014 by B. Clay Shannon

How to query Microsoft Access tables

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

16 Sep 2010 by B.Panchal

SQL

DBA

TRUNCATE/DELETE/DROP tables referenced by a foreign key constraint

8 Jan 2013 by Balaganesan Ravichandran

It works without affecting schema properties.

SQL

Pass OUTPUT Parameter from Stored Procedure to SSIS Precendence Constraints

20 Sep 2014 by Baliram Suryawanshi

Pass OUTPUT parameter from stored procedure to SSIS Precendence Constraints

Using Split Function convert single column to multicolumn in SQL

16 Aug 2012 by Balwant.mnd

My requirement is to convert a single column of a table to another multi column table with the save data that single column contained.

Retreive and update meta property of a table in MSSQL

14 Jun 2013 by barry fat

develop a web based data dictionary

SQL

dictionary

data

A better way to count(*)

8 Jun 2010 by basementman

Or, assuming your table has an index, you could do this "old-school" as:select MAX(rows) from sysindexes where id = Object_ID('{tablename}')

SQL

LINQ

SQL-Server

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

15 May 2021 by be05x5

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

SQL

XML

RDL

Execute an SSIS Package Through SQL Stored Procedure

31 Aug 2015 by Bert O Neill

Execute SSIS Package in C# or SQL Sproc

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

8 Dec 2014 by Bertin @nonodata.com

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

XML to Query Converter

7 Mar 2013 by BharatRamV

Converts XML to SQL statements and executes them.

SQL

The Best Table Finder (The BestCube Problem)

20 Dec 2016 by BharatRamV

Finds the Best Table for a given set of columns

Connection Error While Running Simple ETL Process With Excel using SSIS

22 Mar 2016 by Bhawesh Tiwari

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

SQL

How to Split Column in T-SQL

12 Jun 2013 by Bhushan W. Juare

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

SQL

How to Retrieve Dynamic XML Data from T-SQL

9 Jul 2013 by Bhushan W. Juare