摘要:
USE[master] GO ALTER DATABASE 数据库名称 SET RECOVERY SIMPLE WITH NO_WAIT GO ALTER DATABASE 数据库名称 SET RECOVERY SIMPLE --简单模式 GO USE [数据库名称] GO DBCC SHRINKF 阅读全文
摘要:
declare @des_xml nvarchar(max)set @des_xml ='<?xml verson="1.0" encoding="utf-8"?><province>'declare @id bigintdeclare @provinceid bigintdeclare @name nvarchar(50)declare cur cursorfor select * from T_Provincesopen curfetch next from cur into @id,@namewhile @@ 阅读全文