Stored procedure problem

[ray_jefferson]

Can a stored procedure calls a column name? For example, I have written a procedure namely "Myproc" and a table which contain a column namely "Password" as below:
CREATE PROCEDURE dbo.Myproc (@PswdString Varchar(255))

Can I execute the procedure by written as: EXEC dbo.Myproc @PswdString = 'Password' ????

Can I execute this procedure by using trigger?
CREATE TRIGGER admin_trigger
ON dbo.Admin
FOR update ,insert
AS
EXEC dbo.BasicClientUser @PwdString = 'Password'

Thanks a lot!!!!

[skhanal]

Yes you can. You are passing a paramteter to a stored procedure.