It is not easy to divide computer applications into any exact categories. At present there is no clear definition available to categorize computer applications. Even though here is a small list of different types of computer applications.
1. Embedded Systems
2. Windows applications (also called 'Desktop applications')
3. Web Applications
4. Web Services
5. Console applications
Embedded Systems:
When we save a name, address and other information in to our Mobile Phone or Digital Diary, You know
How it gets saved in it? Nothing but which is a small computer program 'Embedded’ into a chip in the device inside the mobile phone or digital diary known as Embedded Systems.
Windows applications:
Windows Applications is a form based standard Windows, Microsoft word; Paint is example to the Windows application, and also called 'Desktop applications'.
Web Applications:
A web site is also called 'web Applications'. A web applications is a collection of web pages hosted on a special computer called 'web server'. Web server can be located anywhere and visitors can be located anywhere .It will work through Browsers (EG. Internet Explorer, Mozilla, Netscape).
Web Services:
Web services are web applications that give services to other applications through the internet, example Google search engine, Yahoo Search engine etc. which allows other applications to delegate the task of searching over the internet
Console application:
Console applications runs inside the command prompt i.e. DOS window, It is a light weight program and which is used commonly for test applications.
Friday, November 6, 2009
Tuesday, November 3, 2009
New Features in SQL Server 2008
Data Compression wizard
By Data Compression wizard configuration is easy and it helps to save disk storage, for each and every individual tables or indexes compression option is enabled, compression can improve disk I/O and memory utilization.
Upgrade Adviser
These reports provide links to technical information that assist in addressing upgrade problems and it provides administrators detailed information that can be used to prepare for upgrades.
Server Group Management
Here servers do not need to be configured individually, due to management is centralized. Stream results of multi-server queries into a single result set or into multiple result sets are possible.
Data Auditing
By this new feature we can audit logons, password changes, data access and modification etc. audit results can be saved in to file or in to the Windows Security or Application logs for later analysis or archiving.
Streamlined Installation
Independent SQL Server components, such as Database Services, Analysis Services, and Integration Services, can be optionally selected for installation. SQL Server 2008 installation process is to be easier and more efficient.
Table-Valued Parameters
To the Developers it reduces complexity and simplifies the process of working with data sets and data tables. It allows stored procedures to accept and return lists of parameters so here Developers can write applications that pass sets of data into stored procedures rather than just one value at a time.
CLR Enhancements
User-defined aggregates (UDAs) and User-defined types (UDTs) now enhanced up to 2GB of data and can accept multiple inputs. Using UDAs and UDTs with larger data since 8KB size limit restriction has been removed.
Design Alerts
Design mistakes are underlined in blue; this is similar to spelling mistakes are underlined in red in Microsoft Word. And now we can see the full explain of warning by placing our arrow on the underlined object, and can disable AMO warnings if you choose.
External Key Management
It gives option to storing the keys separately from the data which ensures to more extensible and robust security architecture so helps organizations comply with data privacy regulations.
DATE / TIME Data Types
DATETIME2 refer Coordinated Universal Time (UTC) instead of the system time for greater accuracy and the new DATETIMEOFFSET data type gives time zone support by storing date, time and offset such as ‘plus 5 hours’.
By Data Compression wizard configuration is easy and it helps to save disk storage, for each and every individual tables or indexes compression option is enabled, compression can improve disk I/O and memory utilization.
Upgrade Adviser
These reports provide links to technical information that assist in addressing upgrade problems and it provides administrators detailed information that can be used to prepare for upgrades.
Server Group Management
Here servers do not need to be configured individually, due to management is centralized. Stream results of multi-server queries into a single result set or into multiple result sets are possible.
Data Auditing
By this new feature we can audit logons, password changes, data access and modification etc. audit results can be saved in to file or in to the Windows Security or Application logs for later analysis or archiving.
Streamlined Installation
Independent SQL Server components, such as Database Services, Analysis Services, and Integration Services, can be optionally selected for installation. SQL Server 2008 installation process is to be easier and more efficient.
Table-Valued Parameters
To the Developers it reduces complexity and simplifies the process of working with data sets and data tables. It allows stored procedures to accept and return lists of parameters so here Developers can write applications that pass sets of data into stored procedures rather than just one value at a time.
CLR Enhancements
User-defined aggregates (UDAs) and User-defined types (UDTs) now enhanced up to 2GB of data and can accept multiple inputs. Using UDAs and UDTs with larger data since 8KB size limit restriction has been removed.
Design Alerts
Design mistakes are underlined in blue; this is similar to spelling mistakes are underlined in red in Microsoft Word. And now we can see the full explain of warning by placing our arrow on the underlined object, and can disable AMO warnings if you choose.
External Key Management
It gives option to storing the keys separately from the data which ensures to more extensible and robust security architecture so helps organizations comply with data privacy regulations.
DATE / TIME Data Types
DATETIME2 refer Coordinated Universal Time (UTC) instead of the system time for greater accuracy and the new DATETIMEOFFSET data type gives time zone support by storing date, time and offset such as ‘plus 5 hours’.
New features in Visual Studio 2008
Microsoft introduces new features in Visual Studio 2008, such as below:
AJAX Controls
The AJAX client-based and server-based approach gives us the following controls; it helps to create a web application that features of next-generation user interfaces and reusable of client components. Controls are:
• Script Manager
• Update Panel
• Update Progress
• Timer controls.
Now is possible to create rich client behavior, such as update progress during a post back, page rendering etc. with small or no client script.
WPF (Windows Presentation Foundation) Support
In Visual Studio 2008, Windows Presentation Foundation (WPF) applications have been introduced and it has four WPF project types:
• WPF Application
• WPF Browser Application
• WPF Custom Control Library
• WPF User Control Library
Web Application Project Design Support
Project Designer was included in Visual Studio 2008. The Setting Page and signing page of Project Designer supports in many designing aspects.
To access the Settings page, select project node in Solution Explorer, and then, on the Project menu, click Properties. When the Project Designer appears, click the Settings tab.
Deployment by Click Once
Web Applications are hosted in a Web browser therefore it requires special deployment and security settings, when we build and deploy applications by using Click Once, Visual Studio will provide appropriate user interface and default values for this. Now it enhances to build and deploy Visual Studio Tools for applications by using the Project Designer's Publish page or the Publish Wizard.
Multiple Processor Support
Now MS Build accepts, a system is using multiple processors, either multi core processors or multiple separate processors. MS Build will utilize all the available processors to reduce the overall build time of the projects. Logging also upgraded for handling multi-processor build. The file names and locations of the Build assemblies are updated as below:
• Microsoft.Build.Conversion.v3.5.dll
• Microsoft.Build.Utilities.v3.5.dll
• Microsoft.Build.Tasks.v3.5.dll
And, also the following build assemblies are now located in \Program Files\Reference Assemblies\Microsoft\Framework\v3.5\:
• Microsoft.Build.Conversion.v3.5.dll
• Microsoft.Build.Engine.dll
• Microsoft.Build.Framework.dll
• Microsoft.Build.Utilities.v3.5.dll
JavaScript Intelligence / Debugging supports
Visual Studio 2008 contains intelligence support for java script.
It makes developers work easy when they do client side validation, AJAX applications and also when doing Silver light applications also.
Multi languages
In VS2008 Microsoft have introduced the MUI (Multilingual User Interface Architecture), which supports nine languages, which is English, Spanish, French, German, Italian, Chinese Simplified, Chinese Traditional, Japanese, and Korean.This supports the user to change the text language display as their wish.
Data Repeater Control
The new Data Repeater control helps to display rows of data in a scrollable container. This control gives more flexibility compare to standard grid control. The Data Repeater control displays a group of related controls by creating multiple instances in a scrollable manner which ensures to users to view several records at a time. When to display large amounts of data’s, we can set the Virtual Mode property is True, to display a subset of the available data. Virtual mode requires the implementation of a data cache and must control all interactions with the data cache at run time. It contains controlling the ability to add and delete records, adding search capabilities, and displaying related data in a master and detail format etc.
Reports / PDF Compression
When we create a new Reports Application project or ASP.NET Reports Web Site, The Report Wizard is started automatically, now we can use this wizard to build the report which gives guidelines by the steps to create a basic report. Now we can select a report data source, define a data set, select a report type (tabular or matrix), and apply a style to report. After we complete the wizard, we can enhance the report through using Report Designer , or alternatively, close the wizard and build the report manually.
In VS2008 the Report Viewer controls will now compress reports which are exported to the PDF format when they are configured for local processing.
AJAX Controls
The AJAX client-based and server-based approach gives us the following controls; it helps to create a web application that features of next-generation user interfaces and reusable of client components. Controls are:
• Script Manager
• Update Panel
• Update Progress
• Timer controls.
Now is possible to create rich client behavior, such as update progress during a post back, page rendering etc. with small or no client script.
WPF (Windows Presentation Foundation) Support
In Visual Studio 2008, Windows Presentation Foundation (WPF) applications have been introduced and it has four WPF project types:
• WPF Application
• WPF Browser Application
• WPF Custom Control Library
• WPF User Control Library
Web Application Project Design Support
Project Designer was included in Visual Studio 2008. The Setting Page and signing page of Project Designer supports in many designing aspects.
To access the Settings page, select project node in Solution Explorer, and then, on the Project menu, click Properties. When the Project Designer appears, click the Settings tab.
Deployment by Click Once
Web Applications are hosted in a Web browser therefore it requires special deployment and security settings, when we build and deploy applications by using Click Once, Visual Studio will provide appropriate user interface and default values for this. Now it enhances to build and deploy Visual Studio Tools for applications by using the Project Designer's Publish page or the Publish Wizard.
Multiple Processor Support
Now MS Build accepts, a system is using multiple processors, either multi core processors or multiple separate processors. MS Build will utilize all the available processors to reduce the overall build time of the projects. Logging also upgraded for handling multi-processor build. The file names and locations of the Build assemblies are updated as below:
• Microsoft.Build.Conversion.v3.5.dll
• Microsoft.Build.Utilities.v3.5.dll
• Microsoft.Build.Tasks.v3.5.dll
And, also the following build assemblies are now located in \Program Files\Reference Assemblies\Microsoft\Framework\v3.5\:
• Microsoft.Build.Conversion.v3.5.dll
• Microsoft.Build.Engine.dll
• Microsoft.Build.Framework.dll
• Microsoft.Build.Utilities.v3.5.dll
JavaScript Intelligence / Debugging supports
Visual Studio 2008 contains intelligence support for java script.
It makes developers work easy when they do client side validation, AJAX applications and also when doing Silver light applications also.
Multi languages
In VS2008 Microsoft have introduced the MUI (Multilingual User Interface Architecture), which supports nine languages, which is English, Spanish, French, German, Italian, Chinese Simplified, Chinese Traditional, Japanese, and Korean.This supports the user to change the text language display as their wish.
Data Repeater Control
The new Data Repeater control helps to display rows of data in a scrollable container. This control gives more flexibility compare to standard grid control. The Data Repeater control displays a group of related controls by creating multiple instances in a scrollable manner which ensures to users to view several records at a time. When to display large amounts of data’s, we can set the Virtual Mode property is True, to display a subset of the available data. Virtual mode requires the implementation of a data cache and must control all interactions with the data cache at run time. It contains controlling the ability to add and delete records, adding search capabilities, and displaying related data in a master and detail format etc.
Reports / PDF Compression
When we create a new Reports Application project or ASP.NET Reports Web Site, The Report Wizard is started automatically, now we can use this wizard to build the report which gives guidelines by the steps to create a basic report. Now we can select a report data source, define a data set, select a report type (tabular or matrix), and apply a style to report. After we complete the wizard, we can enhance the report through using Report Designer , or alternatively, close the wizard and build the report manually.
In VS2008 the Report Viewer controls will now compress reports which are exported to the PDF format when they are configured for local processing.
Monday, November 2, 2009
Hi, Beginers just try this
Just go through this Query to create database and tables, use database, insert values in to tables ,join three relevant tables in SQL Server 2005.
create database Demo //* To create database(Your databse name is Demo)*//
Use Demo //* To use database(now active databse name is Demo)*//
//* To create first table named Employees*//
create table Employees(
EmpID int NOT NULL CONSTRAINT PK_Emp_EmpID PRIMARY KEY,
EmpName varchar(50) NOT NULL,
DeptNo int NULL,
JobId int NOT NULL,
NetSalary decimal(10,2) NOT NULL
)
GO
//* To create first table named Departments*//
create table Departments(
DeptNo int NOT NULL CONSTRAINT PK_Dept_DeptNo PRIMARY KEY,
DeptName varchar(20) NOT NULL
)
GO
//* To create first table named Jobs*//
CREATE TABLE Jobs(
JobId int NOT NULL CONSTRAINT PK_Jobs_JobId PRIMARY KEY,
JobDesc varchar(20) NOT NULL
)
GO
//* To insert datas to table named Departments*//
INSERT INTO Departments VALUES(1000, 'DOTNET')
INSERT INTO Departments VALUES(2000, 'JAVA/J2EE')
INSERT INTO Departments VALUES(3000, 'TESTING')
INSERT INTO Departments VALUES(4000, 'DBA')
//* To insert datas to table named Jobs*//
INSERT INTO Jobs VALUES(100, 'TL/PL')
INSERT INTO Jobs VALUES(200, 'SR.DEVELOPER')
INSERT INTO Jobs VALUES(300, 'DEVELOPER')
INSERT INTO Jobs VALUES(400, 'JR.DEVELOPER')
//* To insert datas to table named Employees*//
INSERT INTO Employees VALUES(100, 'Raj', 1000, 200, 50000.00)
INSERT INTO Employees VALUES(200, 'Nirmala', 2000, 100, 60000.00)
INSERT INTO Employees VALUES(300, 'John', 3000, 200, 50000.00)
INSERT INTO Employees VALUES(400, 'Alex', 1000, 100, 60000.00)
INSERT INTO Employees VALUES(500, 'Leesa', 4000, 300, 30000.00)
INSERT INTO Employees VALUES(600, 'Reena', 1000, 400, 20000.00)
GO
//* To join datas from 3 table*//
SELECT EmpID,EmpName,NetSalary,E.DeptNo,DeptName,E.JobId,JobDesc FROM Employees AS E
INNER JOIN
Departments AS D ON E.DeptNo = D.DeptNo
INNER JOIN
Jobs AS J ON E.JobId = J.JobId
create database Demo //* To create database(Your databse name is Demo)*//
Use Demo //* To use database(now active databse name is Demo)*//
//* To create first table named Employees*//
create table Employees(
EmpID int NOT NULL CONSTRAINT PK_Emp_EmpID PRIMARY KEY,
EmpName varchar(50) NOT NULL,
DeptNo int NULL,
JobId int NOT NULL,
NetSalary decimal(10,2) NOT NULL
)
GO
//* To create first table named Departments*//
create table Departments(
DeptNo int NOT NULL CONSTRAINT PK_Dept_DeptNo PRIMARY KEY,
DeptName varchar(20) NOT NULL
)
GO
//* To create first table named Jobs*//
CREATE TABLE Jobs(
JobId int NOT NULL CONSTRAINT PK_Jobs_JobId PRIMARY KEY,
JobDesc varchar(20) NOT NULL
)
GO
//* To insert datas to table named Departments*//
INSERT INTO Departments VALUES(1000, 'DOTNET')
INSERT INTO Departments VALUES(2000, 'JAVA/J2EE')
INSERT INTO Departments VALUES(3000, 'TESTING')
INSERT INTO Departments VALUES(4000, 'DBA')
//* To insert datas to table named Jobs*//
INSERT INTO Jobs VALUES(100, 'TL/PL')
INSERT INTO Jobs VALUES(200, 'SR.DEVELOPER')
INSERT INTO Jobs VALUES(300, 'DEVELOPER')
INSERT INTO Jobs VALUES(400, 'JR.DEVELOPER')
//* To insert datas to table named Employees*//
INSERT INTO Employees VALUES(100, 'Raj', 1000, 200, 50000.00)
INSERT INTO Employees VALUES(200, 'Nirmala', 2000, 100, 60000.00)
INSERT INTO Employees VALUES(300, 'John', 3000, 200, 50000.00)
INSERT INTO Employees VALUES(400, 'Alex', 1000, 100, 60000.00)
INSERT INTO Employees VALUES(500, 'Leesa', 4000, 300, 30000.00)
INSERT INTO Employees VALUES(600, 'Reena', 1000, 400, 20000.00)
GO
//* To join datas from 3 table*//
SELECT EmpID,EmpName,NetSalary,E.DeptNo,DeptName,E.JobId,JobDesc FROM Employees AS E
INNER JOIN
Departments AS D ON E.DeptNo = D.DeptNo
INNER JOIN
Jobs AS J ON E.JobId = J.JobId
Sunday, November 1, 2009
Delete duplicate records from SQL Server Table
To delete the duplicate records(same records in one more time) from SQL Server Data base table,use this query.
First write the conditions in .cs file to delete (as insert, update, delete records) duplicate records in to Page.IsPostBack = true Property, for your reference here I have given sql query for deleting duplicate records.
SET ROWCOUNT 1
DELETE yourtable
FROM yourtable a
WHERE (SELECT COUNT(*) FROM yourtable b WHERE b.fname =
a.fname AND b.lname = a.lname) > 1
WHILE @@rowcount > 0
DELETE yourtable
FROM yourtable a
WHERE (SELECT COUNT(*) FROM yourtable b WHERE b.fname =
a.fname AND b. lname = a. lname) > 1
SET ROWCOUNT 0
At the page refresh / relode time this query will work and delete duplecate record. So in your database duplicate record will not be added.
First write the conditions in .cs file to delete (as insert, update, delete records) duplicate records in to Page.IsPostBack = true Property, for your reference here I have given sql query for deleting duplicate records.
SET ROWCOUNT 1
DELETE yourtable
FROM yourtable a
WHERE (SELECT COUNT(*) FROM yourtable b WHERE b.fname =
a.fname AND b.lname = a.lname) > 1
WHILE @@rowcount > 0
DELETE yourtable
FROM yourtable a
WHERE (SELECT COUNT(*) FROM yourtable b WHERE b.fname =
a.fname AND b. lname = a. lname) > 1
SET ROWCOUNT 0
At the page refresh / relode time this query will work and delete duplecate record. So in your database duplicate record will not be added.
Subscribe to:
Posts (Atom)
