Use this way |
| A K replied to Lokesh M at 04-Jul-08 01:44 |
CREATE FUNCTION CustomersByContinent
(@Continent varchar(30))
RETURNS TABLE
AS
RETURN
SELECT dbo.WhichContinent(Customers.Country) as continent,
customers.*
FROM customers
WHERE dbo.WhichContinent(Customers.Country) = @Continent
GO
Create proc ProcName
AS
Begin
SELECT * from CustomersbyContinent('North America')
End
|
|