摘要:
一、web.config配置access数据库连接字符串<configuration> <appSettings> <add key="SQLConnString" value="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="/> <add key="dbPath" value="~/App_Data/mydb... 阅读全文
摘要:
USE[qanholas]GO/******对象:SqlAssembly[qanholas]脚本日期:11/19/201022:47:48******/CREATEASSEMBLY[qanholas]AUTHORIZATION[dbo]FROM0x4D5A90000300000004000000FFFF0000B8000000000000004000000000000000000000000000... 阅读全文
摘要:
--开启clr exec sp_configure 'show advanced options', '1' ; go reconfigure ; go exec sp_configure 'clr enabled', '1' go reconfigure ; exec sp_configure 'show advanced options', '1' ; go --创建cctv新用户,sa不行 create login [cctv] with password=N'123456', 阅读全文
摘要:
007500730069006E0067002000530079007300740065006D003B000A007500730069006E0067002000530079007300740065006D002E0043006F006C006C0065006300740069006F006E0073002E00470065006E0065007200690063003B000A00750073... 阅读全文
摘要:
CREATETABLEtb4039(c1INTIDENTITY,c2CHAR(4035)NOTNULL)CREATETABLEtb4040(c1INTIDENTITY,c2CHAR(4036)NOTNULL)DECLARE@iINTSET@i=1WHILE@i<=100BEGININSERTINTOtb4039(c2)VALUES('test'+CONVERT(VARCHAR(5),@i))... 阅读全文