How to insert user records the database using the SQL query with hashing password like Asp.Net MVC hashing mechanism

Question

I have batch of user accounts and every user account's password is not crypted.I want to insert to user accounts to the database using SQL Insert Query but I want to hash the passwords while insert like ASP.Net MVC hashing mechanism in the query. Is it possible , if it is how can I handle this? Thanks JavaScript questions and answers, JavaScript questions pdf, JavaScript question bank, JavaScript questions and answers pdf, mcq on JavaScript pdf, JavaScript questions and solutions, JavaScript mcq Test , Interview JavaScript questions, JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)

Answer 1

You can use HASHBYTES function for this. In my query i am hashing using MD5 algorithm. INSERT INTO Userdetails_Tab(username,passwd,..,..) values('test',HASHBYTES('MD5','testpass'),..,..)