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 |
|
Gideon
Starting Member
15 Posts |
 Posted - 2002-06-09 : 17:56:41
|
| Is there an equivilant to Overloading in Oracle 8 in TransactSQL?Many thanks |
|
|
dataphile
Yak Posting Veteran
71 Posts |
Posted - 2002-06-10 : 03:50:01
|
| If you are talking about an "Overloaded Key", this should be avoided in good relational design. This is also not a reserved word, but terminology. It is called a complex column in all the transact SQL domumentation I have come accross.This is the sum total of overloading I could find in my Oracle documentation. If this is not what you where looking for, explain what you want to achieve, and let's take it from there. |
 |
|
|
Gideon
Starting Member
15 Posts |
Posted - 2002-06-12 : 20:46:56
|
| I'm talking about when you use the same name for several functions and change the variables...e.g.FUNCTION fun_uom_conversion (p_unit_from ops_conversion_factors.unit_id_from%TYPE, p_unit_to ops_conversion_factors.unit_id_to%TYPE, p_quantity_in NUMBER, p_calorific_value ops_entries.quantity%TYPE default pac_system_constants.default_cv ) RETURN NUMBER;FUNCTION fun_uom_conversion (p_unit_from ops_conversion_factors.unit_id_from%TYPE, p_unit_to ops_conversion_factors.unit_id_to%TYPE ) RETURN NUMBER; |
|
|
|
byrmol
Shed Building SQL Farmer
1591 Posts |
Posted - 2002-06-12 : 20:58:00
|
| There is no Overloading in SQL Server. You can howevever have the same function or procedure name but with a different owner...DavidM"SQL-3 is an abomination.." |
|
|
|
|
|
|
Overloading in Transact SQL