You are currently viewing the BOOK: Beginning T-SQL with Microsoft SQL Server 20 ISBN: 978-0-470-25703-6 section of the Wrox Programmer to Programmer discussions.
This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. By joining today you can post your own programming questions, respond to other developers questions, and eliminate the ads that are displayed to guests. This forum seemed like a party that died years ago!
CREATE PROCEDURE dbo.sp_Students_UPD_by PK @active_flg TINYINT = NULL , @student_id INT AS BEGIN SET NOCOUNT ON UPDATE dbo.
Students SET active_flg = ISNULL(@active_flg , active_flg) FROM dbo.
I don't want to change the name but instead is it as an attribute in the Where clause. Novice Here is an example of a table for a store: In this table I would like to use the Stored Procedure to update all aspects of the tbl Store using the store Name and the Store Branch as a specifier in a where clause.