# 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'

#### See also

List of Procedures