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*
  
2,178 Results

Search



Sort by



Match


Rating Range

Advanced Filters:


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

Category filtered by:  Database [x] | Database [x]
Tip/Trick 14 May 2013   license: CPOL
How to connect to a MySQL database using VB.NET.
Database » Database » Mysql
VB.NETVBVB.NET
Article 13 May 2013   license: CPOL
SQL Server 2000, 2005, 2008, 2008 R2, 2012 Character String Data Types and Functions with Sample SQL Statements. Quick reference, Data Type Tables, Function Tables
Database » Database » Sql Server
SQL2000SQL2005SQLSQL-ServerDBADevBeginnerIntermediateSQL-ServerSQL2008, +
Article 12 May 2013   license: CPOL
Implementation of relative database constraints and permissioning using triggers and shadow tables
Database » Database » Sql Server
SQLSQL-Serverdatabase
Tip/Trick 10 May 2013   license: CPOL
Database » Database » Sql Server
SQLBeginnerIntermediate
Technical Blog 9 May 2013   license: CPOL
Stored Procedure with sorting, paging, and filtering.
Database » Database » Sql
SQL
Tip/Trick 8 May 2013   license: CPOL
Merge in SQL Server 2008.
Database » Database » Sql Server
SQL-Server
Article 8 May 2013   license: CPOL
How to export SQL data to Excel using VB.NET
Database » Database » Utilities
SQLOfficeVBVB.NET
Article 8 May 2013   license: Ms-PL
This is an alternative for "A set of ADO classes - version 2.20"
Database » Database » Ado
VC6Win2KSQLSQL-ServerMFCDBADevADOIntermediateC++, +
Tip/Trick 7 May 2013   license: CPOL
Create a calendar by inputting month
Database » Database » General
SQLDBADevQADesignIntermediate
Technical Blog 7 May 2013   license: CPOL
Difference between SET QUOTED_IDENTIFIERS ON and OFF settings.
Database » Database » Sql Server
SQL
Technical Blog 7 May 2013   license: CPOL
The new Merge statement in SQL Server 2008.
Database » Database » Sql Server
SQLSQL-ServerDBADevBeginner
Tip/Trick 7 May 2013   license: CPOL
Difference between SQL Server Char and Varchar data type.
Database » Database » General
SQL-Server
Tip/Trick 7 May 2013   license: CPOL
How to find all the Stored Procedures having a given text in it.
Database » Database » General
SqlServer
Tip/Trick 7 May 2013   license: CPOL
GO Statement can also be used to excute batch of T-SQL statement multiple times
Database » Database » General
SqlServer
Article 7 May 2013   license: CPOL
Enhance productivity and reliability, write your own tools.
Database » Database » Oracle
C#WindowsArchitectDevWCFWPFIntermediateAdvancedOracle
Tip/Trick 7 May 2013   license: CPOL
Passing a comma separated list of values to an SQL query is all very well, but you can't just use them in an "IN" clause. This helps.
Database » Database » Sql Server
SQL
Tip/Trick 6 May 2013   license: CPOL
This article explains how to calculate the Check Digit Vertical (CDV) and Horizontal (CDH) by Sql Server.
Database » Database » Sql Server
WinXPWin2003VistaSQL2005SQLWindowsSQL-ServerDBAWindowsSQL-Server, +
Article 5 May 2013   license: CPOL
CAST(), CONVERT(), PARSE(), TRY_PARSE(), TRY_CONVERT(), FORMAT(), SQL Server Functions, SQL Server Functions that helps to convert date and time values to and from string literals and other date and time formats.
Database » Database » Sql Server
SQL2000SQL2005SQL-ServerDevBeginnerIntermediateSQL-ServerSQL2008SQL2008R2SQL2012
Article 5 May 2013   license: CPOL
This library is intended to "replace" ADO.NET by solving type mismatches and by creating typed readers that are faster and easier to use than DataTables.
Database » Database » Ado.Net
C#.NETArchitectDevADO.NETIntermediateAdvancedC#.NETC#4.0, +
Tip/Trick 3 May 2013   license: CPOL
How to prevent SQL injection attacks when using dynamic SQL in stored procedures
Database » Database » Sql Server
SQLSQL-ServerIntermediateSQL-ServerSQL2008
Tip/Trick 3 May 2013   license: CPOL
Beware of What We Ask Them to Do
Database » Database » General
SQLSQL-ServerDevBeginnerIntermediate
Technical Blog 3 May 2013   license: CPOL
Background In my last post I showed how to split a string in TSQL. Problem with that splitting is it can split a string if resultant split count is
Database » Database » Sql Server
SQLWindowsSQL-ServerArchitectDBADevBeginnerIntermediateAdvancedSysAdmin
Technical Blog 3 May 2013   license: CPOL
Background When you see the your database in Suspect mode that a code red situation. Its not something that you face everyday. It can happen, however, most often due to faulty hardware or operational mistakes (like deleting a transaction log file). This post will show how to recover from suspect mod
Database » Database » Sql Server
WindowsSQL-ServerDevIntermediateAdvancedSQLSysAdmin
Article 2 May 2013   license: CPOL
SQL Server 2000, 2005, 2008, 2008 R2, 2012 Date and Time Data Types and Functions with Sample SQL Statements. Data Type Tables, Function Tables
Database » Database » Sql Server
SQL2000SQL2005SQLSQL-ServerDevBeginnerIntermediateSQL-ServerSQL2008SQL2008R2, +
Technical Blog 2 May 2013   license: CPOL
This post shows how to insert a comma-separated string into multiple rows in a table in SQL Server.
Database » Database » Sql Server
SQL2005SQL.NETDevIntermediateSQL-Server
Tip/Trick 2 May 2013   license: CPOL
How to avoid the Cursor in Stored Procedures
Database » Database » Mysql
SQLWindowsDBAIntermediateMySQL
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
Article 29 Apr 2013   license: CPOL
One of the things that drew me to SQL Server 2012 was the FileTable feature. It seemed to be a great fit for my need, and to relatively easy to implement. Here’s my scenario, the solution I chose, the “gotchas” I ran into, and how I dealt with them.
Database » Database » Sql Server
SQLSQL-ServerDBAAdvanced
Article 28 Apr 2013   license: CPOL
NoSql, JSON based, Document store database with compiled .net map functions and automatic hybrid bitmap indexing and LINQ query filters (now with standalone Server mode, Backup and Active Restore, Transactions, Server side queries, MonoDroid support)
Database » Database » Other Databases
C#.NETArchitectDBADevWebFormsBeginnerIntermediateAdvancedWeb-Development, +
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
Article 24 Apr 2013   license: CPOL
An article that lists the steps to import MDF files to Microsoft Access
Database » Database » General
SQLAccess
Article 24 Apr 2013   license: CPOL
Create a SQL Server database using C#.
Database » Database » Sql Server
.NET1.1Win2KSQL2000VS.NET2003C#SQLDBADevIntermediateWindows, +
Tip/Trick 24 Apr 2013   license: CPOL
Custom StringPadding functions for SQL Server
Database » Database » Sql Server
SQL2000SQL2005SQLSQL-ServerBeginnerIntermediateSQL-ServerSQL2008
Article 21 Apr 2013   license: CPOL
Dynamically add access database columns at runtime using vb.net
Database » Database » Databases
.NET3.5VBSQLWindows.NETIntermediateVB.NETAccessdatabase, +
Article 19 Apr 2013   license: CPOL
This article will definitely give you a brief idea about cursor with examples.
Database » Database » Oracle
WindowsBeginnerOracle
Tip/Trick 19 Apr 2013   license: CPOL
The TOP clause is commonly used to get the top required rows from a result set. The beauty of this clause is that it can be used with the WITH TIES clause to retrieve all similar rows to a base result set.
Database » Database » Sql Server
SQL2005SQL-ServerSQL-ServerSQL2008SQL2012
Tip/Trick 19 Apr 2013   license: CPOL
Restore failure from Enterprise to Standard edition in SQL Server.
Database » Database » Sql Server
SQL2005SQL-ServerSQL-ServerSQL2008
Tip/Trick 19 Apr 2013   license: CPOL
Automatic query execution at every instance startup.
Database » Database » Sql Server
SQL2005SQL-ServerDBASQL-ServerSQL2008SQL2012
Technical Blog 18 Apr 2013   license: CPOL
This DMV allows you to discover a lot of very interesting and important performance information about your cached stored procedures.
Database » Database » Sql Server
SQL-ServerSQL2008
Tip/Trick 18 Apr 2013   license: CPOL
To avail Danish language as a language breaker in full text search index option, it has to be enabled manually by adding a registry key for the Danish language.
Database » Database » General
DBABeginnerSSRS
Tip/Trick 15 Apr 2013   license: CPOL
Without transaction if any DML statement are executed in the database then that can be rolled back in sql server.
Database » Database » Sql Server
SQLADO.NET
Tip/Trick 15 Apr 2013   license: CPOL
How to Encrypt And Decrypt a field without writing any frontent code .
Database » Database » Mysql
WindowsIntermediateSQLMySQLEncryptionDecryption
Technical Blog 13 Apr 2013   license: CPOL
Background Say we have a registration table which store successful registration info. At that table we have a column “Name” which stores value as combination of first name & last name delimited by ‘ ‘ [space]. Later at some point we need to extract the first name or last name
Database » Database » Sql Server
SQLWindowsSQL-ServerArchitectDevBeginnerIntermediateAdvanceddatabasesplitter, +
Article 11 Apr 2013   license: CPOL
This document evaluates the latest functionality provided by Microsoft SQL Server 2012 With Power View for Multidimensional Models and not just Tabular Models.
Database » Database » Sql Server
SQLSharepointServerpowerview2013
Article 8 Apr 2013   license: CPOL
How to effectivley version your SQL Server databases using SQL Server Data Tools
Database » Database » Sql Server
SQLWindowsSQL-ServerDBADevIntermediate
Tip/Trick 8 Apr 2013   license: CPOL
Term Lookup is the one of the powerful Transformations in SQL Server Integration Service. This transformation basically helps to analyze the set of text records.
Database » Database » Sql Server
SQL-ServerDevIntermediate
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
Technical Blog 4 Apr 2013   license: CPOL
Oracle tables have no built-in mechanism for auto numbering. Instead, you must create a separate unique Sequence object and use it each time a record is inserted into the database.
Database » Database » General
SQL-ServerDBAOracle
Article 3 Apr 2013   license: CPOL
Explaining different ways to join tables
Database » Database » Sql
SQLSQL-ServerArchitectDBADevBeginnerIntermediateMySQLOracleGeneral
Article 3 Apr 2013   license: CPOL
How to configure database mail in SQL Server 2008
Database » Database » Sql Server
SQL-ServerDBA
Page 1 of 44
1 2 3 4 5 6 7 8 9 10
First · Prev · Next · Last


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