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 - 2006-05-03 : 08:03:24
|
| pradeep writes "i am creating login form in asp.net.my problem is once we enter correct password it will expire 90 days after.how to create stored procedure to maintain password upto 90 days.kindly give answer" |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-05-03 : 10:23:48
|
| Have a column Password_crdate with datetime datatypeIn query usewhere getdate() between Password_crdate and Password_crdate +90MadhivananFailing to plan is Planning to fail |
 |
|
|
|
|
|
create storedprocedure