Show / Hide Table of Contents

GetAsStatement Method (DbProvider)

The name of the column or table alias

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

Syntax

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

Reference

DbProvider Class
DbProvider Members

Back to top © 2022 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.