Site Sponsored By: SQLDSC - SQL Server Desired State Configuration
Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Kentish writes "I want to place an If Clause In a Declare Cursor StatementE.gDECLARE CUR_X CURSOR FORIF @FieldName = 'All' Select * From TableName IF @FieldName = 'Count' Select Count(*) From TableName"
robvolk
Most Valuable Yak
15732 Posts
Posted - 2005-12-16 : 08:10:22
Sometimes I wonder what I (or graz, or Damian) did in a past life to deserve questions like this.
madhivanan
Premature Yak Congratulator
22864 Posts
Posted - 2005-12-16 : 08:16:38
Why do you need cursor?Post your exact requirement and there should be better method than what you are trying to doMadhivananFailing to plan is Planning to fail