After modifying the computer, server name, SQL Server correction job--Shansi

The author here to rearrange: rename the SQL Server operating system after the computer name of the correction job.
Today's collation is as follows:
(1) Fix @ @servername

Please use the following code to execute the amendment directly without having to fill in any information. When the execution is complete, the system shuts down automatically, and you only need to restart SQL Server.

DECLARE @sn sysname, @sno sysname;
SELECT @sn =cast (serverproperty (' servername ') as sysname), @sno =@ @SERVERNAME;
IF @sno is NULL
 BEGIN
  EXEC sp_addserver @server = @sn, @local = ' local ';
  SELECT N ' Finish the server name to revise, and has already stopped serving, please restart the server ';
  SELECT N ' Complete server name