Click here to Skip to main content
The default search term operator is AND.

You can use brackets, AND, OR, and NOT to improve your search. For example: C# AND NOT(VB or SQL)

A query of a single * will return everything, filtered by any filters.

Filter examples:
Search by Author  author:"author name"
Filter by tag  tag:C# or tag:(C++ or Java)
Wildcard search  use "?" or "*" eg. gr?d or gr*
  
104 Results

Search



Sort by



Match


Rating Range

Advanced Filters:


Page 1 of 3
Page Size: 10 · 25 · 50

Category filtered by:  Database [x] | Database [x] | SQL [x]
Technical Blog 9 May 2013   license: CPOL
Stored Procedure with sorting, paging, and filtering.
Database » Database » Sql
SQL
Tip/Trick 1 May 2013   license: CPOL
Split comma separated IDs to get batch of records through Stored Procedure.
Database » Database » Sql
ASP.NETSQLADO.NETAdvanced
Tip/Trick 25 Apr 2013   license: Ms-PL
Normalize a SQL column that contains a list of values delimited by some character or symbol.
Database » Database » Sql
SQLSQL-ServerIntermediate
Tip/Trick 4 Apr 2013   license: CPOL
The script helps to find out upcoming birthdays even when days cross a year.
Database » Database » Sql
SQLSQL-ServerDBAADO.NETBeginner
Article 3 Apr 2013   license: CPOL
Explaining different ways to join tables
Database » Database » Sql
SQLSQL-ServerArchitectDBADevBeginnerIntermediateMySQLOracleGeneral
Tip/Trick 7 Mar 2013   license: CPOL
Converts XML to SQL statements and executes them.
Database » Database » Sql
SQLBeginner
Tip/Trick 7 Mar 2013   license: Public Domain
Mapping table is used in the translation - output in Unicode (nvarchar)
Database » Database » Sql
SQL2000SQLWindowsSQL-ServerDBAIntermediateSQL-Server
Article 17 Feb 2013   license: CPOL
A small C# utility to clear a single contact chat history, since Skype by default only deletes full chat history.
Database » Database » Sql
VistaC#SQLWindowsDBADevIntermediateWindowsWin7
Technical Blog 29 Jan 2013   license: CPOL
Using @@Error within a transaction.
Database » Database » Sql
SQL
Tip/Trick 17 Jan 2013   license: CPOL
This article describes the easiest way to create and process delimited row using SQL XQuery.
Database » Database » Sql
SQL2000SQL2005C#ASP.NETSQLSQL-ServerArchitectDBADevADO.NET, +
Tip/Trick 8 Jan 2013   license: CPOL
It works without affecting schema properties.
Database » Database » Sql
SQL
Tip/Trick 4 Jan 2013   license: CPOL
Grouping dynamically on different columns in single query
Database » Database » Sql
SQL2005SQLWindowsDevIntermediateSQL-ServerSQL2008
Tip/Trick 3 Jan 2013   license: CPOL
CLR-addon for T-SQL DATE transformation and Split-String
Database » Database » Sql
SQL2005SQLSQL-ServerDBADevBeginnerSQL-ServerSQL2008
Tip/Trick 3 Dec 2012   license: CPOL
Create a table from a Varchar list value
Database » Database » Sql
SQLSQL-ServerDevBeginnerSQL-ServerSQL2008
Tip/Trick 1 Dec 2012   license: CPOL
Getting overview of new SQL Server functions
Database » Database » Sql
SQL
Tip/Trick 29 Nov 2012   license: CPOL
Transforming data from row-level data to columnar data.
Database » Database » Sql
SQL
Tip/Trick 26 Nov 2012   license: CPOL
This is an alternative for "Build a Date Function"
Database » Database » Sql
SQLTSQL
Tip/Trick 23 Nov 2012   license: CPOL
Just a function to make populating a datetime variable easier!
Database » Database » Sql
SQLTSQL
Technical Blog 6 Nov 2012   license: CPOL
Create a Cursor using dynamic SQL query.
Database » Database » Sql
SQL
Article 29 Oct 2012   license: CPOL
I will outline a few concepts I believe they shouldn't be forgot each time we combine data from two tables or more.
Database » Database » Sql
SQLDevIntermediate
Tip/Trick 8 Oct 2012   license: CPOL
A simple math formula to get special dates.
Database » Database » Sql
SQLDevIntermediate
Tip/Trick 27 Sep 2012   license: CPOL
Difference between Len() and Datalength().
Database » Database » Sql
SQL
Tip/Trick 23 Sep 2012   license: CPOL
How to find the Lowest Common Ancestor in a tree.
Database » Database » Sql
SQLDBADevIntermediate
Article 13 Sep 2012   license: CPOL
This is an alternative for "SQL Server: Query to find upcoming birthdays for the current week"
Database » Database » Sql
SQLSQL-ServerATLDevIntermediate
Technical Blog 12 Sep 2012   license: CPOL
To find out whose birthday is coming in a given number of days is very simple.
Database » Database » Sql
SQLSQL-ServerATLDevIntermediate
Technical Blog 20 Aug 2012   license: CPOL
Sometimes you need to update data in a table and then update data in another table but based on a filter condition found from the first table. Specifically have you had to do this in the past? This is not …Read more »
Database » Database » Sql
All-Topics
Tip/Trick 15 Aug 2012   license: CPOL
Portable solution encapsulated in single SQL query allows to select N rows offsetting M records
Database » Database » Sql
SQLDevADO.NETIntermediateAccessT-SQL
Article 23 Jul 2012   license: CPOL
A Cancellable threaded query for SQL Server using .net 3.5
Database » Database » Sql
SQL2005C#3.0C#WindowsSQL-ServerDevIntermediateC#SQL-ServerSQL2008, +
Technical Blog 19 Jul 2012   license: CPOL
Auto incremented ID using VARCHAR data type.
Database » Database » Sql
SQL2005SQLDevBeginnerSQL-ServerSQL2008
Tip/Trick 7 Jul 2012   license: CPOL
Describes how to parse and extract key value pairs from a string or column in SQL
Database » Database » Sql
SQLArchitectDevBeginnerIntermediatefunctionTSQL
Tip/Trick 27 Mar 2012   license: CPOL
Return all records between two dates that include time in SQL.
Database » Database » Sql
SQL2005SQLSQL-ServerDevBeginnerSQL2008DateTime
Tip/Trick 15 Mar 2012   license: CPOL
This is an alternative for "LPAD and RPAD functions in SQL"
Database » Database » Sql
SQLWindowsSQL-ServerDBAIntermediateOracle
Tip/Trick 15 Mar 2012   license: CPOL
LPAD and RPAD function works for padding in SQL Server
Database » Database » Sql
SQLWindowsSQL-ServerDBAIntermediateOracle
Article 14 Feb 2012   license: CPOL
Describes two techniques to use when generating dynamic SQL in stored procedures and provides an example that demonstrates what happens when they are combined
Database » Database » Sql
SQLDBAIntermediateServer
Article 6 Feb 2012   license: CPOL
A static method that returns a SqlCommand object with all the parameters for a specific stored procedure
Database » Database » Sql
C#.NETIntermediate
Technical Blog 5 Jan 2012   license: CPOL
Count the records in a table which are of a certain type.
Database » Database » Sql
SQLDevIntermediate
Article 28 Jun 2011   license: CPOL
SQL Table to Managed Type Creator
Database » Database » Sql
C#SQL
Technical Blog 4 Jun 2011   license: CPOL
Why OR conditions in join statements should be avoided and an example fix.
Database » Database » Sql
SQLDBADevBeginner
Technical Blog 25 May 2011   license: CPOL
A discussion of how joins significantly outperform subqueries and how this is more evident when OR conditions are involved.
Database » Database » Sql
SQLdatabasequery
Technical Blog 24 May 2011   license: CPOL
From a utility I'm working on. Compatible with SQL-92 INFORMATION_SCHEMA views.
Database » Database » Sql
SQLdatabasescreen
Technical Blog 23 May 2011   license: CPOL
A discussion about SQL joins and subqueries with information about how to format join statements properly
Database » Database » Sql
SQLdatabasequery
Technical Blog 22 May 2011   license: CPOL
A discussion about a forum post for handling a running subtraction in a SQL query.
Database » Database » Sql
SQLDevIntermediate
Article 12 May 2011   license: CPOL
Most programmers prefer hand-coding database queries. This is a class that automates query building, while the code is as readable as the program logic.
Database » Database » Sql
.NET2.0VS2005VB7.xVB8.0VB9.0VB6VBSQL.NETVisual-Studio, +
Technical Blog 12 May 2011   license: CPOL
Do you find yourself or others doing repetitive tasks? The solution – automate if possible.
Database » Database » Sql
SQLDevBeginner
Technical Blog 12 May 2011   license: CPOL
An example of using a Cartesian [cross] join.
Database » Database » Sql
SQLDBADevBeginner
Article 6 May 2011   license: CPOL
Using FTP via CLR in SQL
Database » Database » Sql
SQLWindowsDBAIntermediate
Article 24 Jan 2011   license: CPOL
The developer's guide to getting the right information out of mountains of data. Learn how to boil down the data into useful information while being confident that you haven't left any data behind.
Database » Database » Sql
SQLWindowsSQL-ServerDBAIntermediateTSQL
Article 14 Jan 2011   license: CPOL
This article explains the new tool in Visual Studio 2010 which most of the users use to see the comparison report of the 2 different database schemas.
Database » Database » Sql
SQL2000SQL2005.NETSQL-ServerVisual-StudioBeginnerIntermediateSQL-ServerVisual-StudioSQL2008, +
Article 11 Jan 2011   license: CPOL
The developer’s guide to writing powerful SQL commands while avoiding the pitfalls that come from an incomplete knowledge of what is going on under the hood.
Database » Database » Sql
SQLDBADevBeginnerTSQL
Article 23 Nov 2010   license: Apache
Provides a framework for predictably compiling, extracting, and deploying a database project.
Database » Database » Sql
SQL2005VS2008C#SQLWindowsArchitectDBADevIntermediateSQL-Server, +
Page 1 of 3
1 2 3
First · Prev · Next · Last


Advertise | Privacy | Mobile
Web04 | 2.6.130513.1 | Last Updated 14 May 2013
Copyright © CodeProject, 1999-2013
All Rights Reserved. Terms of Use
Layout: fixed | fluid