HI,
I want to insert a value in my table in dollars and in escudos
wich is the code for it?
Help me please!
The code that I have is:
Create Procedure InserirPreco
(
@Artigo_ID bigint,-- PRIMARY KEY Not Null,
--@DataPreco datetime,
@Preco smallmoney
)
AS
Insert into ArtigoPreco
VALUES (@Artigo_ID,getdate(), @Preco)
I want to insert a value in my table in dollars and in escudos
wich is the code for it?
Help me please!
The code that I have is:
Create Procedure InserirPreco
(
@Artigo_ID bigint,-- PRIMARY KEY Not Null,
--@DataPreco datetime,
@Preco smallmoney
)
AS
Insert into ArtigoPreco
VALUES (@Artigo_ID,getdate(), @Preco)