[OLD] SnowConvert - LIMITED ACCESS
  • SnowConvert Translation Reference
  • Licensing
  • Download and Access
  • For Teradata
    • Translation Reference
      • Scripts to Snowflake SQL Translation Reference
        • COMMON STATEMENTS
          • ERROR HANDLING
          • EXIT or QUIT
          • GOTO
          • IF... THEN...
        • BTEQ
        • MLOAD
          • Import
      • Scripts To Python Translation Reference
        • BTEQ
          • REPEAT
          • USING REQUEST MODIFIER
        • FLOAD
          • BEGIN LOADING
        • MLOAD
          • BEGIN MLOAD
        • TPT
        • SnowConvert Scripts Helpers
          • Technical Documentation
      • SQL Translation Reference
        • Built-in Functions
          • Cast to DATE using { }
          • Cast to INTERVAL datatype
          • COALESCE
          • DAYNUMBER_OF_MONTH
          • FROM_BYTES
          • GETQUERYBANDVALUE
          • JSON_CHECK
          • JSON_EXTRACT
          • JSON_TABLE
          • NEW JSON
          • NVP
          • OVERLAPS
          • PIVOT
          • P_INTERSECT
          • RANK
          • Regex functions
          • STRTOK_SPLIT_TO_TABLE
          • SUBSTRING
          • TD_UNPIVOT
          • TO_CHAR
          • XMLAGG
        • Database DBC
        • Data Types
        • DDL
          • Tables
          • Index
          • Views
        • DML
          • Delete Statement
          • Insert Statement
          • Select Statement
            • Expand On Clause
            • Normalize
            • Reset When
          • Set Operators
          • Update Statement
          • With Modifier
        • SnowConvert Procedures Helpers
          • Cursor Helper
          • Exec Helper
          • Functional Equivalence Helpers
          • Into Helper
      • Teradata to JavaScript Translation Reference
        • GET DIAGNOSTICS EXCEPTION
        • Macros
        • Procedures
      • Teradata to Snowflake Scripting Translation Reference
        • ABORT and ROLLBACK
        • BEGIN END
        • CASE
        • CREATE MACRO
        • CREATE PROCEDURE
        • CURSOR
        • DECLARE
        • DECLARE CONDITION HANDLER
        • DML and DDL Objects
        • EXCEPTION HANDLERS
        • EXECUTE IMMEDIATE
        • EXECUTE/EXEC
        • GET DIAGNOSTICS EXCEPTION
        • IF
        • LOOP
        • OUTPUT PARAMETERS
        • PREPARE
        • REPEAT
        • SET
        • WHILE
        • WITH DEFAULT
  • For Oracle
    • Translation Reference
      • Sample data
      • Basic Elements of Oracle SQL
        • Data Types
          • Oracle Built-in Data Types
            • Character Data Types
              • CHAR Data type
              • NCHAR Data Type
              • VARCHAR2 Data Type
              • VARCHAR Data Type
              • NVARCHAR2 Data Type
            • Numeric Data Types
              • NUMBER Data Type
              • FLOAT Data Type
              • Floating-Point Numbers
                • BINARY_FLOAT
                • BINARY_DOUBLE
            • LONG Data Type
            • Datetime and Interval Data Types
              • DATE Data Type
              • TIMESTAMP Data Type
              • TIMESTAMP WITH TIME ZONE Data Type
              • TIMESTAMP WITH LOCAL TIME ZONE Data Type
              • INTERVAL YEAR TO MONTH Data Type
              • INTERVAL DAY TO SECOND Data Type
              • Datetime Arithmetic
                • Interval UDFs vs Snowflake native interval operation
            • LOB Data Types
              • BFILE Data Type
              • BLOB Data Type
              • CLOB Data Type
              • NCLOB Data type
            • JSON Data Type
            • Extended Data Types
            • RAW and LONG RAW Data types
            • PL SQL Data Types
              • PLS_INTEGER Data Type
              • BINARY_INTEGER Data Type
          • Rowid Data Type
            • ROWID DataType
            • UROWID Data Type
          • ANSI Data Types
          • User-Defined Types
            • REF Data Types
          • Any Types
            • ANYTYPE
            • ANYDATA
            • ANYDATASET
          • XML Types
            • XMLType
            • URI Data Types
              • HTTPURIType
              • XDBURIType
              • DBURIType
            • URIFactory Package
          • Spatial Types
            • SDO_GEOMETRY
            • SDO_TOPO_GEOMETRY
            • SDO_GEORASTER
        • Literals
          • Text literals
      • Pseudocolumns
        • ROWID
        • ROWNUM
      • Built-in functions
        • SnowConvert Custom UDFs
          • BFILENAME UDF
          • DATE TO JULIANDAYS UDF
          • DATEADD UDF
          • DATEDIFF UDF
          • INTERVAL UDFs
            • DATEADD UDF INTERVAL
            • DATEDIFF UDF INTERVAL
          • JSDATE UDF
          • JSON_VALUE UDF
          • JULIAN TO GREGORIAN DATE UDF
          • MONTHS BETWEEN UDF [DEPRECATED]
          • REGEXP LIKE UDF
          • TIMESTAMP DIFF UDF
          • TRUNC (date) UDF
          • TRUNC (number) UDF
      • Built-In packages
        • DBMS_LOB
          • SUBSTR Function
        • DBMS_RANDOM
          • VALUE functions
        • DBMS_OUTPUT
          • PUT_LINE procedure
        • UTL_FILE
          • FOPEN procedure
          • PUT_LINE procedure
          • FCLOSE procedure
      • SQL Queries and Subqueries
        • Select
          • Select Flashback Query
        • Joins
          • Equijoin
          • Band Join
          • Self Join
          • Cartesian Products
          • Inner Join
          • Outer Join
          • Antijoin
          • Semijoin
      • SQL Statements
        • Alter Session
        • Alter Table
        • Create Materialized Views
        • Create Database Link
        • Create Index
        • Create Sequence
        • Create Synonym
        • Create Table
        • Create Type
          • Object Type Definition
          • Subtype Definition
          • Array Type Definition
          • Nested Table Type Definition
          • Member Function Definitions
        • Create View
        • Drop Table
      • PL/SQL to Snowflake Scripting
        • ASSIGNMENT STATEMENT
        • CALL
        • CASE
        • COLLECTIONS AND RECORDS
          • Associative Array Type Definition
          • Varray Type Definition
          • Nested Table Array Type Definition
          • Collection Methods
          • Collection Bulk Operations
            • WITH, SELECT, and BULK COLLECT INTO statements
          • Record Type Definition
        • COMPOUND STATEMENTS
        • CONTINUE
        • CREATE PROCEDURE
        • CURSOR
          • Workaround for cursors using parameters or procedure variables
          • Cursor Variables
        • DECLARE
        • DEFAULT PARAMETERS
        • DML STATEMENTS
          • INSERT Statement Extension
          • MERGE Statement
          • SELECT INTO Statement
          • Work around to simulate the use of Records
        • EXIT
        • EXPRESSIONS
        • EXECUTE IMMEDIATE
        • FORALL
        • FOR LOOP
        • HELPERS
          • Bulk Cursor Helpers
        • IF
        • IS EMPTY
        • LOG ERROR
        • LOOP
        • OUTPUT PARAMETERS
        • PACKAGES
          • DECLARATION
          • BODY
          • VARIABLES
          • Constants
        • PROCEDURE CALL
        • RAISE
        • RAISE_APPICATION_ERROR
        • UDF CALL
        • WHILE
      • PL/SQL to Javascript
        • Procedures
        • User defined functions
        • Packages
        • Helpers
          • EXEC Helper
          • Cursor Helper
          • Raise Helper
          • ROWTYPE Helper
          • Between operator helper
          • Like operator Helper
          • IS NULL Helper
          • Concat Value Helper
          • Package variables helper
          • Implicit Cursor attribute helper
        • Declarations
        • Control Statements
        • Conditional Compilation
        • Collections & Records
        • DDL - DML Statements
        • SQL Language Elements
        • Expressions and operators
        • Synonyms
        • Triggers
        • TYPE attribute
      • SQL*Plus
        • Archive Log
        • Attribute
        • Break
        • Btitle
        • Change
        • Column
        • Define
        • Host
        • Prompt
        • Remark
        • Set
        • Spool
        • Start
        • Whenever oserror
        • Whenever sqlerror
        • Show
        • Append
        • Accept
      • Wrapped objects
  • For SQL Server
    • Translation Reference
      • General Language Elements
        • EXECUTE
        • Collate
        • USE
        • OUTER APPLY
      • DDLs
        • Tables
        • Index
        • Views
        • Procedures
        • Functions
      • DMLs
        • Set Operators
        • Between
        • Update
        • Select
        • Insert
        • Delete
        • Merge
        • Exists
        • IN
        • Truncate
        • Drop
        • Bulk Insert
        • Common Table Expression (CTE)
        • Drops
      • Data Types
      • Statements
        • ALTER
          • TABLE
            • ADD
              • COLUMN DEFINITION
                • COLUMN CONSTRAINT
                  • FOREIGN KEY
                  • PRIMARY KEY / UNIQUE
                  • CHECK
              • TABLE CONSTRAINT
                • FOREIGN KEY
                • PRIMARY KEY
                • CHECK CONSTRAINT
                • CHECK
                • CONNECTION
                • DEFAULT
        • CREATE
          • FUNCTION
            • SCALAR
            • INLINE TABLE-VALUED
            • MULTI-STATEMENT TABLE-VALUED
      • Built-in functions
        • SnowConvert custom UDFs
          • IS_DATE_UDF
          • IS_MEMBER_UDF
          • IS_NUMERIC_UDF
          • OPENXML UDF
          • PARSE_NAME_UDF
          • PAT_INDEX_UDF
          • STR UDF
          • SWITCH_OFFSET_UDF
        • Aggregate functions
          • COUNT
          • COUNT_BIG
          • SUM
        • Analytic Functions
          • LAG
        • Conversion functions
          • CONVERT
          • TRY_CONVERT
        • Data Type functions
          • DATALENGTH
        • Date & Time functions
          • AT TIME ZONE
          • SWITCHOFFSET
          • DATEADD
          • DATEDIFF
          • DATEPART
          • DATEFROMPARTS
          • DATENAME
          • DAY
          • EOMONTH
          • GETDATE
          • MONTH
          • SYSDATETIME
          • SYSUTCDATETIME
          • YEAR
        • Logical functions
          • IIF
        • Mathematical functions
          • ABS
          • ACOS
            • ACOS in JS
          • ASIN
            • ASIN in JS
          • ATAN
            • ATAN in JS
          • ATN2
            • ATAN2 in JS
          • AVG
          • CEILING
          • COS
            • COS in JS
          • COT
            • COT in JS
          • DEGREES
            • DEGREES in JS
          • EXP
            • EXP in JS
          • FLOOR
          • LOG
            • LOG in JS
          • LOG10
            • LOG10 in JS
          • PI
            • PI in JS
          • POWER
            • POW in JS
          • SQUARE
          • STDEV
          • STDEVP
          • VAR
          • POWER
          • RADIANS
            • RADIANS in JS
          • ROUND
          • SQRT
        • Metadata functions
          • DB_NAME
          • OBJECT_ID
        • Ranking functions
          • DENSE_RANK
          • RANK
          • ROW_NUMBER
        • String functions
          • ASCII
            • ASCII in JS
          • CHAR
          • CHARINDEX
          • COALESCE
          • CONCAT
          • CONCAT_WS
            • Join in JS
          • DIFFERENCE
            • DIFFERENCE in JS
          • FORMAT
            • FORMAT in JS
          • LEFT
          • LEN
          • LOWER
          • LTRIM
            • LTRIM in JS
          • NCHAR
          • PATINDEX
            • search in JS
          • QUOTENAME
            • QUOTENAME in JS
          • REPLACE
          • REPLICATE
          • REVERSE
            • reverse in JS
          • RIGHT
          • RTRIM
          • SOUNDEX
            • SOUNDEX in JS
          • SPACE
          • STR
            • STR in JS
          • STRING_ESCAPE
            • stringify in JS
          • SUBSTRING
          • TRIM
            • trim in JS
          • UPPER
        • System functions
          • FORMATMESSAGE
            • FORMAT_MESSAGE_UDF
          • ISNULL
          • NEWID
          • NULLIF
        • XML Functions
          • Value
          • Query
      • Built-in procedures
        • Custom User Defined Procedures
          • SP_ADDEXTENDEDPROPERTY_UDP
          • THROW_UDP
      • Snowflake Scripting
        • CREATE PROCEDURE
        • CASE
        • CURSOR
        • DECLARE
        • EXECUTE
        • IF
        • SET
        • DMLs
        • CALL
        • WHILE
        • DROPs
        • BEGIN and COMMIT Transaction
        • OUTPUT PARAMETERS
        • LABEL and GOTO
        • SELECT
        • TRY CATCH
        • THROW
      • System Tables
        • SYS.FOREIGN_KEYS
      • Queries
        • TOP
  • ANSI SQL
    • Translation Reference
      • Data Types
        • Interval
      • Statements
        • CREATE TABLE
          • Basic Table
          • Table Scope
          • Column Definition
            • Character Set
            • Identity Column Specification
            • Column Constraint Definition
            • Collate Clause
          • Table Content Source
            • Like Table
            • As SubQuery
          • Table Options
            • Cluster By
            • On Commit
            • With System Versioning
        • INSERT
          • FROM SUBQUERY
        • CREATE VIEW
          • Basic View
          • Recursive Clause
          • As Select
        • Type Casts
  • For PostgreSQL
    • Translation Reference
      • General Language Elements
        • SET SEARCH PATH
        • GET DIAGNOSTICS - ROW_COUNT
      • Data Types
        • Unknown
      • Statements
        • ALTER FUNCTION
          • OWNER TO
        • SELECT STATEMENT
          • DISTINCT
          • LIMIT and OFFSET
        • ALTER TABLE
          • ADD Table Constraint
          • OWNER TO
        • COMMENT ON
        • CREATE TABLE
          • Table Constraint
            • Check Constraint
            • Unique Constraint
            • Primary Key Constraint
            • Exclude Constraint
            • Foreign Key Constraint
        • DELETE
          • Using clause
        • TRUNCATE
        • IF STATEMENT
        • WHILE STATEMENT
        • CURSOR DECLARATION
        • FOR STATEMENT
        • LOOP STATEMENT
        • Assign
        • EXECUTE
        • PERFORM
        • EXIT
        • SELECT INTO
      • Built-in functions
        • Aggregate Functions
          • Count
          • Max
          • Min
          • Sum
        • Window Functions
          • Row Number
        • Conditional Functions
          • Coalesce
        • Date/Time Functions
          • Age
          • Clock Timestamp
          • Date Trunc
          • Now
        • Mathematical Functions
          • Abs
        • String Functions
          • Btrim
          • Char Length
          • Length
          • Lower
          • Ltrim
          • Lpad
          • Position
          • Replace
          • Rpad
          • Rtrim
          • Substring/Substr
          • Upper
        • Data Type Formatting Functions
          • To Char
          • To Timestamp
      • Snowflake Scripting
        • Declare
      • Predicates
        • LIKE
  • For IBM DB2
    • Translation Reference
      • Statements
        • CREATE VIEW
          • OF type-name
          • WITH CHECK OPTION
          • WITH ROW MOVEMENT
        • SELECT
          • fullselect & subselect
            • From Clause
              • SINGLE TABLE REFERENCE
              • SINGLE VIEW REFERENCE
              • Single Nickname Reference
              • ONLY TABLE REFERENCE
              • OUTER TABLE REFERENCE
              • Analyze Table Expression
              • Nested Table Expression
              • Data Change Table Reference
              • Table Function Reference
              • Collection Derived Table
              • Xml table expression
              • Joined Table
              • External Table Reference
            • Values Clause
            • Having Clause
            • Order by Clause
          • Read only Clause
          • Update Clause
          • Optimize for Clause
          • Isolation Clause
          • Concurrent access resolution Clause
          • Offset Clause
          • Fetch Clause
        • INSERT STATEMENT
        • UPDATE STATEMENT
          • Update Target
          • Period Clause
          • Correlation Clause
          • Include Columns
          • Assignment Clause
          • From and Where Clause
          • Order By
          • Offset
          • Fetch
          • With Clause
          • Skip Locked
          • Wait Option
        • DELETE STATEMENT
          • Delete Target
          • Common Table Expresion
          • Period Clause
          • Correlation Clause
          • Include Columns
          • Assignment Clause
          • Where Clause
          • Order By
          • Offset
          • Fetch
          • With Clause
          • Wait Option
          • Skip Locked
        • CREATE TABLE
          • Content Source
            • Element List
              • Column Definition
                • Data Type
                • Column Options
                  • NOT NULL
                  • LOB OPTIONS
                  • SCOPE
                  • CONSTRAINT
                  • D/G CLAUSE
                    • Default Clause
                    • Generated Clause
                  • INLINE LENGTH
                  • COMPRESS
                  • SECURED
                  • HIDDEN
              • Period Definition
              • Unique Constraint
                • ENFORCED
                • QUERY OPTIMIZATION
                • WITHOUT OVERLAPS
              • Referential Constraint
              • Check Constraint
            • Of Type
            • Like Table
            • As Result Table
            • Materialized Query Definition
            • Staging Table Definition
          • Table Options
            • Organize By
            • Data Capture
            • Tablespace Clause
              • In Tablespace
              • Index In
              • Long In
            • Distribution Clause
            • Partitioning Clause
            • Compression Options
            • With Restrict on Drop
            • Not Logged Initially
            • CCSID
            • Security Policy
            • Options
      • Predicates
        • XMLEXISTS Predicate
        • VALIDATED Predicate
        • TYPE Predicate
        • Basic Predicate
        • Boolean Predicate
        • Quantified Predicate
        • JSON_EXISTS
        • OVERLAPS
        • LIKE Predicate
        • Null Predicate
        • REGEXP_LIKE Predicate
  • For Greenplum
    • Translation Reference
      • General Language Elements
      • Data Types
      • Statements
        • Comment On
        • CREATE INDEX
        • RAISE STATEMENT
        • CREATE TABLE
          • Table Constraint
          • Distributed Clause
          • Encoding Clause
          • With Clause
        • DELETE
        • TRUNCATE
        • CREATE EXTERNAL TABLE
        • CREATE FUNCTION
          • When Language is SQL
          • When Language is PLPGSQL
          • Output parameter
        • ALTER TABLE
        • ALTER EXTERNAL TABLE
        • EXECUTE
        • EXIT
      • Built-in functions
      • Snowflake Scripting
        • Declare
  • For Amazon Redshift
    • Translation Reference
      • General Language Elements
      • Data Types
      • Statements
        • ALTER TABLE
        • CREATE VIEW
        • CREATE MATERIALIZED VIEW
        • DELETE
        • EXECUTE
        • EXIT
        • CREATE TABLE
          • Column Attributes
            • DEFAULT
            • IDENTITY
            • GENERATED BY DEFAULT AS IDENTITY
            • ENCODE
            • DISTKEY
            • COLLATE
            • SORTKEY
          • Column Constraints
            • NOT NULL | NULL
            • UNIQUE | PRIMARY KEY
            • REFERENCES
          • Table Attributes
            • DISTSTYLE
            • DISTKEY
            • SORTKEY
            • ENCODE
          • Table Constraints
            • UNIQUE
            • PRIMARY KEY
            • FOREIGN KEY
      • Built-in functions
  • For Apache Hive
    • Translation Reference
      • Built-in functions
      • Data Types
      • DDL
      • General Language Elements
      • Hive Commands
        • Set
      • Reserved & Non-Reserved Keywords
      • Statements
        • Analyze Table
        • Create Table
          • Table Scope
            • If Not Exists
            • Temporary
            • External
          • Column Definition
          • Constraint Definition
          • Table Clauses
            • Comment
            • Partitioned By
            • Clustered By
            • Skewed By
            • Row Format
            • Stored As
            • Location
            • Table Properties
        • Create Table Like
        • Drop Table
  • For Vertica
    • Translation Reference
      • General Language Elements
      • Data Types
      • Statements
      • Built-in functions
  • For Google BigQuery
    • Translation Reference
      • General Language Elements
      • Identifier differences between BigQuery and Snowflake
      • Data Types
        • ANY TYPE
        • ARRAY<T>
        • BYTES
        • GEOGRAPHY
        • INTERVAL
        • JSON
        • STRUCT
        • TIMESTAMP
      • Statements
        • SELECT
          • FROM
        • CREATE FUNCTION
        • CREATE TABLE
          • TABLE SCOPE
            • OR REPLACE
            • TEMP/TEMPORARY
            • IF NOT EXISTS
          • COLUMN DEFINITION
          • CONSTRAINT DEFINITION
          • TABLE OPTIONS
            • DEFAULT COLLATE
            • PARTITION BY
            • CLUSTER BY
            • OPTIONS CLAUSE
            • AS query_statement
        • CREATE TABLE LIKE
        • CREATE TABLE COPY
        • CREATE TABLE CLONE
        • CREATE SNAPSHOT TABLE
        • CREATE EXTERNAL TABLE
        • CREATE VIEW
        • CREATE MATERIALIZED VIEW
        • CREATE SCHEMA
        • CREATE TABLE FUNCTION
        • CREATE PROCEDURE
        • REPEAT STATEMENT
        • WHILE STATEMENT
      • Procedural Language
        • DECLARE
        • CASE
        • SET
        • BEGIN ... END
        • BEGIN...EXCEPTION...END
        • IF
      • Built-in functions
        • Bytes Functions
          • FROM_HEX
          • FROM_BASE64
        • Geography Functions
          • ST_GEOGFROMTEXT
          • ST_GEOGPOINT
  • FOR SPARK (SCALA)
    • Translation Reference
      • SparkSession
        • Builder
        • Read
      • DataFrame
        • Write
      • Column
      • Functions
        • ltrim
        • rtrim
        • trim
      • Dataset
      • Window
      • Operators
        • SQRT
        • SQRT in JS
        • SQUARE
        • SQUARE in JS
        • TAN
        • TAN in JS
      • Import statements
      • Types
        • Column => Column
        • DataFrame => DataFrame
        • Dataset => DataFrame
        • SparkSession => Session
  • FOR SPARK SQL
    • Translation Reference
      • SQL Translation Reference
        • DDL
          • Create Table
            • Using
        • DML
          • Merge
          • Select Statement
            • Distinct
            • Values
            • Join
            • Where
            • Group By
            • Union
        • Data Types
  • FOR PYSPARK (PYTHON)
    • Translation Reference
      • column
      • dataframe
      • functions
        • struct
      • group
      • Import Statements
      • session
        • appName
        • SparkConf
        • SQLContext
        • HiveContext
        • SparkContext
      • RDD
      • readwriter
        • Format/Load
      • types
      • window
      • udf
      • SparkContext
      • StructType
  • General
    • Extensibility in SnowConvert
      • Additional Translation Rules
        • Technical Details
        • Working with ASTs
        • Extensibility API
          • SqlFunctionExprExtensions
          • BaseTranslationRule'2
          • BaseTranslationRule'3
        • Example
  • Assessment Properties
Powered by GitBook
On this page

Was this helpful?

  1. For SQL Server
  2. Translation Reference
  3. Built-in procedures

Custom User Defined Procedures

SP_ADDEXTENDEDPROPERTY_UDPTHROW_UDP
PreviousBuilt-in proceduresNextSP_ADDEXTENDEDPROPERTY_UDP

Was this helpful?