1 Syntactic Sugar / Knowledgebase / Jak v MS SQL 2005 vygenerovat Hash pro heslo?
Knowledgebase
Hledej:     Rozšířené hledání
Prohlížej podle kategorii:
Glosář | Contact Us
Knowledgebase / SQL / Jak v MS SQL 2005 vygenerovat Hash pro heslo?

Jak v MS SQL 2005 vygenerovat Hash pro heslo?
Tisk
Email kamarádovi
Přidat komentář
Zobrazení: 611
Hlasů: 1
Komentářů: 1,661
Posted: 25 Jul, 2008
by: Horký J.
Updated: 25 Jul, 2008
by: Horký J.
Jako jsou pro tuto věc v MySQL funkce PASSWORD(), MD5(), SHA1() a další v MS SQL tyto funkce nejsou. Slouží k tomu funkce HashBytes('algoritmus', 'text pro hashování'). Tato funkce generuje hexadelimální hodnotu. Pokud tuto hodnotu potřebujeme převést na smysluplný text poslouží XML transformace.

  1. CREATE PROCEDURE HashPassword
  2.   @heslo nvarchar(max),
  3. AS
  4. BEGIN
  5. SELECT cast(N'' AS xml).value('xs:base64Binary(sql:column("t.hash"))', 'nvarchar(max)') AS sql_handle_base64
  6. FROM (SELECT HashBytes('SHA1',@heslo) AS hash) AS t;
  7. END


Ekvivalent v C#, který jsem se snažil nahradit, vypadá tahto:

  1.     public static string HashPassword(string heslo)
  2.     {
  3.       // hash the password for the password compare
  4.       SHA1 hash = new SHA1CryptoServiceProvider();
  5.       byte[] data = System.Text.Encoding.Unicode.GetBytes(heslo);
  6.       byte[] result = hash.ComputeHash(data);
  7.       
  8.       return Convert.ToBase64String(result);
  9.     }
Showing: 1-20 of 1661    »»
Komentáře

07 Jan, 2009   |   vimax
Beautiful site!

