Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Posts
    3

    Question Unanswered: Store procedure problem

    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
    ON dbo.Admin
    FOR update ,insert
    AS
    EXEC dbo.BasicClientUser @PwdString = 'Password'

    Thanks a lot!!!!

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    EXEC myProc?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •