Description
Properties
| Name | Value |
|---|---|
| ANSI Nulls ON | True |
| Quoted Identifier ON | True |
| Encrypted | False |
| Execute As | |
| Assembly |
Parameters
3| Name | Data Type | Length | Description |
|---|---|---|---|
| @p_Cliente | int | 4 | |
| @p_userid | int | 4 | |
| @p_comentarios | varchar | -1 |
SQL Script
Copy
SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
/****** Object: StoredProcedure [dbo].[backend_datos_clientes] Script Date: 6/7/2017 11:35:12 ******/
/*
CREATE TABLE [dbo].[clientes_comentarios](
cliente int null,
comentarios varchar(max) null,
user_id int NULL,
created smalldatetime null
) ON [PRIMARY]
select * from users where username = 'f0000'
select * from clientes_comentarios
insert into clientes_comentarios values (103974506, 'Se volvio a llamar por telefono en el dia de hoy, para ofrecer nuevos servicios', 1063064806, GETDATE())
*/
CREATE OR ALTER PROCEDURE dbo.backend_abm_clientes_comentarios
@p_Cliente int ,
@p_userid int,
@p_comentarios varchar(max)
AS
BEGIN
SET NOCOUNT ON;
insert into clientes_comentarios values (@p_Cliente, @p_comentarios, @p_userid, GETDATE())
select '0' as error
END
GO
GO
/****** Object: StoredProcedure [dbo].[backend_datos_clientes] Script Date: 6/7/2017 11:35:12 ******/
/*
CREATE TABLE [dbo].[clientes_comentarios](
cliente int null,
comentarios varchar(max) null,
user_id int NULL,
created smalldatetime null
) ON [PRIMARY]
select * from users where username = 'f0000'
select * from clientes_comentarios
insert into clientes_comentarios values (103974506, 'Se volvio a llamar por telefono en el dia de hoy, para ofrecer nuevos servicios', 1063064806, GETDATE())
*/
CREATE OR ALTER PROCEDURE dbo.backend_abm_clientes_comentarios
@p_Cliente int ,
@p_userid int,
@p_comentarios varchar(max)
AS
BEGIN
SET NOCOUNT ON;
insert into clientes_comentarios values (@p_Cliente, @p_comentarios, @p_userid, GETDATE())
select '0' as error
END
GO
Depends On
1Used By
No items found