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 |
|
rafigroup
Starting Member
2 Posts |
Posted - 2008-08-25 : 05:44:41
|
| Why SqlPipe is needed for storedprocedure but not to Functions? |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-08-25 : 05:48:13
|
quote: Originally posted by rafigroup Why SqlPipe is needed for storedprocedure but not to Functions?
Are you using SQL Server?Give us the exampleMadhivananFailing to plan is Planning to fail |
 |
|
|
dexter.knudson
Constraint Violating Yak Guru
260 Posts |
Posted - 2008-08-25 : 05:53:16
|
| See http://www.informit.com/articles/article.aspx?p=473457&seqNum=7 |
 |
|
|
rafigroup
Starting Member
2 Posts |
Posted - 2008-08-25 : 06:03:27
|
| Madhi, i am just studying it. i couldnt understand y we need it as we can achive by 'return'.a c# SP:public static sqlint32 Sp(sqlstring val){.......... sqlpipe p = sqlcontext.Getpipe(); p.send(datareader);return (sqlint32) ret;} |
 |
|
|
|
|
|