View Detailed Profile
SQL 076 Numeric Scalar, CHAR_LENGTH or How many string characters?

SQL 076 Numeric Scalar, CHAR_LENGTH or How many string characters?

Explains the

SQL 083 Numeric Scalar, POSITION or What is the starting position of a sub-string?

SQL 083 Numeric Scalar, POSITION or What is the starting position of a sub-string?

Explains the

SQL 074 Numeric Scalar, BIT_LENGTH or How many bits in the strings?

SQL 074 Numeric Scalar, BIT_LENGTH or How many bits in the strings?

Explains the

SQL 078 Numeric Scalar, EXTRACT or How do I get part of DATE/TIME?

SQL 078 Numeric Scalar, EXTRACT or How do I get part of DATE/TIME?

Explains the

SQL 082 Numeric Scalar, OCTET_LENGTH or How many 8 bits in a string?

SQL 082 Numeric Scalar, OCTET_LENGTH or How many 8 bits in a string?

Explains the

SQL 077 Numeric Scalar, EXP or Natural logarithm to the power of e

SQL 077 Numeric Scalar, EXP or Natural logarithm to the power of e

Explains the

SQL 084 Numeric Scalar, POWER or How do I raise a number to a power?

SQL 084 Numeric Scalar, POWER or How do I raise a number to a power?

Explains the

SQL 087 String Scalar, CONVERT or How can I change bits per character?

SQL 087 String Scalar, CONVERT or How can I change bits per character?

Explains the String

SQL 079 Numeric Scalar, FLOOR or How can I round values downward?

SQL 079 Numeric Scalar, FLOOR or How can I round values downward?

Explains the

How to write SCALAR function in SQL Server that returns a BIT

How to write SCALAR function in SQL Server that returns a BIT

In this video, I will show you how to write a

SQL 081 Numeric Scalar, MOD or How can I get the remainder of division?

SQL 081 Numeric Scalar, MOD or How can I get the remainder of division?

Explains the

SQL 085 Numeric Scalar, SQRT or Can I get a number's square root?

SQL 085 Numeric Scalar, SQRT or Can I get a number's square root?

Explains the

SQL 070 Scalar Functions, NULLIF or How can equal values give a NULL?

SQL 070 Scalar Functions, NULLIF or How can equal values give a NULL?

Explains the