TAILIEUCHUNG - Tổng quan SQL_ Visual Basic Function Reference

Finding all the most useful functions in Help can be difficult at best. When you know the function name you want, you can type it in the Visual Basic Editor, highlight the name, and then press F1 to go directly to the help topic. Following is a list of functions, categorized by type, that you might need to use. The tables list the function name and a brief description of what the function does. You can easily find details about the particular function syntax in Help once you know the function name | Part 9 Articles Article 3 Visual Basic Function Reference Finding all the most useful functions in Help can be difficult at best. When you know the function name you want you can type it in the Visual Basic Editor highlight the name and then press F1 to go directly to the help topic. Following is a list of functions categorized by type that you might need to use. The tables list the function name and a brief description of what the function does. You can easily find details about the particular function syntax in Help once you know the function name. As you know you can call most Visual Basic functions from queries that you create in an Access desktop database .mdb . If you convert your application to SQL Server you need to know the equivalent function or clause you can use to obtain the same result. The tables also list the SQL Server equivalent for all function types except User Interface File System Functions. Table A3-1. Arithmetic Functions Name Description SQL Server Equivalent Abs Returns the absolute value of a number. ABS Asc Returns the integer value of a character. ASCII Atn Returns the arctangent of a number. ATAN Cos Returns the cosine of a number that is an angle specified in radians. COS DDB Returns a double value containing the depreciation of a value for a specific time period. none Exp Returns the value of the base of the natural logarithm e raised to the exponent you supply. See also Log. EXP Fix Returns the value of the number you supply truncated to an integer. If the number is negative Fix returns the first integer that is greater than or equal to the number. See also Int. CAST CONVERT to tinyint smallint int or bigint FV Calculates the future value of an annuity. none A49 Part 9 Articles Article 3 Microsoft Office Access 2003 Inside Out Table A3-1. Arithmetic Functions Name Description SQL Server Equivalent Int Returns the value of the number you supply truncated to an integer. If the number is negative Int returns the first integer that is .

• Cơ sở dữ liệu
• Visual Basic Function Reference
• SQL
• tổng quan về SQL
• sơ sở dữ liệu
• công nghệ thông tin