1. Create a stored procedure in SQL Server CREATE PROCEDURE (Transact-SQL)
2. I don't know what application is as client (WinForm/Web/WPF)
set TextLenght of the
You can use
for validating email address.
.NET Framework Regular Expressions
3. Call your stored procedure from your application and set its values.
HOW TO: Call a Parameterized Stored Procedure by Using ADO.NET and Visual C# .NET