Case Statement

Question

Case Statement

sandeep4testing

Mr or Mrs. 500

Points: 534
More actions
March 16, 2012 at 3:17 am

#254773

Hi Friends,
I'm learning the dynamic SQL Server,
Any one can tell me what is the use of case statement and how we need to use case statement ?
Thank's,
Sandeep.

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Ant-Green SSC Guru Points: 113507 More actions · Answer 1

if you have not already, please install books online from the SQL installation media, it will help you in the long run and will give you the same information we will refer to from the msdn web pages

http://msdn.microsoft.com/en-us/library/ms181765.aspx

Sean Lange SSC Guru Points: 286590 More actions · Answer 2

I would recommend skipping the local installation and just the online version. There are frequent updates to the online version, your local installed version will not have those updates.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 3

Sean Lange (3/16/2012)
I would recommend skipping the local installation and just the online version. There are frequent updates to the online version, your local installed version will not have those updates.

I like having Books Online stored locally. You never know when you might need it and not have access to internet. On searches, you can always set it uo to search the web first.

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 4

sandeep4testing (3/16/2012)
Hi Friends,
I'm learning the dynamic SQL Server,
Any one can tell me what is the use of case statement and how we need to use case statement ?
Thank's,
Sandeep.

This is a mighty broad topic. It would help if you could provide a more specific example of what your are trying to accomplish and where you are running into a problem.

Sean Lange SSC Guru Points: 286590 More actions · Answer 5

Lynn Pettis (3/16/2012)
Sean Lange (3/16/2012)
I would recommend skipping the local installation and just the online version. There are frequent updates to the online version, your local installed version will not have those updates.
I like having Books Online stored locally. You never know when you might need it and not have access to internet. On searches, you can always set it uo to search the web first.

True enough. I always forget some people actually do work outside the office. They don't let us out. In fact we don't even have windows. :w00t:

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 6

Sean Lange (3/16/2012)
Lynn Pettis (3/16/2012)
Sean Lange (3/16/2012)
I would recommend skipping the local installation and just the online version. There are frequent updates to the online version, your local installed version will not have those updates.
I like having Books Online stored locally. You never know when you might need it and not have access to internet. On searches, you can always set it uo to search the web first.
True enough. I always forget some people actually do work outside the office. They don't let us out. In fact we don't even have windows. :w00t:

I have also worked where we have lost internet connectivity and still needed to support our local user base. Having BOL locally is nice when things like that happen.

sturner SSC-Insane Points: 22411 More actions · Answer 7

sandeep4testing (3/16/2012)
Hi Friends,
I'm learning the dynamic SQL Server,
Any one can tell me what is the use of case statement and how we need to use case statement ?
Thank's,
Sandeep.

It's a good thing Celko didn't hear you call it a "case statement", he'd yell at you for not calling it a case expression. 😎

The probability of survival is inversely proportional to the angle of arrival.