Description
Properties
| Name | Value |
|---|---|
| ANSI Nulls ON | True |
| Quoted Identifier ON | True |
| Encrypted | False |
| Execute As | |
| Assembly |
SQL Script
Copy
SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
--exec obtener_Monedas
CREATE OR ALTER procedure dbo.obtener_Monedas
AS
BEGIN
SET NOCOUNT ON;
select rtrim(ltrim(moneda)) as moneda, rtrim(ltrim(nombre_moneda)) as nombre_moneda,Monedas.country_code, country_name
from Monedas
LEFT Join country on (country.country_code = monedas.country_code)
/*order by nombre_moneda*/
order by moneda
END
GO
GO
--exec obtener_Monedas
CREATE OR ALTER procedure dbo.obtener_Monedas
AS
BEGIN
SET NOCOUNT ON;
select rtrim(ltrim(moneda)) as moneda, rtrim(ltrim(nombre_moneda)) as nombre_moneda,Monedas.country_code, country_name
from Monedas
LEFT Join country on (country.country_code = monedas.country_code)
/*order by nombre_moneda*/
order by moneda
END
GO
Depends On
2Used By
No items found