How to create Stored Procedure in SQL Server.

Question

To create a stored procedure in SQL Server, you need to start by connecting to your SQL Server instance using a SQL client or SQL Server Management Studio (SSMS). Ensure you have the necessary permissions to create stored procedures within the selected database.

Answer 1

Well. You don't have any special char need in your spec.

Define a strings like:
"abcdefghijklmnopqrstuvwxyz0123456789".
"abcdefghijklmnopqrstuvwxyz"
" 0123456789"
Have a boolean flag for each.
Algo:
1) Iterate through each pwd char. Make sure the char falls in above string. When char not found, set the flag to false. When a char is lower case letter set the relevant flag to true. When a char is digit set flag related to digit as true. At the end of iteration you can check the flags to satisfy first three points.
2) For fourth point you need a inner loop that again iterates through all your chars. Here you can check the repeatable patterns.