Search - Articles
DevASP.NET for ASP.NET, VB.NET, XML and C# (C-Sharp) Developers Tuesday, March 03, 2009
Dev Articles
Search Directory
ASP.NET
VB.Net
C-Sharp
SQL Server
 


Home >Search > Articles & Samples > SQL Server > Database Design


Search:
What's New - What's Hot
Doing Bulk Upload/Insert of DataTable to a Table in SQL server in C#  Version: 0.00     Price: $0.00  
Total Hits: 10  |  Today: 0Author: Bala Murugan      Rating:  
Read Reviews | Write Review |  Your Rating: 

There will be requirements where we need to import the content of a DataTable object to a table in SQL server. Normally, we will do this by forming separate insert query for each data row in DataTable and firing it over the SQL server using ADO.Net. This approach will be an over head and time consuming when the data in the source DataTable is huge. It will be fast and better, if we can do a bulk upload of the whole DataTable object to the SQL Server table in single shot. Understanding this, Mic...

A Small Utility to Generate Cascading Delete SQL Script in Oracle  Version: 0.00     Price: $0.00  
Total Hits: 7  |  Today: 0Author: ronald.cao@gmail.com      Rating:  
Read Reviews | Write Review |  Your Rating: 

Recently I was doing data fixes for my client, which required to delete data in tens of tables. There tables have reference tables, which have reference tables, which have reference tables ... To delete a table, I had to delete its reference tables first, to delete its reference tables, I had to delete the reference tables' reference tables first and so on. In one case, there are six levels deep and 220 tables to delete first in strict order. I created the utility to generate the cascading delet...

How To Store Any File into SQL Database  Version: 0.00     Price: $0.00  
Total Hits: 12  |  Today: 0Author: Md. Marufuzzaman      Rating:  
Read Reviews | Write Review |  Your Rating: 

Recently I completed a project where I need to store various files, i.e. Microsoft Office file formats, PDF, Images, etc.). When I started writing code, I wrote a function to store binary, after that I thought why not use direct bulk insert from a StoredProcedure....

DataBase Transaction  Version: 0.00     Price: $0.00  
Total Hits: 5  |  Today: 0Author: Syedshakeer      Rating:  
Read Reviews | Write Review |  Your Rating: 

A transaction begind when the first DML statement is encountered and ends when one of the following occurs:



1. A COMMIT or ROLLBACK statement is issued
2. A DDL statement such a CREATE is issued
3. A DCL statement is issued...

Generate SQL Database Schema from XML - Part 2 (Code Model)  Version: 0.00     Price: $0.00  
Total Hits: 6  |  Today: 0Author: Stephen Boissiere      Rating:  
Read Reviews | Write Review |  Your Rating: 

This is the second in a series of three articles describing a project that I undertook to solve a specific problem in my working environment. The first article explained how I was dissatisfied with SQL's Data Definition Language, and decided to create an alternative based on XML. By the end of the article I had presented an XSD for the new format....

Restoring SQL Server Express 2008 Database with Click Once  Version: 0.00     Price: $0.00  
Total Hits: 10  |  Today: 0Author: Ferhat_Karatas      Rating:  
Read Reviews | Write Review |  Your Rating: 

I'm going to tell you something that funny. As you know, you could install required prerequisites with Click Once. Framework, Windows Installer or SQL Server Express 2008. But, Visual Studio 2010 does not support restoring DB over SQL Server 2005 or 2008. You could not find complete reference guide about this issues on internet. There is much more article regarding Click Once, Bootstrapper Manifest Generator or Setup Project. Here we go I tell you step by step every part of this project in singl...

Generating INSERT statements in SQL Server  Version: 0.00     Price: $0.00  
Total Hits: 5  |  Today: 0Author: Sumit Amar .      Rating:  
Read Reviews | Write Review |  Your Rating: 

SQL Server doesn?t allow generation of INSERT statements for the table data, when Generate SQL Script option is selected. The workaround is to make use of DTS for transferring data across servers. However, there exists a need to generate INSERT statements from the tables for porting data. Simplest example is when small or large amount of data needs to be taken out on a removable storage media and copied to a remote location, INSERT..VALUES statements come handy....

Transferring data from SQL Server database to MySql database  Version: 0.00     Price: $0.00  
Total Hits: 9  |  Today: 0Author: SheoNarayan      Rating:  
Read Reviews | Write Review |  Your Rating: 

My problem was that I had a Sql Server database at my webserver and I had to migrate its data for any reason to my MySql database table that had the same table structure as the Sql Server had. As I didn't had enough permission on Server to use DTS or other type of services to directly transfer my data to MySql so I had one option left that is to write a code that can get all data from Sql Server and transfer into MySql database....

SQL Server CE: New Version Lets You Store and Update Data on Handheld Devices  Version: 0.00     Price: $0.00  
Total Hits: 5  |  Today: 0Author: 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...

