chiyueqi的专栏

declare @count int ;     declare @curid varchar(50); --存放游标id     declare @createdate datetime;     declare @str varchar(max);          declare @date1 datetime;     declare @date2 datetime;    

USE [Learnmanager] GO /****** Object:  UserDefinedFunction [dbo].[getCount]    Script Date: 02/18/2016 14:23:48 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER function [dbo].[ge

1、备份数据库 2、备份日志文件。 USE DATABASENAME; GO -- Truncate the log by changing the database recovery model to SIMPLE. ALTER DATABASE DATABASENAME SET RECOVERY SIMPLE; GO -- Shrink the

ALTER proc [dbo].[sp_Report_GetProjectOrgChargeLinkMoney_ZH] ( @orgid varchar(50), @sqlwhere varchar(1000) ) as begin DECLARE @sql VARCHAR(8000); set @sql='WITH NODES  AS  ( select  par.ID,p