How to get the definition of a user defined function back?



How to get the definition of a user defined function back?..

Answer / Ram Niwas Paswan

To get the definition of a user-defined function in MS SQL Server, you can use the sp_helpfunc stored procedure. Here's an example:n```sqlnEXEC sp_helpfunc 'your_function_name';```

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

Can we create a clustered index on composite primary key.

3 Answers   IGT,


Is there any difference between primary key and unique with the not null condition?

1 Answers  


How many partitions a clustered index has by default in sql server 2012?

1 Answers  


How to use wildcard characters in like operations in ms sql server?

1 Answers  


What are sql server procedures?

1 Answers  


Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...

1 Answers   Crown Solutions,


List the different types of collation sensitivities in sql server?

1 Answers  


What are mdf,ndf,ldf files and how to see the data in those files?

6 Answers   Accenture,


What is a cursor, index in sql?

1 Answers  


To find second largest salary in Employee table

17 Answers   CSS,


How do I perform an unattended install of sql server 2000?

1 Answers  


Explain datetimeoffset data type in sal server 2008?

1 Answers  


Categories