Description
Properties
| Name | Value |
|---|---|
| ANSI Nulls ON | True |
| Quoted Identifier ON | True |
| Encrypted | False |
| Execute As | |
| Assembly |
Parameters
1| Name | Data Type | Length | Description |
|---|---|---|---|
| @api_key | varchar | 20 |
SQL Script
Copy
SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
CREATE OR ALTER PROCEDURE dbo.api_key_obtener_info
@api_key varchar(20)
AS
BEGIN
SET NOCOUNT ON;
declare @user_id int = (select user_id from apikey where api_key = @api_key and activo = 1)
select first_name,last_name,email,apikey.user_id,client_id,ip,producto from users inner join
apikey on apikey.user_id = users.user_id
where users.user_id = @user_id and api_key = @api_key and activo = 1
END
GO
GO
CREATE OR ALTER PROCEDURE dbo.api_key_obtener_info
@api_key varchar(20)
AS
BEGIN
SET NOCOUNT ON;
declare @user_id int = (select user_id from apikey where api_key = @api_key and activo = 1)
select first_name,last_name,email,apikey.user_id,client_id,ip,producto from users inner join
apikey on apikey.user_id = users.user_id
where users.user_id = @user_id and api_key = @api_key and activo = 1
END
GO
Depends On
2Used By
No items found