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.
| Author |
Topic |
|
desikankannan
Posting Yak Master
152 Posts |
 Posted - 2010-02-17 : 11:46:23
|
| iam really new to write function,what are all the comman functioni can write and call that function inside the stored procedurei wants to do everything in backend process iam working with .net 2005but i feel it good to process all in the backend.pls guide me , what function i can write and call that to my stored procedureDesikankannan |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-02-17 : 11:49:46
|
| you can call all types of functions inside procedure. there are basically three - scalar valued, inline table valued and Multi-statement Table-Value User-Defined Function. you can use all of them in proceduremore details herehttp://www.sqlteam.com/article/user-defined-functions------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2010-02-18 : 01:09:37
|
| << wants to do everything in backend process iam working with .net 2005but i feel it good to process all in the backend.>>What is wrong with doing them in VB.NET?MadhivananFailing to plan is Planning to fail |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-02-18 : 01:15:54
|
quote:
Originally posted by madhivanan
<< wants to do everything in backend process iam working with .net 2005but i feel it good to process all in the backend.>>What is wrong with doing them in VB.NET?MadhivananFailing to plan is Planning to fail
For that, you need to know VB.NET  ------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2010-02-18 : 01:29:03
|
Op said " iam working with .net 2005"So he knows it  MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
comman user define function