Database

SilimSayo wrote:

unless the Table employees exists in the Table1 schema

SilimSayo wrote:

and why would you even have a schema called table1?

SilimSayo wrote:

but you're not getting my point at all

SELECT FirstName , LastName 
FROM Employees
FOR XML AUTO, ELEMENTS, ROOT('Table1')

public static string
Hash
(
    string Subject
)
{
    return ( Hash 
    ( 
        System.Text.Encoding.Unicode.GetBytes ( Subject ) 
    , 
        new System.Security.Cryptography.SHA1Managed() 
    ) ) ;
}

public static string
Hash
(
    string                                     Subject
,
    System.Security.Cryptography.HashAlgorithm Provider
)
{
    return ( Hash 
    ( 
        System.Text.Encoding.Unicode.GetBytes ( Subject ) 
    , 
        Provider
    ) ) ;
}

public static string
Hash
(
    byte[] Subject
)
{
    return ( Hash 
    ( 
        Subject 
    , 
        new System.Security.Cryptography.SHA1Managed() 
    ) ) ;
}

public static string
Hash
(
    byte[]                                     Subject
,
    System.Security.Cryptography.HashAlgorithm Provider
)
{
    System.Text.StringBuilder result = 
        new System.Text.StringBuilder ( Provider.OutputBlockSize ) ;

    foreach 
    ( 
        byte b 
    in 
        Provider.ComputeHash ( Subject ) 
    )
    {
        result.Append ( b.ToString ( "X2" ) ) ;
    }

    return ( result.ToString() ) ;
}

PIEBALDconsult wrote:

Passwords should not be case-sensitive