GetAsStatement Method (DbProvider)

Qualifies a column or table alias according to this provider's database type's rules regarding use of the AS keyword

Syntax

Visual Basic
C#

'Declaration
 
Public MustOverride Function GetAsStatement( _
   ByVal name As String _
) As String

public abstract string GetAsStatement( 
   string name
)

Parameters

name: The name of the column or table alias

Return Value

A string with or without the "AS" keyword as necessary for the underlying database type

Remarks

In MSSQL, the "AS" keyword is not always required, but can help to resolve ambiguity in SQL statements and is recommended. Oracle 8i and earlier do not support the use of the "AS" keyword. This method helps statement writers use column and table aliases without having to worry about underlying support for "AS".

Requirements

Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family

Reference

DbProvider Class
DbProvider Members

© 2010 Dovetail Software, Inc. - All rights reserved.
- Clarify, Amdocs, and related products and names are copyright and trademark of Amdocs, Inc.
- .NET, Visual Studio.NET, C#, Visual Basic and related products are trademark of Microsoft corporation.

Send comments on this topic.