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

Dev Articles
Search Directory
ASP.NET
VB.Net
C-Sharp
SQL Server
 
FREE 12 month online training for ASP.NET & MS Expression Studio and a Free copy of MS Expression Web with Windows Server Purchase

Home > Search > SQL
Search:
What's New - What's Hot
Listings for Applications Applications (138)
Listings for Articles & Samples Articles & Samples (3350)
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 (25)
Listings for Knowledge Base Knowledge Base (296)
Listings for Sample Chapters Sample Chapters (23)
Listings for Training Training (17)
Listings for WebCasts WebCasts (21)


loop through the SQL Server databases and populate the database names in a listbox        
Total Hits: 2  |  Today: 2 Author: Bheema Shankar Maruvada       Rating:  
Read Reviews | Write Review |   Your Rating: 

This article explains about looping through the SQL server databases and displaying the data in a list box so that user can choose the database as one of inputs....

How to use global variable in Microsoft SSIS (DTS) package        
Total Hits: 1  |  Today: 1 Author: hong_wei_li@yahoo.com       Rating:  
Read Reviews | Write Review |   Your Rating: 

Microsoft SQL Server 2005 Integration Services has new interface about DTS ( data transformation service). It has no many helpful examples for developers to follow. One of sticky things is to how to use global variables. Hopefully the following will save you a lot of frustrations.
the scenario is like this:
(1). I want to dump the data from one table (table1, primary key is theId - int, fields are FirstName - varchar(50), LastName - varchar(50)) in database 1 (db1) to another same structur...

One-Many and One-One relationship using LINQ to SQL        
Total Hits: 2  |  Today: 1 Author: Shivprasad koirala       Rating:  
Read Reviews | Write Review |   Your Rating: 

In this article we will start with a basic LINQ to SQL example and then see how we can implement one-many and one-one relationship using ‘Entityref’ and ‘EntitySet’. We have also attached a source which demonstrates the same in a practical manner....

Move DTS Package from one MS SQL Server to another        
Total Hits: 2  |  Today: 1 Author: Haiyan Du       Rating:  
Read Reviews | Write Review |   Your Rating: 

You developed a DTS package. Now you want to move to live SQL sever. you might wondering what the easiest way is to move DTS from you local SQL Sever to the remove SQL Server.

There are serveral ways to move, but I tell you the easiest one.

1. Save your existing DTS Package as a Structure Storage File, lets assum it is called t.dts

2. Copy t.dts to destination Microsoft SQL Server

3. Open Destination SQL server Enterprise Management....

Active Record Pattern Wrapper Using LINQ-to-SQL        
Total Hits: 2  |  Today: 1 Author: Dogu Tumerdem       Rating:  
Read Reviews | Write Review |   Your Rating: 

Today Entity Data Model (EDM) is becoming more popular because of ADO.NET data services compatibility, but LINQ-to-SQL still is simpler and easy to use. In this article, I will present an approach for LINQ to make it ready for Active Record Pattern. And, there is another project on this approach which you can find at http://www.castleproject.org/activerecord/index.html ....

Future of Business Intelligence        
Total Hits: 2  |  Today: 1 Author: Pinal Dave       Rating:  
Read Reviews | Write Review |   Your Rating: 

Business Intelligence (BI) is slated to play bigger roles in all kinds of businesses in the coming years. This is not surprising as data analysis and smarter decision making has made the use of BI inevitable in all sizes of businesses across all sectors, including Real estate, IT, mobile devices, governmental agencies, scientific and engineering communities and R&D labs, banking and insurance, to name a few. BI can effectively deal with industry-specific constraints, operations and objectives th...

How to use global variable in Microsoft SSIS (DTS) package        
Total Hits: 3  |  Today: 1 Author: hong_wei_li@yahoo.com       Rating:  
Read Reviews | Write Review |   Your Rating: 

Microsoft SQL Server 2005 Integration Services has new interface about DTS ( data transformation service). It has no many helpful examples for developers to follow. One of sticky things is to how to use global variables. Hopefully the following will save you a lot of frustrations....

Using SQLDataReader and SQLDataAdapter        
Total Hits: 3  |  Today: 1 Author: Iyad Abu Abdu       Rating:  
Read Reviews | Write Review |   Your Rating: 

The useability and the interaction for the end users with your web form will reflect the term of the success and the completeness for your work,and especially if most of your web forms get and show data from database. we talk to database via a connection ,so your connection will be in the lightweight and have a short time and this dedicated in using SqlDataReader class and your connection will be more efficient in using SQLDataAdapter class....

Custom Scheduler - SQL Server Reporting Services        
Total Hits: 3  |  Today: 1 Author: Soshan Fernandes       Rating:  
Read Reviews | Write Review |   Your Rating: 

I was currently working for a company name Hermz Software which needed to create reports using SQL Server Reporting Services as it's reporting tool. As far as creation of reports is concerned, I didnt have much problems!! However, the delivery of the reports were to be done based on the following snapshots....

SQL SERVER - 2005 Best Practices Analyzer Tutorial - Sample Example        
Total Hits: 3  |  Today: 1 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. I encourage to follow that and once used it create your own reports in your desired format. Do not hesitate to install this add-on as I have use this previously to tune our product...

Reporting Services 2005 101 using Web Client        
Total Hits: 2  |  Today: 1 Author: Asif Sayed       Rating:  
Read Reviews | Write Review |   Your Rating: 

What is your favorite GUI client? Tuff question right, especially, if we�ve choices as Windows/Web and Mobile to pick from. To stay competitive, software vendors are increasingly under pressure to address every possible client under the sun! As I�ve demonstrated in my pervious article, how to host MS Reporting Services 2005 with Windows Forms; this time, I�ll show the similar technique, however, I�m picking on ASP.NET Web Client....

Implementing Audit Trail using Trigger        
Total Hits: 4  |  Today: 1 Author: Shivprasad koirala       Rating:  
Read Reviews | Write Review |   Your Rating: 

There are many ways of doing an audit trail and in one of my previous articles, I had discussed how we can implement audit trail using prototype pattern. In this session, we will discuss how we can implement audit trailing using trigger. We will take up a simple customer table, create a simple audit table and then we will write a generic trigger by which we can audit any kind of table structure data in the audit table....


DevASP.Net - Disclaimer - Privacy
Copyright © 2008 DevASP.net