Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
stored procedures and dynamic SQL
Name: khanati Date: November 1, 2005 at 05:41:16 Pacific OS: Windows XP CPU/Ram: 512
Comment:
Compare and contrast stored procedures and dynamic SQL.
Summary: A Stored Procedure (SP) is a chunk of code that is run by the database server, usually (if not always) triggered by a database event. SPs accept parameters and, I believe, can have local variables a...
Summary: I have a stored procedure that will not work, if I have an update in it. I assume this has something to do with a readonly access. I am running SQL Server 6.5 and I can run it fine from the query prog...
Summary: This is similar to another post that we figured out yesterday, where an update does not have a record set. In this case I have a stored procedure that does an update as well as passing back a value. ...
Check pattern of C++ stri...
