# Function: aaa

## Properties

Property | Value
--- | ---
Name | aaa
ID | 487672785
Schema | dbo
Owner | dbo
Execute As | Caller
Type | SQL SCALAR FUNCTION
Uses Ansi Nulls |
Uses Quoted Identifier |
Is Schema Bound |
Uses Database Collation |
Null on Null Input |
Encrypted |
MS Shipped |
Published |
Schema Published |
Deterministic |
Precise |
System Verified |
System Data Access |
User Data Access |
Modify Date | 12/7/2011 6:35:57 PM
Creation Date | 12/21/2010 5:37:50 AM

## Extended Properties

Name | Value
--- | ---
MS_Description | mobi

## Permissions

No object level permissions defined.

## Parameters

Parameter Name | Datatype | Has Default Value | Default Value | Read Only | Xml Document | Description
--- | --- | --- | --- | --- | --- | ---
@test | numeric(5,2) |  |  |  |  |

## Recordset Returned

Datatype | Has Default Value | Default Value | Xml Document | Description
--- | --- | --- | --- | ---
varchar(1) |  |  |  |

## Objects that depend on [aaa]

- dbo.aaa

## Objects on which [aaa] depends

- dbo.aaa

## SQL

Script
SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON create function aaa(@test numeric(5,2)) returns varchar as begin --Set @test = 'krystian' return 'zzz' end EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'mobi' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'FUNCTION',@level1name=N'aaa'

#### See also

List of Functions