Crystal Reports is a powerful, dynamic, actionable 
reporting solution that helps you design, explore, 
visualize, and deliver reports via the web or embedded or 
stand alonein enterprise applications. It enables end users 
to consume reports with stunning visualizations, conduct on-
report business modeling, and execute decisions instantly 
from the report itself—reducing dependency on IT and 
developers.
we cant also Export data from crystal reports to excel,.CVS 
files


There are four major components in crystal reports Report 
designer, Reports engine, Report viewer and object models.
Report designer gives a graphical interface to create and 
modify reports. To view the designer add a new crystal 
report file and double click on it you should see the 
report designer 
 
it is mainly used in Vb,.net with sql or oracle .

www.allinterview.com

http://blog.sqlauthority.com

What are the Differences Between SQL Server 2000 and SQL Server 2005?
I've been asked this question every time that there's a new
version and yet I've never been able to give what I think is a
nice, concise, logical answer that satisfies the asker. Probably
it's a lack of my ability to easily form words in my mouth and
get them out in the proper order, so I decided it might make some
sense to do this on paper (metaphorically speaking) and help
others out.

Like many of you, I usually get this question from someone
outside of SQL Server. A windows admin, a network guy, etc.,
someone who has little contact with SQL Server. Or maybe it's
someone who's been stuck with admin'ing a SQL Server instance.

In any case, I wanted to try and explain this concisely for the
non-DBAs. As I began this project, however I soon realized that
it's not easy to just give a good general answer. As with
everything else in SQL Server it seems that "it depends" is the
best general answer, so I broke this up into a few areas. This
part will look at the administrative differences and the next
will cover more of the development differences.

The Administrative Differences
Administering a SQL Server instance to me means making sure the
server service runs efficiently and is stable and allows clients
to access the data. The instance should keep data intact and
function according to the rules of the code implemented while
being well maintained.

Or for the non-DBAs, it means that you are the sysadmin and it
just works.

The overall differences are few. Sure we use Management Studio
instead of Enterprise Manager, but that's not really a big deal.
Really many of the changes, like being able to change connections
for a query, are superficial improvements that don't really
present a substantial change. If you think they do, you might be
in the wrong job.

Security is one area that is a very nice improvement. The
separation of the schema from the owner makes administrative
changes easier, but that is a big deal because it greatly
increases the chances you won't keep an old account active
because it's a pain to change owners on objects. There's also
more granularity and ease of administration using the schema as
another level of assigning permissions.

Another big security change is the ability to secure your web
services using certificates instead of requiring authentication
using a name and password. Add to that the capability to encrypt
data, and manage the keys, can make a big difference in the
overall security of your data. You have to carefully ensure your
application and access is properly secured, but just the
marketing value of encryption when you have credit card,
financial, or medical data is huge. SQL Server 2000 had no real
security features for data, allowing an administrator to see all
data. You could purchase a third party add-on, but it was
expensive and required staff training. Not that you don't need to
learn about SQL Server 2005, but it should be a skill that most
DBAs will learn and be able to bring to your organization over time.

High availability is becoming more and more important to all
sizes of businesses. In the past, clustering or log shipping were
your main choices, but both were expensive and required the
Enterprise Edition. This put these features out of the reach of
many companies, or at least, out of many DBAs' budgets. With SQL
Server 2005, you can now implement clustering, log shipping, or
the new Database Mirroring with the Standard edition. With the
ability of Database Mirroring to use commodity hardware, even
disparate hardware between the primary and mirror databases, this
is a very reasonable cost solution for almost any enterprise.

There are also online indexes, online restores, and fast recovery
in the Enterprise Edition that can help ensure that you take less
downtime. Fast recovery especially can be an important feature,
allowing the database to be accessed as the undo operations
start. With a log of open transactions when a database is
restarted, this can really add up to significant amounts of time.
In SQL Server 2000, you had to have a complete, intact database
before anyone could access it. With redo/undo operations
sometimes taking a significant amount of time, this could delay
the time from Windows startup to database availability by minutes.

Data sizes always grow and for most companies, performance is
always an issue on some server. With SQL Server 2000, you were
limited to using 2GB of RAM and 4 CPUs on the Standard Edition.
The number of CPUs hasn't changed, but you can now use as much
RAM as the OS allows. There also is no limit to the database
size, not that the 1,048,516 TB in SQL Server 2000. Since RAM is
usually a limiting factor in the performance of many databases,
upgrading to SQL Server 2005 could be something you can take
advantage of. SQL Server 2005 also has more options and
capabilities on the 64-bit platform than SQL Server 2000.

Why Upgrade?
This is an interesting question and one I've been asked quite a
bit over the last 18 months since SQL Server 2005 has been
released. The short answer is that if SQL Server 2000 meets your
needs, then there's no reason to upgrade. SQL Server 2000 is a
strong, stable platform that has worked well for millions of
installations. If it meets your needs, you are not running up
against the limits of the platform, and you are happy with your
system, then don't upgrade.

However, there is a caveat to this. First the support timeline
for SQL Server 2000 shows mainstream support ending next year, in
April 2008. I can't imagine that Microsoft wouldn't extend that
given the large number of installations of SQL Server 2000, but
with the next version of SQL Server likely to come out next year,
I can see this being the point at which you cannot call for
regular support. The extended support timeline continues through
2013, but that's an expensive option.

The other consideration is that with a new version coming out
next year, you might want to just start making plans to upgrade
to that version even if you're happy with SQL Server 2000. If the
plan is to release a new version every 2-3 years, you'll need to
upgrade at least every 5-6 years to maintain support options.

Be sure that in any case you are sure the application you are
upgrading, if it's a third party, is supported on SQL Server 2005.

Lastly, if you have multiple servers and are considering new
hardware for more than 1 of them, it might make some sense to be
sure to look at buying one large 64-bit server and performing
some consolidations. I might recommend that you wait for the next
version of SQL Server if you are worried about conflicts as I
have heard rumors of switches to help govern the resource usage
in Katmai (SQL Server 2008).

A quick summary of the differences:

Feature	SQL Server 2000	SQL Server 2005
Security	Owner = Schema, hard to remove old users at times	Schema
is separate. Better granularity in easily controlling security.
Logins can be authenticated by certificates.
Encryption	No options built in, expensive third party options
with proprietary skills required to implement properly.
Encryption and key management build in.
High Availability	Clustering or Log Shipping require Enterprise
Edition. Expensive hardware.	Clustering, Database Mirroring or
Log Shipping available in Standard Edition. Database Mirroring
can use cheap hardware.
Scalability	Limited to 2GB, 4CPUs in Standard Edition. Limited
64-bit support.	4 CPU, no RAM limit in Standard Edition. More
64-bit options offer chances for consolidation.
Conclusion
These seem to be the major highlights from my perspective as an
administrator. While there are other improvements, such as the
schema changes flowing through replication, I'm not sure that
they represent compelling changes for the non-DBA.

In the next article, I'll examine some of the changes from a
developer perspective and see if any of those give you a reason
to upgrade.

And I welcome your comments and thoughts on this as well. Perhaps
there are some features I've missed in my short summary.

http://support.microsoft.com/kb/328306

1)sqlserver 2000 contain query analyzer and enterprise 
manger as a seperate tools but sqlserver 2005 contains a 
single management studio(query analyzer + enterprise 
manger).

2)sql 2005 contain CLR Integration

3)sql 2005 contain sqlserver business intelegent management 
studio for dedugging sp's.

4)CLR stored procedures

Sql server 2005 have some new data types like varchar
(max),xml. Sql server 2005 have SSIS instead of dts in sql 
server 2000. SSRS with adhoc reporting. Some sys command 
are changed like sys.objects, sys.columns.

1)sqlserver 2000 contain query analyzer and enterprise 
manger as a seperate tools but sqlserver 2005 contains a 
single management studio(query analyzer + enterprise 
manger).

2)sql 2005 contain CLR Integration

3)sql 2005 contain sqlserver business intelegent management 
studio for dedugging sp's.

4)CLR stored procedures

5) SQL 2005 integrates very well with Visual Studio and dot 
net as well.
6)One of the new features of security is that it can be 
applied in a way 
you want. Its quite flexible but it can get quite confusing 
if you are 
not sure of what you want to do. Users and groups can be 
controlled 
quite extensibly with the new security features. 

7) The DTS of SQL 2000 has been replaced with SSIS (Sql 
Server Integrated 
Services) - Its an advanced version of dts but can do more 
than dts. You 
can manipulate all your data, within each SQL task and 
theres a whole 
list to it. Each field or column of data retrieved for the 
purpose of 
transfer can be manipulated in a variety of ways, and using 
just what 
you require for the final extract or transfer

Sql server 2005 have some new data types like varchar
(max),xml. Sql server 2005 have SSIS instead of dts in sql 
server 2000. SSRS with adhoc reporting. Some sys command 
are changed like sys.objects, sys.columns.

update <tablename> set <columnname>=<value>
where <condition>

--table name = production
--coloum name = description(one column name)
--categoryname is another column name


update dbo.production
set
discription='xxxxxxxxxxx'
where [check condition]
categoryname='vitamins'

Constraint are the rules enforced on data columns on table.

Five type of constraints 
Primary key
Unique Key
Foreign Key
Not Null
Check

Constraints are used to limit the type of data that can go 
into a table.

NOT NULL 
UNIQUE 
PRIMARY KEY 
FOREIGN KEY 
CHECK 
DEFAULT

Constraint are the rules enforced on data columns on table

types of constraints:

PRIMARYKEY
FOREIGN KEY 
NOT NULL
UNIQUE KEY
CHECK 
DEFAULT
Check

Constraints are the way by Databse managing the data inegrity.

Types of constraint are:-
1)NOT Null
2)Default
3)Check
4)Rule
5)Primary
6)Unique
7)Foreign

How to know the size of any database:
Syntax:
sp_helpdb 'tempdb'

db_size of temp db 38.56 MB.

The syntax is : sp_helpdb 'tempdb'

db_size of a tempdb is 8.50 MB in sqlserver 2005.

the above two answers are wrong....... the max size of tem 
db  by default is -1. the main usage of tempdb is.if u run 
a query the data will store in tempdb from tempdb we can 
get output..but max size is -1;

Use Table variable with a identity column. Then make a while
loop row by row

Use Table variable with a identity column. Then make a while
loop row by row

Use derived columns,corelated subqueries instead of cursors
so that the performance will also be improved.

Regards
prasanna