Syed Akbar Ali

Simple SQL query to get duplicate values in a table

This is simple T-SQL query to find duplicate values in Microsoft SQL Server Database

select a.field1, a.field2,a.field3, a.field4
    from table a
     where 1 < (select count(*)
      from table b
        where b.field1 = a.field1
          and b.field2 = a.field2
          and b.field3 = a.field3)

Obout suite Controls for ASP.NET

Obout suite contains over 20 powerful controls. The suite includes hundreds of examples showcasing basic and advanced features of each control and their top performance.

Introduction: ASP.NET 2.0 Folders

ASP.NET 2.0 allows us to create some folders via right clicking project. But lots of people are don't know why we need to create that folder.

Here are the description for the each folder in asp.net 2.0 that we have to create for diffrent purpose.

App_Code

App_code folder contains the code files for the classes, structures, enums etc. It also contains .wsdl files for web services. Typed data set files are also reside in this folder.Any of this item automatically available to whole application.

App_Themes

ASP.NET supports themes to enable visual styles on web page. This folder contains the themes skin and .css(Cascading Style Sheet) files.

App_Data

App_Data contains the database for a application and other data files like .mdf, xml, text and .csv files used in web application.This folder are used to stored data related entities.

App_GlobalResources

ASP.NET allows us to create resource files. There are two types of resources files one is global and another one is local. The global resources files are available to whole application. While local resources files are available to specific page only. This folder store global resource files with .resx extensions.

App_LocalResources

This folder stored local resources files.

App_WebReferences

This folder store web reference of web service from a asp.net 2.0 application. You can web reference via right click project in solutions explorer and then click add web reference.

App_Browsers

The App_Browsers folder holds browser files, which are XML files used to describe characteristics and capabilities of these browsers

Bin

This folder contains assembly files for controls and web pages.Assembly files are basically a .dll files. Any .dll files found this folder automatically links to whole application.

This folder structure are basically supported by asp.net 2.0. You can also create your own folder structure by right click project name in solution explorer. and add new folder

Introduction: What is DML, DDL, DCL and TCL in SQL Server

DML

DML is abbreviation of Data Manipulation Language. It is used to retrieve, store, modify, delete, insert and update data in database.

Examples: SELECT, UPDATE, INSERT statements

DDL

DDL is abbreviation of Data Definition Language. It is used to create and modify the structure of database objects in database.

Examples: CREATE, ALTER, DROP statements

DCL

DCL is abbreviation of Data Control Language. It is used to create roles, permissions, and referential integrity as well it is used to control access to database by securing it.

Examples: GRANT, REVOKE statements

TCL

TCL is abbreviation of Transactional Control Language. It is used to manage different transactions occurring within a database.

Examples: COMMIT, ROLLBACK statements

 

This article originally posted by Pinal Dave in his blog. I just want to keep a copy in my blog bcoz some time I am getting confused in DCL, DML, DDL .. So, I can easily refer if its in my blog.

Thanks to Pinal Dave.

Get free Visual Studio 2008 and .NET Framework Training kit

Today I found this training kit at Microsoft site. It is useful for all vs 2008 learners  .. Get it here.

This kit includes presentations, labs and demos.

 

What is Linq?

Linq is the one of the most hottest release from Microsoft. 

Still I don't know what is Linq?. So, I searched in web and I have found a great articles from Saqib Ullah.

This articles covers all the aspects of Linq in each and every way.

Following is the link for that article .
http://geekswithblogs.net/technetbytes/archive/2007/04/30/112129.aspx
 

 

My First Entry

Here I am just starting my blog, Ok, it's been awesome here at weblogs.asp.net and I just want to thank Joe Stagner personally for including me in the experience now.

Programming and web development are passions of mine, and I hope to have something useful to contribute to the community either through my work or through this blog. 

Thank You for your time spending with me :) 

About Me

My name is Syed Akbar Ali and I currently live and work in Chennai, India with my Parents. I was born in 1985.

I started using computer in the year 2000. First I created my email in Hotmail.com. Still I am keeping that email id. But later I switched to Gmail. I started programming in 2002. I keeps learning new tricks as a Developer.

I recently (January 2008) started this blog because I know it took me a long time to get where I am at, and I want to help other people get where they are going a little bit faster.

... more about me soon ...

Thanks for Visiting my Blog