How can we call UDF(User Define Function) using C# code in
ASP.net ?

Answers were Sorted based on User's Feedback



How can we call UDF(User Define Function) using C# code in ASP.net ?..

Answer / Dhiraj Singh Garbyal

In ASP.NET, you can call User Defined Functions (UDFs) by adding the function to a SQL Server Stored Procedure and then calling that stored procedure from your C# code.

Is This Answer Correct ?    0 Yes 0 No

How can we call UDF(User Define Function) using C# code in ASP.net ?..

Answer / reventh

yes you can call a function.
sqlcommand cmd=new sqlcommand("select function
(parametter)");
sqldatareader rdr=cmd.excutereader();
while(rdr.read()
{
do something here;

}

Is This Answer Correct ?    1 Yes 3 No

Post New Answer

More SQL Server Interview Questions

Can you leave a union at any time?

1 Answers  


what is denormalization and when would you go for it? : Sql server database administration

1 Answers  


Will the writetext statement activate a trigger?

1 Answers  


What do you mean by subquery?

1 Answers  


What are the basic functions for master, msdb, model, tempdb and resource databases?

1 Answers  


what r steps to we need to fallow b4 kill the process?

1 Answers   Verizon,


what is normalization? Explain different levels of normalization? : Sql server database administration

1 Answers  


what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

1 Answers  


Is the order of columns in the set clause important in ms sql server?

1 Answers  


Explain what is lock escalation?

1 Answers  


What is normalization and what are the different forms of normalizations?

2 Answers  


Explain following error properties?

1 Answers  


Categories