How can we call UDF(User Define Function) using C# code in
ASP.net ?
Answers were Sorted based on User's Feedback
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 |
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 |
Can you leave a union at any time?
what is denormalization and when would you go for it? : Sql server database administration
Will the writetext statement activate a trigger?
What do you mean by subquery?
What are the basic functions for master, msdb, model, tempdb and resource databases?
what r steps to we need to fallow b4 kill the process?
what is normalization? Explain different levels of normalization? : Sql server database administration
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
Is the order of columns in the set clause important in ms sql server?
Explain what is lock escalation?
What is normalization and what are the different forms of normalizations?
Explain following error properties?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)