1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22 |
ALTER PROCEDURE upd_tbl_customer
@customer_code int,
@customer_name nvarchar(50),
@customer_tell nvarchar(50),
@customer_address nvarchar(50),
@customer_debt nvarchar(50),
@customer_cm nvarchar(250)
AS
BEGIN
SET NOCOUNT ON;
-- Insert statements for procedure here
UPDATE dbo.customer set
customer_name=@customer_name,
customer_tell=@customer_tell,
customer_address=@customer_address,
customer_debt=@customer_debt,
customer_cm=@customer_cm WHERE customer_code=@customer_code
END
|
علاقه مندی ها (Bookmarks)