https://blog.youkuaiyun.com/htl258zh-cnhttps://blog.youkuaiyun.com/https://blog.youkuaiyun.com/htl258/article/details/146463249https://blog.youkuaiyun.com/htl258/article/details/146463249htl258Sun, 23 Mar 2025 22:11:26 +0800https://blog.youkuaiyun.com/htl258/article/details/9526225https://blog.youkuaiyun.com/htl258/article/details/9526225htl258Sat, 27 Jul 2013 08:51:42 +0800https://blog.youkuaiyun.com/htl258/article/details/9455479https://blog.youkuaiyun.com/htl258/article/details/9455479htl258Wed, 24 Jul 2013 20:38:41 +0800https://blog.youkuaiyun.com/htl258/article/details/6458518https://blog.youkuaiyun.com/htl258/article/details/6458518htl258Wed, 01 Jun 2011 09:09:00 +0800fn_trace_gettable(Transact-SQL)
 
 
以表格格式返回一或多个跟踪文件的内容。
 
 Transact-SQL语法约定
 
语法
 
fn_trace_gettable(filename,number_files)
 
 
参数
filename
指定要读取的初始跟踪文件。filename的数据类型为nvarchar(256)]]>https://blog.youkuaiyun.com/htl258/article/details/6432846https://blog.youkuaiyun.com/htl258/article/details/6432846htl258Thu, 19 May 2011 18:49:00 +0800----------------------------------------------------------------------------------
-- Author : htl258(Tony)
-- Date   : 2011-05-19 17:25:59
-- Version: Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86)
--          Jul  9]]>https://blog.youkuaiyun.com/htl258/article/details/6427454https://blog.youkuaiyun.com/htl258/article/details/6427454htl258Tue, 17 May 2011 17:22:00 +0800----------------------------------------------------------------------------------
-- Author : htl258(Tony)
-- Date   : 2011-05-17 17:25:07
-- Version: Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86)
--          Jul  9]]>https://blog.youkuaiyun.com/htl258/article/details/5868521https://blog.youkuaiyun.com/htl258/article/details/5868521htl258Tue, 07 Sep 2010 14:32:00 +0800SQL_VARIANT_PROPERTY (Transact-SQL)
 
返回有关 sql_variant 值的基本数据类型和其他信息。
 
Transact-SQL 语法约定语法 SQL_VARIANT_PROPERTY (expression , property )参数expression
类型为 sql_variant 的表达式。property
包含将为其提供信息的 sql_variant 属性的名称。property ]]>https://blog.youkuaiyun.com/htl258/article/details/5733950https://blog.youkuaiyun.com/htl258/article/details/5733950htl258Wed, 14 Jul 2010 11:53:00 +0800https://blog.youkuaiyun.com/htl258/article/details/5717331https://blog.youkuaiyun.com/htl258/article/details/5717331htl258Wed, 07 Jul 2010 00:37:00 +0800----------------------------------------------------------------------------------
-- Author : htl258(Tony)
-- Date   : 2010-07-06 23:13:19
-- Version: Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86)
--          Jul  9]]>https://blog.youkuaiyun.com/htl258/article/details/5717165https://blog.youkuaiyun.com/htl258/article/details/5717165htl258Tue, 06 Jul 2010 22:37:00 +0800----------------------------------------------------------------------------------
-- Author : htl258(Tony)
-- Date   : 2010-07-06 18:33:50
-- Version: Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86)
--          Jul  9]]>https://blog.youkuaiyun.com/htl258/article/details/5717054https://blog.youkuaiyun.com/htl258/article/details/5717054htl258Tue, 06 Jul 2010 21:38:00 +0800----------------------------------------------------------------------------------
-- Author : htl258(Tony)
-- Date   : 2010-07-06 21:13:04
-- Version: Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86)
--          Jul  9]]>https://blog.youkuaiyun.com/htl258/article/details/5716976https://blog.youkuaiyun.com/htl258/article/details/5716976htl258Tue, 06 Jul 2010 20:59:00 +0800https://blog.youkuaiyun.com/htl258/article/details/5715979https://blog.youkuaiyun.com/htl258/article/details/5715979htl258Tue, 06 Jul 2010 14:33:00 +0800https://blog.youkuaiyun.com/htl258/article/details/5714444https://blog.youkuaiyun.com/htl258/article/details/5714444htl258Mon, 05 Jul 2010 20:04:00 +0800https://blog.youkuaiyun.com/htl258/article/details/5703627https://blog.youkuaiyun.com/htl258/article/details/5703627htl258Wed, 30 Jun 2010 09:39:00 +0800----------------------------------------------------------------------------------
-- Author : htl258(Tony)
-- Date   : 2010-06-30 09:35:18
-- Version: Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86)
--          Jul  9]]>https://blog.youkuaiyun.com/htl258/article/details/5698837https://blog.youkuaiyun.com/htl258/article/details/5698837htl258Mon, 28 Jun 2010 11:03:00 +0800--动态创建数据库实例(输入参数为数据库名、存储的路径名，数据库文件名与数据库名称相同)：
 USEmaster
 GO
 DECLARE@dbnameSYSNAME,@pathSYSNAME
 SELECT@dbname=CONVERT(VARCHAR,GETDATE(),112),
     @path='D:/DATA/'
 
 IFDB_ID(@dbname)>0
 EXEC('DROP DATABASE []]>https://blog.youkuaiyun.com/htl258/article/details/5696862https://blog.youkuaiyun.com/htl258/article/details/5696862htl258Sun, 27 Jun 2010 02:28:00 +0800https://blog.youkuaiyun.com/htl258/article/details/5696849https://blog.youkuaiyun.com/htl258/article/details/5696849htl258Sun, 27 Jun 2010 01:54:00 +0800
 
USEmydb
GO
--1. 新建测试用户
--1.1 添加登录用户和密码  
EXECsp_addloginN'tony','123'
--1.2 使其成为当前数据库的合法用户   
EXECsp_grantdbaccessN'tony'  
 
--2.设置操作授权
--2.1 授予对自己数据库的所有权限     
EXECsp_addrolememberN]]>https://blog.youkuaiyun.com/htl258/article/details/5696782https://blog.youkuaiyun.com/htl258/article/details/5696782htl258Sun, 27 Jun 2010 00:32:00 +0800https://blog.youkuaiyun.com/htl258/article/details/5696686https://blog.youkuaiyun.com/htl258/article/details/5696686htl258Sat, 26 Jun 2010 23:13:00 +0800