Procedure: [AdventureWorks2016CTP3].[SQLCop].[test]

CollapseAll image

Collapse image 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   

Collapse image Creation options


Name Value
QUOTED_IDENTIFIER ON
ANSI_NULLS ON

Collapse image Objects that [SQLCop].[test] depends on


Object name Object type Dep level
[SQLCop] Schema 1
Total 1 object(s)

Collapse image 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

Collapse image See also


List of procedures