03/12/2005, 11:22
|
| | | Fecha de Ingreso: noviembre-2003 Ubicación: Costa Rica
Mensajes: 85
Antigüedad: 20 años, 5 meses Puntos: 0 | |
| el Codigo del Stored Procedure
Gracias de nuevo por tu respuesta, el codigo es este
IF EXISTS (SELECT * FROM dbo.SYSOBJECTS WHERE ID = OBJECT_ID(N'[dbo].[UserLogin]') AND OBJECTPROPERTY(ID, N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[UserLogin]
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE [UserLogin]
@User NVARCHAR(20),
@Pass NVARCHAR(20)
WITH ENCRYPTION
AS
SET NOCOUNT ON
IF EXISTS
(
SELECT COUNT(*) FROM Users
WHERE Login = @User AND UserPass = @Pass AND Status = 1
HAVING COUNT(*) > 0
)
BEGIN
SELECT COUNT(*) AS Error,
UserID ID,
Login 'User',
UserPass Password
FROM Users
WHERE Login = @User
GROUP BY
UserID,
Login,
UserPass
RETURN
END
ELSE
BEGIN
SELECT COUNT (*) AS Error,
0 ID,
'' 'User',
'' Password
FROM Users
WHERE Login = @User
AND UserPass = @Pass
RETURN
END
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
GRANT EXECUTE ON [dbo].[UserLogin] TO [Phone]
GO |