Procedure:
[AdventureWorks2016CTP3].[SQLCop].[test]
Procedure properties
| Name | Value |
| Schema | [SQLCop] |
| Owner | [dbo] |
| Creation date | 21.09.2016 |
| Type | P |
| Encrypted | |
| ID | 468912742 |
| Implementation type | Transact SQL |
| Is native compiled |
Creation options
| Name | Value |
| QUOTED_IDENTIFIER | ON |
| ANSI_NULLS | ON |
Objects that [SQLCop].[test] depends on
| Object name | Object type | Dep level |
| [SQLCop] | Schema | 1 |
SQL
SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON GO -- ============================================= -- Author: <Author,,Name> -- Create date: <Create Date,,> -- Description: <Description,,> -- ============================================= CREATE PROCEDURE [SQLCop].[test] AS BEGIN -- replace content of stored procedure -- with required test staments -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; END GO |
See also