Description
Properties
| Name | Value |
|---|---|
| ANSI Nulls ON | True |
| Quoted Identifier ON | True |
| Encrypted | False |
| Execute As | |
| Assembly |
Parameters
4| Name | Data Type | Length | Description |
|---|---|---|---|
| @p_user_id | int | 4 | |
| @p_cliente | int | 4 | |
| @p_comentario | varchar | -1 | |
| @p_cuit | varchar | 20 |
SQL Script
Copy
SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
CREATE OR ALTER PROCEDURE dbo.carga_comentario
@p_user_id int,
@p_cliente int,
@p_comentario varchar(max),
@p_cuit varchar(20)
AS
BEGIN
declare @fecha smalldatetime = getdate()
declare @username varchar(100)
insert into comentarios (user_id, cliente , comentario,identificacion,fecha_creacion) values (@p_user_id , @p_cliente , @p_comentario, @p_cuit,@fecha )
set @username= (select username from users where user_id = @p_user_id)
select @fecha as fecha_creacion, @p_comentario as comentario, @username as username
END
GO
GO
CREATE OR ALTER PROCEDURE dbo.carga_comentario
@p_user_id int,
@p_cliente int,
@p_comentario varchar(max),
@p_cuit varchar(20)
AS
BEGIN
declare @fecha smalldatetime = getdate()
declare @username varchar(100)
insert into comentarios (user_id, cliente , comentario,identificacion,fecha_creacion) values (@p_user_id , @p_cliente , @p_comentario, @p_cuit,@fecha )
set @username= (select username from users where user_id = @p_user_id)
select @fecha as fecha_creacion, @p_comentario as comentario, @username as username
END
GO
Depends On
2Used By
No items found