Search - Articles - Dev Forums - Favorites - Member Login  
DevASP.NET for ASP.NET, VB.NET, XML and C# (C-Sharp) Developers Thursday, July 29, 2010

Dev Articles
Search Directory
ASP.NET
VB.Net
C-Sharp
SQL Server
 

Build the right apps the right way with powerful development tools.
Visual Studio 2010. Learn more...

Home > Search > SQL
Search:
What's New - What's Hot
Listings for Applications Applications (159)
Listings for Articles & Samples Articles & Samples (4472)
Listings for Bugs and Fixes Bugs and Fixes (94)
Listings for Developer Sites Developer Sites (13)
Listings for Downloads Downloads (46)
Listings for Introduction Introduction (27)
Listings for Knowledge Base Knowledge Base (291)
Listings for Sample Chapters Sample Chapters (24)
Listings for Training Training (25)
Listings for WebCasts WebCasts (21)


New Version Lets You Store and Update Data on Handheld Devices    Version: 0.00       Price: $0.00   
Total Hits: 0  |  Today: 0 Author: Paul Yao and David Durant       Rating:  
Read Reviews | Write Review |   Your Rating: 

Handheld device users need to be able to synchronize with a main data store when it's convenient and, preferably, when the back-end database server isn't busy. SQL Server 2000 Windows CE Edition allows you to build a traveling data store that can be displayed and run on a variety of devices. SQL Server CE supports a subset of the full SQL Server package, and can be used as a standalone server or in tandem with SWL Server and IIS. The architecture of SQL Server CE, along with data manipulation, s...

Simplify Distributed System Design Using the Command Pattern, MSMQ, and .NET    Version: 0.00       Price: $0.00   
Total Hits: 0  |  Today: 0 Author: Brad King       Rating:  
Read Reviews | Write Review |   Your Rating: 

These days, discussions about distributed computing and the Microsoft® .NET Framework frequently focus on service-oriented architecture (SOA). But when you want to perform processing inside your local network, the Microsoft Patterns & Practices Enterprise Solution Pattern suggests that object-based collaboration may be more appropriate than service-based collaboration. In the local environment, systems generally share a common platform, allowing you to optimize in ways you can't on widely disper...

MySql database connectivity with ASP.Net    Version: 0.00       Price: $0.00   
Total Hits: 1  |  Today: 0 Author: brijesh jalan       Rating:  
Read Reviews | Write Review |   Your Rating: 

Use the following reference for MySQl

using MySql.Data.MySqlClient;

1.Open the visual Studio

2.Create the new website and save it...

How to unit test SQL Server 2008 database using Visual Studio 2010    Version: 0.00       Price: $0.00   
Total Hits: 1  |  Today: 0 Author: atverma       Rating:  
Read Reviews | Write Review |   Your Rating: 

In this article I’ll discuss about unit testing SQL Server 2008 Database project using Visual Studio 2010. As Unit tests test the part of the program integration testing becomes easier, moreover unit tests help enhancing, maintaining or extending a solution provided they are well written. There is no use to write an unit test badly as later on maintainability of the solution suffers. It either has to be a good unit test or no test at all. It’s better to eliminate bugs early rather than late and ...

A Dynamic Word Template that Generates information from SQL    Version: 0.00       Price: $0.00   
Total Hits: 1  |  Today: 0 Author: Raymund Macaalay       Rating:  
Read Reviews | Write Review |   Your Rating: 

Have you ever wondered how to automatically generate word templates that grabs information from a database? Now why would you do that? In case you have an organization that has a lot of departments or even branches and you want to distribute templates once and manage the data within from a SQL server database like the logo information, address information, or even contact details. This means any change in the information of any branch or department would not entail in updating all of the temp...

SQL SERVER - 2005 Best Practices Analyzer Tutorial - Sample Example    Version: 0.00       Price: $0.00   
Total Hits: 1  |  Today: 0 Author: pinaldave       Rating:  
Read Reviews | Write Review |   Your Rating: 

Yesterday I posted small note about SQL SERVER - 2005 Best Practices Analyzer (July BPA). I received many request about how BPA is used. Some of readers has asked me to provide sample tutorial which can help start using BPA. This utility has many uses for best practice. I have created very simple and initial tutorial....

Use Union All & Select Queries Effectively    Version: 0.00       Price: $0.00   
Total Hits: 1  |  Today: 0 Author: rajeshitpro       Rating:  
Read Reviews | Write Review |   Your Rating: 

Iam going to tell you all the magic of using the union all for the data insertion and how do make a select statement as table and perform joins on it...

dexleapFTC, a full text engine made of pure Stored Procedures    Version: 0.00       Price: $0.00   
Total Hits: 2  |  Today: 0 Author: Simon Pang       Rating:  
Read Reviews | Write Review |   Your Rating: 

To do the full-text search in an MS SQL Server application, you usually have two options:

1. Select Something From SomeTable Where SomeText Like %SomePhrases%.

Or:
2. The SQL Server built-in full text engine....

How to Schedule and Run a SSIS package ( DTS ) Job in SQL Server 2005    Version: 0.00       Price: $0.00   
Total Hits: 2  |  Today: 0 Author: hong_wei_li@yahoo.com       Rating:  
Read Reviews | Write Review |   Your Rating: 

In the SQL Server 2005, after you create a SSIS package ( DTS), you want to create a job and schedule to run it. You will get the error to prevent you to run the job. What is the problem?...

Exclusive access could not be obtained because the database is in use    Version: 0.00       Price: $0.00   
Total Hits: 2  |  Today: 0 Author: Neeks       Rating:  
Read Reviews | Write Review |   Your Rating: 

While you are restoring the database from the backup you might get the error

"Exclusive access could not be obtained because the database is in use". This article will help to overcome this error at the time of restore the database....

Bulk Insert into SQL Server using SqlBulkCopy    Version: 0.00       Price: $0.00   
Total Hits: 2  |  Today: 0 Author: Malcolm Sheridan       Rating:  
Read Reviews | Write Review |   Your Rating: 

I was recently tasked with a project at a company to update an SQL Server 2008 database with large amounts of data each day. The task at first seemed daunting due to the files exceeding well over 400,000 records and there were several that needed processing daily. I first tried LINQ to SQL, but with the amount of data, the inserts were slow performing to say the least. Then I remembered the SqlBulkCopy class. SqlBulkCopy lets you efficiently bulk load a SQL Server table with data from another so...

Querying a Hierarchical Parent-Child Structure in LINQ    Version: 0.00       Price: $0.00   
Total Hits: 2  |  Today: 0 Author: Suprotim Agarwal       Rating:  
Read Reviews | Write Review |   Your Rating: 

I was recently going through the forums and found some developers struggling with queries involving Classes with One-To-Many Relationship. In this article, I will demonstrate how to query a Hierarchical Parent-Child Structure using LINQ....


DevASP.Net - Disclaimer - Privacy
© 2002-2010 DevASP.net