clankair的博客

selectGroupNum,Type,stuff((select ','+Namefrom ProjectRelation relaleft join AccountMedia media on media.id=rela.AccountMediaIDwhere rela.GroupNum = relamain.GroupNum and rela.Type = relamain.Type and rela.ProjectID = relamain.ProjectIDfor x.

1.b备份数据库时导出了一个1.63G的sql文件 2.在直接打开时SSMS报错Error HRESULT E_FAIL has been returned from a call to a COM component3.使用sqlcmd命令导入即可           sqlcmd -i 文件目录 -S ServerName -d DatabaseName               例如：  ...

sqlserver在已有表的基础上新增一列时，跟他相关联的试图出现列错位现象这时候会报各种错误，比如：Conversion failed when converting date and/or time from character string解决方法：来源  https://www.cnblogs.com/kcjm/p/6704059.html　　sp_refreshview ordervie...

declare @name nvarchar(50) declare @channelname nvarchar(50) declare @newid int declare @date datetime declare @weekday nvarchar(50) declare @begintime datetime decl...

“因为数据库正在使用，所以无法获得对数据库的独占访问权”，终解决方案如下关键SQL语句：ALTER DATABASE [datebase] SET OFFLINE WITH ROLLBACK IMMEDIATE用完之后再ALTERdatabase[datebase]setonline 来源：https://www.cnblogs.c...

1. CMD中运行 C:\Windows\Microsoft.NET\Framework64\v4.0.30319>aspnet_regsql.exe -S 数据库IP -U 登录名 -P 密码 -d Session数据库名称 -ssadd -sstype c2.启动SQL代理若显示xp禁止 无法启动则需要输入sp_configure 'show adv...

SELECTSPID = er.session_id,Status = ses.status,[Login] = ses.login_name,Host = ses.host_name,BlkBy = er.blocking_session_id,DBName = DB_Name(er.database_id),CommandType = er.command,SQLStateme...