[URL=http://en.justin.tv/vimaxpills/profile]vimax[/URL]
[URL=http://en .justin.tv/acomplia/profile]acomplia online[/URL]
[URL=http://en.justin.tv/ramzes5/profile]penis enlargement pills[/URL]
[URL=http://en.justin.tv/propecia/profile]propecia[/URL]
[URL=http ://en.justin.tv/vigrx/profile]buy vigrx online[/URL]
07 Jan, 2009   |   acomplia
Perfect site, i like it!

[URL=http://www.twine.com/user/acomplia]acomplia[/URL]
[URL=http://www.k aboodle.com/propeciapills]cheap propecia[/URL]
[URL=http://www.kaboodle.com/acompliapills]acomplia online[/URL]
[URL=http://www.twine.com/user/penisenlargement]penis enlargement pills[/URL]
[URL=http://www.twine.com/user/propecia5]propecia online[/URL]
07 Jan, 2009   |   provestra
Great site. Keep doing.

[URL=http://www.livevideo.com/provesta]provestra[/URL]
[URL=http://ww w.livevideo.com/semenax]semenax[/URL]
[URL=http://www.livevideo.com/katana5]kat ana[/URL]
[URL=http://www.livevideo.com/Acomplia]acomplia online[/URL]
[URL=http://www.livevideo.com/Propecia5]propecia[/URL]
07 Jan, 2009   |   provestra
I want to say - thank you for this!

[URL=http://www.livevideo.com/provesta]cheap provestra[/URL]
[URL=http://www.livevideo.com/semenax]semenax online[/URL]
[URL=http://www.livevideo.com/katana5]katana[/URL]
[URL=http://ww w.livevideo.com/Acomplia]acomplia[/URL]
[URL=http://www.livevideo.com/Propecia5 ]propecia[/URL]
07 Jan, 2009   |   vimax
Very interesting site. Hope it will always be alive!

[URL=http://profiles.wikidot.com/profile:vimax]vimax[/URL]
[URL=http: //www.disaboom.com/members/BergerO.aspx]propecia online[/URL]
[URL=http://www.soundclick.com/members/default.cfm?member=vimax]vi max[/URL]
[URL=http://www.planetphotoshop.com/forum/member.php?u=7736]vimax online[/URL]
[URL=http://www.mylot.com/propecia5]propecia[/URL]
[URL=http://ww w.kaboodle.com/vimaxpills]vimax[/URL]
[URL=http://www.mylot.com/acomplia]acompl ia online[/URL]
[URL=http://www.livevideo.com/Acomplia]cheap acomplia[/URL]
[URL=http://www.livevideo.com/Propecia5]propecia[/URL]
07 Jan, 2009   |   penis_enlargement
I bookmarked this guestbook. Thank you for good job!

[URL=http://www.youtube.com/user/GenericAcompliaO]acomplia[/URL]
[URL=h ttp://www.youtube.com/user/VimaxPills555]vimax[/URL]
[URL=http://www.youtube.co m/user/VigrxPlusCheap]cheap vigrx[/URL]
[URL=http://www.youtube.com/user/PenisEnlargement5]penis enlargement[/URL]
[URL=http://www.youtube.com/user/GenericPropeciaO]propecia[/U RL]
07 Jan, 2009   |   vimax
Great site. Keep doing.

[URL=http://www.youtube.com/user/GenericAcompliaO]acomplia[/URL]
vimax
[URL=http://www.youtube. com/user/VigrxPlusCheap]vigrx[/URL]
[URL=http://www.youtube.com/user/PenisEnlar gement5]penis enlargement[/URL]
[URL=http://www.youtube.com/user/GenericPropeciaO]propecia[/U RL]
07 Jan, 2009   |   penis_enlargement_pills
Great site. Good info

[URL=http://en.justin.tv/vimaxpills/profile]vimax[/URL]
[URL=http://en. justin.tv/acomplia/profile]buy acomplia[/URL]
[URL=http://en.justin.tv/ramzes5/profile]penis enlargement pills[/URL]
[URL=http://en.justin.tv/propecia/profile]buy propecia online[/URL]
[URL=http://en.justin.tv/vigrx/profile]vigrx[/URL]
07 Jan, 2009   |   katana
Great .Now i can say thank you!

[URL=http://www.livevideo.com/provesta]buy provestra[/URL]
[URL=http://www.livevideo.com/semenax]semenax[/URL]
[URL=http: //www.livevideo.com/katana5]buy katana[/URL]
[URL=http://www.livevideo.com/Acomplia]acomplia[/URL]
[URL=http:/ /www.livevideo.com/Propecia5]propecia online[/URL]
07 Jan, 2009   |   acomplia
It is the coolest site,keep so!

[URL=http://profiles.wikidot.com/profile:vimax]vimax online[/URL]
[URL=http://www.disaboom.com/members/BergerO.aspx]propecia[/URL]
[URL=http://www.soundclick.com/members/default.cfm?member=vimax]cheap vimax[/URL]
[URL=http://www.planetphotoshop.com/forum/member.php?u=7736]vimax[/ URL]
[URL=http://www.mylot.com/propecia5]propecia[/URL]
[URL=http://www.kabood le.com/vimaxpills]vimax[/URL]
[URL=http://www.mylot.com/acomplia]cheap acomplia[/URL]
[URL=http://www.livevideo.com/Acomplia]acomplia[/URL]
[URL=http ://www.livevideo.com/Propecia5]propecia[/URL]
07 Jan, 2009   |   propecia
Great site. Good info

[URL=http://www.youtube.com/user/GenericAcompliaO]acomplia[/URL]
[URL=h ttp://www.youtube.com/user/VimaxPills555]cheap vimax[/URL]
[URL=http://www.youtube.com/user/VigrxPlusCheap]vigrx[/URL]
[URL=h ttp://www.youtube.com/user/PenisEnlargement5]penis enlargement[/URL]
[URL=http://www.youtube.com/user/GenericPropeciaO]propecia[/U RL]
07 Jan, 2009   |   acomplia
Perfect work!

[URL=http://www.twine.com/user/acomplia]acomplia[/URL]
[URL=http://www .kaboodle.com/propeciapills]propecia[/URL]
[URL=http://www.kaboodle.com/acompli apills]acomplia online[/URL]
[URL=http://www.twine.com/user/penisenlargement]penis enlargement pills[/URL]
[URL=http://www.twine.com/user/propecia5]propecia[/URL]
07 Jan, 2009   |   provestra
Great site. Good info

[URL=http://www.livevideo.com/provesta]provestra[/URL]
[URL=http://www. livevideo.com/semenax]semenax[/URL]
[URL=http://www.livevideo.com/katana5]katan a[/URL]
[URL=http://www.livevideo.com/Acomplia]acomplia[/URL]
[URL=http://www. livevideo.com/Propecia5]propecia[/URL]
07 Jan, 2009   |   semenax
I bookmarked this guestbook. Thank you for good job!

[URL=http://www.livevideo.com/provesta]provestra online[/URL]
[URL=http://www.livevideo.com/semenax]cheap semenax[/URL]
[URL=http://www.livevideo.com/katana5]katana[/URL]
[URL=http://w ww.livevideo.com/Acomplia]acomplia[/URL]
[URL=http://www.livevideo.com/Propecia 5]propecia online[/URL]
07 Jan, 2009   |   propecia
If you have to do it, you might as well do it right

[URL=http://www.youtube.com/user/GenericAcompliaO]buy acomplia[/URL]
[URL=http://www.youtube.com/user/VimaxPills555]vimax[/URL]
cheap vigrx
[URL=http://www.youtube.com/user/PenisEnlargement5]cheap penis enlargement[/URL]
[URL=http://www.youtube.com/user/GenericPropeciaO]propecia[/U RL]
07 Jan, 2009   |   penis_enlargement
Great site. Good info

[URL=http://www.youtube.com/user/GenericAcompliaO]acomplia[/URL]
[URL=h ttp://www.youtube.com/user/VimaxPills555]vimax online[/URL]
[URL=http://www.youtube.com/user/VigrxPlusCheap]vigrx[/URL]
[URL= penis]http://www.youtube.com/user/PenisEnlargement5]penis enlargement[/URL]
[URL=http://www.youtube.com/user/GenericPropeciaO]propecia[/U RL]
07 Jan, 2009   |   acomplia
If you have to do it, you might as well do it right

[URL=http://en.justin.tv/vimaxpills/profile]vimax[/URL]
[URL=http://en .justin.tv/acomplia/profile]acomplia[/URL]
[URL=http://en.justin.tv/ramzes5/pro file]penis enlargement pills[/URL]
[URL=http://en.justin.tv/propecia/profile]propecia[/URL]
[URL=http ://en.justin.tv/vigrx/profile]vigrx[/URL]
07 Jan, 2009   |   vimax
Great site. Good info

[URL=http://profiles.wikidot.com/profile:vimax]vimax[/URL]
[URL=http:// cheap]www.disaboom.com/members/BergerO.aspx]cheap propecia[/URL]
[URL=http://www.soundclick.com/members/default.cfm?member=vimax] cheap vimax[/URL]
[URL=http://www.planetphotoshop.com/forum/member.php?u=7736]vimax[/ URL]
[URL=http://www.mylot.com/propecia5]propecia[/URL]
[URL=http://www.kabood le.com/vimaxpills]vimax[/URL]
[URL=http://www.mylot.com/acomplia]acomplia[/URL]
[URL=http://www.livevideo.com/Acomplia]acomplia[/URL]
[URL=http://www.livevid eo.com/Propecia5]propecia[/URL]
07 Jan, 2009   |   katana
Great site. Keep doing.

[URL=http://www.livevideo.com/provesta]provestra[/URL]
[URL=http://ww w.livevideo.com/semenax]semenax online[/URL]
[URL=http://www.livevideo.com/katana5]katana[/URL]
[URL=http://ww w.livevideo.com/Acomplia]acomplia[/URL]
[URL=http://www.livevideo.com/Propecia5 ]propecia[/URL]
07 Jan, 2009   |   propecia
Perfect site, i like it!

[URL=http://www.twine.com/user/acomplia]acomplia[/URL]
[URL=http://www.k aboodle.com/propeciapills]propecia[/URL]
[URL=http://www.kaboodle.com/acompliap ills]cheap acomplia[/URL]
[URL=http://www.twine.com/user/penisenlargement]penis enlargement pills online[/URL]
[URL=http://www.twine.com/user/propecia5]propecia[/URL]
Showing: 1-20 of 1661    »»


Přidat komentář

Others in this Category
document Jak získat datumovou nebo časovou část z atributů typu DateTime...
document How to pass an unknown number of input parameters (or an array) into the stored procedure


RSS
Powered by KBPublisher (Knowledge base software)