Function: aaa Function: aaa| 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 |
| Name | Value |
|---|---|
| MS_Description | mobi |
| Parameter Name | Datatype | Has Default Value | Default Value | Read Only | Xml Document | Description |
|---|---|---|---|---|---|---|
| @test | numeric(5,2) |
|
|
|
| Datatype | Has Default Value | Default Value | Xml Document | Description |
|---|---|---|---|---|
| varchar(1) |
|
|
| 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' |