طلب صغير بس !

[Destructions]

انا عاوز اعرف ID الاكونت باسم الاكونت !
يعني كويري او اي حاجة اكتب فيه اسم الاكونت يجبلي الاي دي و الباسورد ! او الاي دي بس

[Neoon]

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

exec

USE [SRO_VT_ACCOUNT]
Exec [dbo].[_GetAccountData] 'PkMaximum'

[Destructions]

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

exec

USE [SRO_VT_ACCOUNT]
Exec [dbo].[_GetAccountData] 'PkMaximum'
تسلم