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*
  
846 Results

Search



Sort by



Match


Rating Range

Advanced Filters:


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

Category filtered by:  Database [x] | Database [x] | General [x]
Technical Blog 14 May 2013   license: CPOL
Simply run the script and then every time SQL is restarted all your Identity columns will be reset to the latest available seed.
Database » Database » General
SQL
Tip/Trick 7 May 2013   license: CPOL
Create a calendar by inputting month
Database » Database » General
SQLDBADevQADesignIntermediate
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
Tip/Trick 3 May 2013   license: CPOL
Beware of What We Ask Them to Do
Database » Database » General
SQLSQL-ServerDevBeginnerIntermediate
Article 24 Apr 2013   license: CPOL
An article that lists the steps to import MDF files to Microsoft Access
Database » Database » General
SQLAccess
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
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 28 Mar 2013   license: CPOL
How to execute multiple long running SQL Statement Asynchronously in smaller chunks
Database » Database » General
Win2KWinXPWin2003VistaSQL2000SQL2005SQLWindowsSQL-ServerArchitect, +
Article 25 Mar 2013   license: CPOL
How to connect to database using AngularJS
Database » Database » General
C#ASP.NETJavascriptIntermediate
Technical Blog 20 Feb 2013   license: CPOL
An attempt was made to load a program with an incorrect format sqlite
Database » Database » General
SQL
Tip/Trick 19 Feb 2013   license: CPOL
A simple way to import data from csv file to database
Database » Database » General
C#ASP.NET.NETDevBeginnerIntermediateAdvanced.NET.NET4
Technical Blog 17 Feb 2013   license: CPOL
Recently I have answered one of the SQL based question in the CodeProject. Thanks for the participant that question wake up me to write this blog post. Question: He has a table (tblLeave) with the data like below. And he wants to output the data as below Condition: If same type of leave taken contin
Database » Database » General
SQL2005SQLSQL-ServerDBASQL-ServerSQL2008SQL2012
Tip/Trick 16 Feb 2013   license: CPOL
Create the following table on a local database:CREATE TABLE [dbo].[TB_TEMP_TABLESTORE]( [SEARCH_STRING] [nvarchar](128) NULL, [DB_NAME] [nvarchar](128) NULL, [OBJECT_NAME] [nvarchar](128) NULL, [OBJECT_TYPE] [nvarchar](50) NULL) ON [PRIMARY]Rename Yourdatabase to the same...
Database » Database » General
SQL-Server
Article 3 Feb 2013   license: CPOL
Database script execution with unit test
Database » Database » General
SQLSQL-ServerArchitectDBADevQAIntermediate
Technical Blog 30 Jan 2013   license: CPOL
We often model interconnected data by cramming it in and out of table structures. Why don’t we simply model interconnected data as … interconnected data?
Database » Database » General
JavadatabaseAlgorithms
Tip/Trick 2 Jan 2013   license: CPOL
HTML table to SQL table conversion.
Database » Database » General
SQL2000SQL2005SQL-ServerSQLSQL-Server
Article 23 Dec 2012   license: CPOL
Smallest full text search engine (lucene replacement) built from scratch using inverted WAH bitmap index, highly compact storage, operating in database and document modes
Database » Database » General
C#BeginnerIntermediateAdvancedsearch
Technical Blog 19 Dec 2012   license: CPOL
We can achieve a professional database design by avoiding a few pitfalls and following some guidelines but still, these are only guidelines and not an exact rule-set which can guarantee a professional database.
Database » Database » General
DBAIntermediate
Article 12 Dec 2012   license: CPOL
Automated process of downloading a XML file and inserting the contents into a database.
Database » Database » General
C#SQLWindows.NETDBADevADO.NETDesignBeginnerIntermediate, +
Technical Blog 27 Nov 2012   license: CPOL
If there's anything worse than working with legacy code, it's working with Legacy databases. At least with legacy code if you're lucky you can ring-fence it off and ignore it when not working on it, but poorly designed databases can infect a whole system and create a situation where your new code st
Database » Database » General
NHibernate
Tip/Trick 20 Nov 2012   license: CPOL
Linking to an existing SQLDB in ASP MVC4.0 and EF5.x.
Database » Database » General
SQLMVC4
Article 13 Nov 2012   license: CPOL
Access Stored Procedures using Code First.
Database » Database » General
C#.NETSQL-ServerDevIntermediate
Answer 7 Nov 2012   license: CPOL
Finally,I find that the functions used while using VC++ to operate Access DataBase with ADO are the same in ASP.And all the elementary mathmatics functions can be used.(For example:power()->"^";ln()->"log()")Thanks!!!
Database » Database » General
ADOC++VC9.0
Article 30 Oct 2012   license: CPOL
Implement Repository, UnitOfWork with Audit support in Composable Service End
Database » Database » General
C#ArchitectDevADO.NETDesignBeginnerIntermediateAdvanced
Technical Blog 19 Oct 2012   license: CPOL
How to resolve this iisue.
Database » Database » General
SQLDBADevIntermediate
Article 10 Oct 2012   license: CPOL
The fifth incarnation of a dynamic and self-adaptive ORM library with full support for POCO objects, that doesn’t require any mapping or configuration files, and with support for natural SQL-like syntax in plain C#
Database » Database » General
C#SQL.NETSQL-ServerArchitectDBADevADOADO.NETLINQ, +
Technical Blog 2 Oct 2012   license: CPOL
I expect that most people with skin in the game will not be serious NoSQL users for a while. This should not discourage developers and architects from experimenting with various NoSQL DBMS now, so as to make choices based on knowledge.
Database » Database » General
ArchitectDBAIntermediate
Tip/Trick 27 Sep 2012   license: CPOL
Why? Normally, it's because you stored it wrong...
Database » Database » General
C#SQL-ServerBeginner
Article 24 Sep 2012   license: CPOL
An extension to the Kerosene ORM library that permits seamless database operations in WCF scenarios
Database » Database » General
C#SQLWindows.NETSQL-ServerArchitectDBADevADO.NETWCF, +
Article 24 Sep 2012   license: CPOL
Extending the Kerosene ORM library to include a dynamic and configuration-less Entity Framework built for POCO objects.
Database » Database » General
SQLWindowsSQL-ServerDevLINQIntermediateAdvancedC#.NETC#4.0, +
Tip/Trick 23 Sep 2012   license: CPOL
Inserting a number of rows in a database isn't difficult, but how do you do it in a single command without concatenating strings?
Database » Database » General
C#SQL-ServerIntermediate
Technical Blog 21 Sep 2012   license: CPOL
Some of my friends requested me to make a tutorial about Oracle database and C#. This time, I’d like to share about how to Save Image/Picture from C# Object into Oracle Blob Type. It’s very easy if you know the trick. In this tutorial, I don’t like to make this from zero, so, I’m using my framework
Database » Database » General
C#Oracle
Technical Blog 21 Sep 2012   license: CPOL
In my last tutorial (about bind oracle blob image in WPF), I showed you how to bind from Oracle BLOB into Image in WPF. But, there is a different trick if you use Windows Form Application (in this case, we’re using PictureBox component). There is nothing different in concept, but the problem is alwa
Database » Database » General
Oracle
Article 7 Sep 2012   license: CPOL
ORDER BY what-the-user-said
Database » Database » General
C++SQL
Tip/Trick 7 Sep 2012   license: CPOL
This tip will explain how to sort a column inside a table.
Database » Database » General
DBABeginnerSQLMySQL
Article 30 Aug 2012   license: CPOL
This video explains conditional split transformation for SSIS.
Database » Database » General
SSIS
Article 30 Aug 2012   license: CPOL
This SSIS training video will explain data viewers.
Database » Database » General
SSIS
Article 29 Aug 2012   license: CPOL
The purpose of this tutorial is to provide an introduction of SSIS items.
Database » Database » General
BeginnerAll-TopicsSSIS
Tip/Trick 21 Aug 2012   license: CPOL
Creating SQL database backups through batch scripts and SQL scripts.
Database » Database » General
SQLDBADevIntermediate
Article 20 Aug 2012   license: CPOL
Using a script transform with C# to convert Julian (ordinal?) dates for a date dimension.
Database » Database » General
C#SQLWindows.NETSQL-ServerVisual-StudioDBADevIntermediateSQL-Server, +
Article 16 Aug 2012   license: CPOL
Framework makes application more organized and efficient way to coding. It is helpful for newly assigned developer to understand code structure within a short time. It is essential for large application.
Database » Database » General
WinXPVistaSQL2000SQL2005SQLWindowsSQL-ServerCEOArchitectDev, +
Article 9 Aug 2012   license: CPOL
This article provides a program to measure the performance of the different transaction isolation levels. It also examines the effect of using the UPDLOCK hint in SQL.
Database » Database » General
SQLDevIntermediate
Article 7 Aug 2012   license: CPOL
This video introduces Package Configurations to the SSIS developers, you will learn: XML Configuration a.) Direct b.) Indirect (Using Environment Variables), Environment Variables, and SQL Server Configuration
Database » Database » General
SSIS
Article 7 Aug 2012   license: CPOL
This is a very simple and brief video on variables, expression and casting of them in SSIS. It will also teach developers to pass result sets in SQL task.
Database » Database » General
SQLSSIS
Tip/Trick 27 Jul 2012   license: CPOL
Database » Database » General
VB.NETDBAIntermediateVBMySQLVB.NET
Tip/Trick 27 Jul 2012   license: CPOL
Convert csv file to a data table
Database » Database » General
VB.NETDevVBVB.NET
Tip/Trick 29 Jun 2012   license: CPOL
This is an alternative for "Find all Stored Procedures having a given text in it"
Database » Database » General
SqlServer
Article 25 Jun 2012   license: CPOL
This article demonstrates how to implement a parse function within a C# WPF application.
Database » Database » General
C#SQL-ServerDBADevIntermediate
Page 1 of 17
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