摘要：本来以为挺简单的东西，还是费了点劲问题：用sql语句获取mdf默认存放路径这个路径没有放在sql server里面，而是在注册表里，路径是：HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQLServer，其中MSSQL10_50.MSSQLSERVER是sql server 2008的默认instance name，参考http://msdn.microsoft.com/en-us/library/ms143547.aspx。sql server里面可以用xp_insta 阅读全文

摘要：今天仔细差了一下SQL Sever中各种role的定义，记录备查 Predefined database roles You may need to create your own, but you ... 阅读全文

摘要：SQL Server 本地时间和UTC时间的相互转换的代码DECLARE @LocalDate DATETIME,@UTCDate DATETIME,@LocalDate2 DATETIMESET @LocalDate = GETDATE()SET @UTCDate = DATEADD(hour, DATEDIFF(hour,GETDATE(),GETUTCDATE()), @LocalDate)SET @LocalDate2 = DATEADD(hour, DATEDIFF(hour,GETUTCDATE(),GETDATE()), @UTCDate)SELECT '1. Now&# 阅读全文

摘要：DECLARE @Result INTDECLARE @Upper INTDECLARE @Lower INT SET @Lower = 1 SET @Upper = 10SELECT @Result = ROUND(((@Upper - @Lower -1) * RAND() + @Lower), 0)SELECT @Result 阅读全文

摘要：如何正确处理SQL Server嵌套事务 阅读全文