I have sql server 2005 express edition installer.

I have to do queries related to joins,fulltext search,xml data,stored procedure,transaction,view,index,managed code.

so i want to know can these queries run on express edition? for someone told me that express doesn't have full features.

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

The above link compares the various flavors 

What you want to achieve means is little higher than SQLExpress can offer, in this case you can get SQL Server Developer Edition (with a fee) as a personalized copy.  http://www.microsoft.com/sql/editions/developer/default.mspx more on here.

IF no other go then see this http://www.microsoft.com/sql/editions/express/features.mspx on highlights of SQLExpress features, and http://msdn.microsoft.com/en-us/library/ms345154.aspx edition overview.

Here you go ...

http://www.microsoft.com/sql/editions/express/default.mspx

ssqa.net:

What you want to achieve means is little higher than SQLExpress can offer, in this case you can get SQL Server Developer Edition (with a fee) as a personalized copy.  http://www.microsoft.com/sql/editions/developer/default.mspx more on here.

IF no other go then see this http://www.microsoft.com/sql/editions/express/features.mspx on highlights of SQLExpress features, and http://msdn.microsoft.com/en-us/library/ms345154.aspx edition overview.

 The developer's edition costs $49.95 US and is worth the investment - more features that should prove useful.