Hi Tracy! In a stored procedure, you can have both input variables and output variables. If you modify your stored procedure such as: CREATE PROCEDURE UpdateInfo @EmpID int AS Select * from tblEmployee where EmpID = @EmpID Return(0) GO Your @EmpID now becomes an input variable. Your stored procedure can now be called with something […]
2003-06-19
There is an option NOT FOR REPLICATION which you can use when you create the trigger. Never used it myself, hence best to read BOL see the t-sql reference for 'CREATE TRIGGER' Regards Steven
2003-06-14
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers