For SQL 2005, delete the file: 02. 03. C:\Documents and Settings\\Application Da...
--合并表--输出调成以文本格式显示结果DECLARE pcur CURSOR FORSELECT a.name,a.object_idFROM sys.tab...
1.安装①指定数据库位置?mongod.exe --dbpath d:\test\mongodb\data?若不指定,默认为c:\data\db\②运行:?mo...
--1,修改文件逻辑位置--1)查询文件逻辑名,SELECT name logical_name, physical_name AS CurrentLocati...
select e.name as eventclass,t.loginname, t.spid, t.starttime,t.textdata, t.objec...
--1,VS新建数据库项目,,添加新项-sqlserverclr #,添加自定义函数,--函数前标记 [Microsoft.SqlServer.Server.S...
mssql中有一money类型,可以用来转换declare @num INTset @num = 4564654select replace(convert(v...
Conversion from INT to HEX SELECT CONVERT ( VARBINARY ( 8 ), 256 ) Converting fr...
create procedure sp_generate_insert_script @tablename_mask varchar(30) = NULLasb...
在job 运行代理步骤中加入: -OutputVerboseLevel 4 -Output C:\TEMP\mergeagent.log 运行复制job即可 引...