Need an Alternative for Case statement for my Stored proc in SQL server 2005

Tüm Yanıtlar

• 

  

  0

  Oylamak İçin Oturum Aç

  Read Erland's articles

  http://www.sommarskog.se/dynamic_sql.html

  http://www.sommarskog.se/dyn-search.html

  ---

  Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/
  
  MS SQL optimization: MS SQL Development and Optimization
  MS SQL Blog: Large scale of database and data cleansing
  MS SQL Consultants: Improves MS SQL Database Performance
  

  • Yanıt Olarak Öneren Naomi N 21 Kasım 2012 Çarşamba 03:07

  20 Kasım 2012 Salı 10:38

  Yanıtlayıcı
• 

  

  0

  Oylamak İçin Oturum Aç

  IF..Else condition may help you

  For more about IF..Else see below URL

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

  IF you use SQL 2012,then IIF will be helpful to you

  For more about IIF see below URL

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

  ---

  Please use Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

  20 Kasım 2012 Salı 11:12
• 

  

  0

  Oylamak İçin Oturum Aç

  Hi,

  You can use IF...ELSE as alternate .To know see below:

  http://sqltutorials.blogspot.com/2007/06/sql-ifelse-statement.html

  ---

  Ahsan Kabir Please remember to click Mark as Answer and Vote as Helpful on posts that help you. This can be beneficial to other community members reading the thread. http://www.aktechforum.blogspot.com/

  20 Kasım 2012 Salı 11:18
• 

  

  0

  Oylamak İçin Oturum Aç

  Any updates?

  ---

  Please use Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

  21 Kasım 2012 Çarşamba 08:23
• 

  

  0

  Oylamak İçin Oturum Aç

  Check below links to know more regarding Common Alternatives to IF ELSE Logic in SQL Server with Simple Example

  https://arulmouzhi.wordpress.com/2019/11/15/common-alternatives-to-if-else-logic-in-sql-server-with-simple-example/

  https://arulmouzhi.wordpress.com/2020/01/08/common-alternatives-to-if-else-logic-in-sql-server-with-simple-example-in-sql-server-part-2/

  17 Ocak 2020 Cuma 15:50