jack13978590的专栏

原创 setup factory 会话变量

setup factory 会话变量 Session variables are special types of variables that are expanded at runtime when they are used. When they are used on screens, their values are automatically expanded for you, however if a session variable is used in an action script,

原创 SQLSERVER 针对数据库的重命名

use master go use pmdb_x3_CurName go -- 查看当前数据库逻辑名称 select name from sys.database_files; -- 修改数据库逻辑名称 -- mdf(旧逻辑名：pmdb__Data 新逻辑名：pmdb_x3_Data) alter database pmdb_x3_CurName modify file(name=pmdb_Data, newname=pmdb_x3_Data) -- log(旧逻辑名：pmdb_Log 新逻辑名：..

原创 SQLSERVER 关闭数据库连接 即可进行相关操作

use master declare @dbname varchar(50) set @dbname='数据库名' declare @sql varchar(50) declare cs_result cursor local for select 'kill '+cast(spid as varchar(50)) from master.sys.sysprocesses where db_name(dbid)=@dbname open cs_result fetch next from cs_resu.

原创 SQLSERVER 备份数据库的所有名称

DECLARE @FileName VARCHAR(200), @CurrentTime VARCHAR(50), @DBName VARCHAR(100), @SQL VARCHAR(1000), @FilePath varchar (1000) SET @CurrentTime = CONVERT(CHAR(8),GETDATE(),112) + CAST(DATEPART(hh, GETDATE()) AS VARCHAR) + CAST(...

原创 大家好，