MySql database connectivity with ASP.Net  Version: 0.00     Price: $0.00  
Total Hits: 14  |  Today: 0Author: 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...

Read Data From XML File in SQL Server  Version: 0.00     Price: $0.00  
Total Hits: 9  |  Today: 0Author: Lakhan Pal Garg      Rating:  
Read Reviews | Write Review |  Your Rating: 

sp_xml_preparedocument - Reads the XML text provided as input (@XMLDATA) ,
the xml text and returns a handle that can be used to access the newly created internal representation of the XML document. The output of this procedure is XML handle that is
used for OPENXML command....

SQL Server 2008 New DATETIME DataTypes  Version: 0.00     Price: $0.00  
Total Hits: 24  |  Today: 0Author: Dinesh Asanka      Rating:  
Read Reviews | Write Review |  Your Rating: 

SQL Server 2008 has arrived - not fully, but as a CTP version. Whenever you hear about new software, the first and most obvious question is “What are the new features?”. There are many new features and facilities in SQL Server 2008. This article is going to cover the newly introduced data types in SQL Server 2008 July CTP, and will specifically discuss the DATETIME functions....

Database Compare     
Total Hits: 91  |  Today: 0Author: Annael Samwel      Rating:  
Read Reviews | Write Review |  Your Rating: 

Database compare is an application which used to comapare
two sqlserver databases. the foolowing are steps which used to manage
Database comparing.
1. Run application
2. Enter Server Name, Database Name, User
name and Password of the master database which used to compare from then click connect
3. Enter the server and other requirement of the compared database click connect
4. Click compare database.
5. You will sql statement in the textbox
6. You can click Save to sav...

Deleting duplicate rows when there is no primary key on a SQL Server database table     
Total Hits: 190  |  Today: 0Author: Edgewood Solutions Engineers      Rating:  
Read Reviews | Write Review |  Your Rating: 

Every once in awhile a table gets created without a primary key and duplicate records get entered. The problem gets even worse when you have two identical rows in the table and there is no way to distinguish between the two rows. So how do you delete the duplicate record? One option that SQL Server gives you is the ability to set ROWCOUNT which limits the numbers of records affected by a command. The default value is 0 which means all records, but this value can be set prior to running a comm...

Accessing Database And Displaying Images Using Windows PowerShell     
Total Hits: 212  |  Today: 0Author: AzamSharp      Rating:  
Read Reviews | Write Review |  Your Rating: 

PowerShell is the new shell introduced by Microsoft. PowerShell allows you to write scripts that can perform various tasks. These tasks include moving data between servers, deploying applications, displaying data etc. In this article I will demonstrate how to fetch data from the database using PowerShell. This article will allow cover how to display images in the windows form using PowerShell....

LINQ to SQL (Part 5 - Binding UI using the ASP:LinqDataSource Control)     
Total Hits: 265  |  Today: 0Author: Scott Guthrie      Rating:  
Read Reviews | Write Review |  Your Rating: 

In this article, scott examines the usage of LinqDataSource Control with the help of an example.
Over the last few weeks I've been writing a series of blog posts that cover LINQ to SQL. LINQ to SQL is a built-in O/RM (object relational mapper) that ships in the .NET Framework 3.5 release, and which enables you to easily model relational databases using .NET classes. You can use LINQ expressions to query the database with them, as well as update/insert/delete data....

Combining Web Services and SQL Server Data Utilizing Business Objects Business View Manager - Part 1     
Total Hits: 578  |  Today: 0Author: Eric Landes      Rating:  
Read Reviews | Write Review |  Your Rating: 

Eric walks the user through comgining different data sources including Web Services into a Crystal Report. To do this Eric utilizes Business objects Business View Manager to combine this and in Part 1 he demonstrates how to set up the web Service for View Manager....

Avoid Max Open Cursor Error In .NET     
Total Hits: 63  |  Today: 0Author: Vivek Shaurya.      Rating:  
Read Reviews | Write Review |  Your Rating: 

Generally, while working with Microsoft technologies, MS-SQL Server comes out as a natural choice for the database. While it’s a fact that the .NET framework has extensive support for SQL Server, when you work with other databases like Oracle, the situation might turn out to be a little more tricky than it is with MS-SQL....

QuickQuery - a database querying tool     
Total Hits: 128  |  Today: 0Author: BlackDice.      Rating:  
Read Reviews | Write Review |  Your Rating: 

QuickQuery is the second program I wrote on my own in C++, just to experiment. It was an attempt to make an app that could run queries on any type of database. This code was written using VC6 and has been run on Windows 2000 and XP....

Time remaining of Database Shrink  Version: 0.00     Price: $0.00  
Total Hits: 175  |  Today: 0Author: wizardzz      Rating:  
Read Reviews | Write Review |  Your Rating: 

I found a stored procedure already in my database (via legacy), and modified it to display remaining seconds and lapsed seconds....


1  2  3  4  5  6  7  8  9  10  Next >> 


Disclaimer - Privacy
© 2002-2017 DevASP.net