|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
passing table variables into functionscan T-SQL allow table variables to be passed into user defined functions for
processing? i'm trying to work a function with that but sql2k doesn't seems to allow it Nestor wrote:
> can T-SQL allow table variables to be passed into user defined functions for No. If you post a fuller description of what you want then maybe we can> processing? i'm trying to work a function with that but sql2k doesn't seems > to allow it help you with some alternatives. -- David Portas, SQL Server MVP Whenever possible please post enough code to reproduce your problem. Including CREATE TABLE and INSERT statements usually helps. State what version of SQL Server you are using and specify the content of any error messages. SQL Server Books Online: http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx -- No you cannot. One option is to work with temporary tables across modules in
SQL Server. -- Show quoteHide quoteHTH, SriSamp Email: sris***@gmail.com Blog: http://blogs.sqlxml.org/srinivassampath URL: http://www32.brinkster.com/srisamp "Nestor" <n35***@yahoo.com> wrote in message news:u71oBrIVGHA.1160@TK2MSFTNGP09.phx.gbl... > can T-SQL allow table variables to be passed into user defined functions > for processing? i'm trying to work a function with that but sql2k doesn't > seems to allow it > 
Thread options
Other interesting topics
why is there a gap in the identity value created in the identity column?
performance of select count sproc Splitting a Name Field What is the "current session" for a local temp table? Advice Needed Calculating previous thursday date self-joined table query Can I insert into the same table a new row with the "old" row field value? How do I get just one set? Normalize data issue. |
|||||||||||||||||||||||
