USP_INSTALLATIONINFO_UPDATEINSTALLATIONINFO
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @INSTALLATIONNAME | nvarchar(100) | IN | |
| @SERIALNUMBER | nvarchar(50) | IN |
Definition
Copy
create procedure dbo.USP_INSTALLATIONINFO_UPDATEINSTALLATIONINFO
@INSTALLATIONNAME nvarchar(100),
@SERIALNUMBER nvarchar(50)
with execute as caller
as
update dbo.INSTALLATIONINFO set INSTALLATIONNAME=@INSTALLATIONNAME ,SERIALNUMBER=@SERIALNUMBER
where ID=1
return 0