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 mastergouse pmdb_x3_CurNamego-- 查看当前数据库逻辑名称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 masterdeclare @dbname varchar(50)set @dbname='数据库名'declare @sql varchar(50)declare cs_result cursor local forselect 'kill '+cast(spid as varchar(50)) from master.sys.sysprocesses where db_name(dbid)=@dbnameopen cs_resultfetch 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(...

原创 大家好，