摘要:
/*http://msdn.microsoft.com/en-us/library/bb399731.aspx*/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOUSE [master];GOIF EXISTS (SELECT * FROM sys.databases WHERE name = 'School') DROP DATABASE School;... 阅读全文
摘要:
1.When you use stored procedures with only static SQL, users do not need direct permissions to access the tables, only permissions to execute the stored procedures, and thus you can use the stored pro... 阅读全文
摘要:
Today, when I tried to Alter a function in my database, I got the error info in the title. Then I tried some example function operations, and found the reason: Inline table-value function and Multi-St... 阅读全文
摘要:
When we look into a query plan, in a Seek Operation Node, we couldcan find 2 Properties: Predicate and Seek Predicate.Before I was really not clear about them, and today I read the bellow info: SQL Se... 阅读全文
摘要:
Sometimes you want to detect whether a service is running, and if not, you want to run it. Here is what you can do for the Sql Server Agent Service:EXEC master.dbo.xp_ServiceControl 'QUERYSTATE','SQLS... 阅读全文
摘要:
How to run a dos command from your C# code without showing a console window? Here is some code Icopy from http://www.neeao.com/blog/article-3341.htmlI have used it in my project, it works./**////<s... 阅读全文