|
|
|
|
|
Total Hits: 0 | Today: 0
|
Author: Paul Yao and David Durant
|
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...
|
|
|
|
Total Hits: 0 | Today: 0
|
Author: Brad King
|
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...
|
|
|
|
Total Hits: 1 | Today: 0
|
Author: brijesh jalan
|
Rating:
|
|
Use the following reference for MySQl
using MySql.Data.MySqlClient;
1.Open the visual Studio
2.Create the new website and save it...
|
|
|
|
Total Hits: 1 | Today: 0
|
Author: atverma
|
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 ...
|
|
|
|
Total Hits: 1 | Today: 0
|
Author: Raymund Macaalay
|
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...
|
|
|
|
Total Hits: 1 | Today: 0
|
Author: pinaldave
|
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....
|
|
|
|
Total Hits: 1 | Today: 0
|
Author: rajeshitpro
|
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...
|
|
|
|
Total Hits: 2 | Today: 0
|
Author: Simon Pang
|
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....
|
|
|
|
Total Hits: 2 | Today: 0
|
Author: hong_wei_li@yahoo.com
|
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?...
|
|
|
|
Total Hits: 2 | Today: 0
|
Author: Neeks
|
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....
|
|
|
|
Total Hits: 2 | Today: 0
|
Author: Malcolm Sheridan
|
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...
|
|
|
|
Total Hits: 2 | Today: 0
|
Author: Suprotim Agarwal
|
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....
|
|
|
|
|
|
