Modify the mssql database character set SQL

The code is as follows:

Copy code

Use master    If exists (select * from dbo. sysobjects where id = object_id (n' [dbo]. [p_killspid] ') and OBJECTPROPERTY (id, n' IsProcedure') = 1) Drop procedure [dbo]. [p_killspid] GO Create proc p_killspid @ Dbname varchar (200) -- Name of the database for which the process is to be disabled As Declare @ SQL nvarchar (500) Declare @ spid nvarchar (20)    Declare # tb cursor Select spid = cast (spid as varchar (20) from master .. sysprocesses where dbid = db_id (@ dbname) Open # tb Fetch next from # tb into @ spid While @ fetch_status = 0 Begin Exec ('Kill '+ @ spid) Fetch next from # tb into @ spid End Close # tb Deallocate # tb Go -- Close the connection to the database newhis Exec p_killspid 'database _ temp'    -- Change the sorting rule Alter database database_temp COLLATE Chinese_PRC_CI_AS    -- Delete the stored procedure after completion If exists (select * from dbo. sysobjects where id = object_id (n' [dbo]. [p_killspid] ') and OBJECTPROPERTY (id, n' IsProcedure') = 1) Drop procedure [dbo]. [p_killspid]