随笔分类 -  SQL

What is a Database Trigger?
摘要：Link: http://www.essentialsql.com/what-is-a-database-trigger/ Copy... What is a Database Trigger? A database trigger is special stored procedure that 阅读全文
posted @ 2016-06-29 19:45 鱼悠游 阅读(332) 评论(0) 推荐(0)
SQL: See the TSQL underneath the sp_execute calls
摘要：When use SQL Server Profiler, on the Events Selection tab, check Show all events; Find the Store Procedures event, checkSP:StmtStarting and/or SP:Stmt... 阅读全文
posted @ 2015-12-04 11:01 鱼悠游 阅读(119) 评论(0) 推荐(0)
Modify a Stored Procedure using SQL Server Management Studio
摘要：In Object Explorer, connect to an instance ofDatabase Engineand then expand that instance.ExpandDatabases, expand the database in which the procedure ... 阅读全文
posted @ 2015-11-27 11:54 鱼悠游 阅读(184) 评论(0) 推荐(0)
Problem to create "New Database Diagram" in Microsoft SQL Server Management Studio for SQL Server 2012
摘要：Error:when click "New Database Diagram", a error popped up and said "Attempted to read or write protected memory. This is often an indication that oth... 阅读全文
posted @ 2014-11-04 13:07 鱼悠游 阅读(339) 评论(0) 推荐(0)
SQL: enable sa Account in SQL Server
摘要：Link:http://sudeeptaganguly.wordpress.com/2010/04/20/how-to-enable-sa-account-in-sql-server/引用：When you install the SQL Server using Windows Authentic... 阅读全文
posted @ 2014-10-16 14:19 鱼悠游 阅读(640) 评论(0) 推荐(0)