1 Attachment(s)
Query for get Account data
:junglejane:
PHP Code:
/* B Y L E A N D R O N u k e r t u b e */
USE [SRO_VT_ACCOUNT]
/* B Y L E A N D R O N u k e r t u b e */
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE procedure [dbo].[_GetAccountData]
@CharName VARCHAR(30)
AS
BEGIN
SELECT
[SRO_VT_SHARD].[dbo].[_Char].[CharName16]as'Nome do Char',
[SRO_VT_ACCOUNT].[dbo].[TB_User].[StrUserID]AS 'Login',
[SRO_VT_ACCOUNT].[dbo].[TB_User].[password]as 'Senha',
[SRO_VT_ACCOUNT].[dbo].[TB_User].[name]as 'Nome',
[SRO_VT_ACCOUNT].[dbo].[TB_User].[Email]as 'E-Mail',
[SRO_VT_SHARD].[dbo].[_Char].[CharID]as 'Char ID',
[SRO_VT_SHARD].[dbo].[_User].[UserJID]AS 'Account JID',
[SRO_VT_ACCOUNT].[dbo].[TB_User].[sec_content] as 'User Security Group'
FROM [SRO_VT_SHARD].[dbo].[_Char] INNER JOIN
[SRO_VT_SHARD].[dbo].[_User] ON
[SRO_VT_SHARD].[dbo].[_Char].[CharID]=
[SRO_VT_SHARD].[dbo].[_User].[CharID]
INNER JOIN
[SRO_VT_ACCOUNT].[dbo].[TB_User] ON
[SRO_VT_SHARD].[dbo].[_User].[UserJID] =
[SRO_VT_ACCOUNT].[dbo].[TB_User].[JID]
WHERE [SRO_VT_SHARD].[dbo].[_Char].[CharName16]LIKE @CharName
END
GO
/* B Y L E A N D R O N u k e r t u b e */
EXEC
PHP Code:
USE [SRO_VT_ACCOUNT]
Exec [dbo].[_GetAccountData] 'PkMaximum'
Attachment 127288
Re: Query for get Account data
Can use '%%'
Ex: EXEC _GetAccountData '%PkMa%'
Re: Query for get Account data
Re: Query for get Account data
