Procedure: uspCurrencyCursor

Properties

Property	Value
Name	uspCurrencyCursor
ID	647673355
Schema	dbo
Owner	dbo
Type	SQL STORED PROCEDURE
Execute As	Caller
Encrypted
ANSI NULLS
Uses Quoted Identifier
Published
Schema Published
Execution Replicated
Replication Serializable Only
Skips Replication Constraints
Is Recompiled
Uses Database Collation
Null on Null Input
MS Shipped
Modify Date	12/23/2010 8:11:33 AM
Create Date	12/23/2010 8:11:33 AM

Extended Properties

Name	Value
MS_Description	mobi uspCurencyCursor

Permissions

No object level permissions defined.

Parameters

Parameter Name	Datatype	Output	Cursor Ref	Readonly	Has Default Value	Default Value	Xml Collection Name	Description
@CurrencyCursor	int

Objects that depend on [uspCurrencyCursor]

dbo.uspCurrencyCursor

Objects on which [uspCurrencyCursor] depends

dbo.uspCurrencyCursor
- Sales.Currency
  - dbo.Name

SQL

Script
SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE PROCEDURE dbo.uspCurrencyCursor @CurrencyCursor CURSOR VARYING OUTPUT AS SET @CurrencyCursor = CURSOR FORWARD_ONLY STATIC FOR SELECT CurrencyCode, Name FROM Sales.Currency; OPEN @CurrencyCursor; EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'mobi uspCurencyCursor' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'PROCEDURE',@level1name=N'uspCurrencyCursor'

Script

SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE PROCEDURE dbo.uspCurrencyCursor @CurrencyCursor CURSOR VARYING OUTPUT AS SET @CurrencyCursor = CURSOR FORWARD_ONLY STATIC FOR SELECT CurrencyCode, Name FROM Sales.Currency; OPEN @CurrencyCursor;
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'mobi uspCurencyCursor' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'PROCEDURE',@level1name=N'uspCurrencyCursor'