After Posting my question only I have seen that solution...

I am not going to use it anywhere..I faced this Question in interview..so i posted here

I Just want to know...

Change the Name of the Constraint

and he also given that we need to configure below options

Sp_Configure 'show advanced options',1

Reconfigure with Override

Go

Sp_Configure 'Ad Hoc Distributed Queries',1

Reconfigure with Override

Go

yes...I have tried it...it is working fine.......can anyone...

One Guy Said yes We can.... and given an example

1. Creating a Stored Procedure:

If Object_Id('Proc1') Is Not Null

Drop Proc Proc1

Go

Create Proc Proc1

As

Begin

Select 'SQL Server'

End

Go

2. Creating a Function:

If Object_Id('Function1') Is Not...

thanku all, can you explain me usage of cursors? in Which type of scenarios we use cursors?

http://balavardhanreddy.over-blog.com/categorie-11295031.html

http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Q_24825313.html

might be helpful to u

yes..i have used dynamic pivot for generating those dynamic columns

10 COLUMNS ARE static in my SP and remaining columns are dynamic based on users selection. like feedback1,feedback2.................feedback n (feedback is my column name)