I am a beginner learner of SQL Server.
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))
How to write query to execute this stored proc?
Where I can call or invoke stored procedure besides in trigger?
Can I execute this procedure by using trigger?
CREATE TRIGGER admin_trigger
FOR update ,insert
EXEC dbo.BasicClientUser @PwdString = 'Password'