RE: [NF] SQL Server equivalent to Oracle for parameters/variables?

From: [EMAIL PROTECTED] In Oracle 9i(?), I was able to write stored procedure where I simply referenced the field behind the parameter/variable, thus telling Oracle the type and length implicitly (as it would look it up instead of me hardcoding it). For example, cName as Customers.cName

RE: [NF] SQL Server equivalent to Oracle for parameters/variables?

At 09:19 AM 7/21/2006 -0700, [EMAIL PROTECTED] wrote: From: [EMAIL PROTECTED] In Oracle 9i(?), I was able to write stored procedure where I simply referenced the field behind the parameter/variable, thus telling Oracle the type and length implicitly (as it would look it up instead of me

Re: [NF] SQL Server equivalent to Oracle for parameters/variables?

I guess you mean as in: FUNCTION EditCust(pcCustName IN mydb.Customers.cName%TYPE, pcCode IN ...) No, I haven't found it in ms SQL Server - it's neat and I miss it. Andrew Davies  MBCS CITP   - AndyD    8-)# ** This email