Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2007-03-12 : 09:29:17
|
| AnupG writes "hi, the most common feature that any RDBMS provides should be that if we want to store the data in the MSSQL tables then the data should be presented in masked/formatted like for eg.the password text in field should be like "*****". I am using SQL 2000 but i unofrtunately i couldn't find any such feature in defining the data type in SQL server 2000 ...?" |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-03-12 : 10:06:32
|
| RDBMS is by definition for the efficient storage and retrieval of the data. The masking/formatting of the password data is the feature of front-end and should be handled there.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2007-03-12 : 10:30:05
|
| Save the password as a one-way hash value.... |
|
|
|
|
|
|
how to mask password text in SQL field data type.