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 instead of saying cName varchar(20).
Is there an equivalent in SQL Server? I'm looking at BOL now but thought I'd ask in the interim. Thanks! --Mike _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.