SQLServerLog.com

Category: SQL Commands

0

SQL Commands / SQL Server

SQL UPPER() Function

315viewsSQL UPPER() function is used to convert character string from lower case to upper case. Syntax UPPER (CharacterString) Below is an example converting small letter character string to upper case. SELECT UPPER(‘sqlserverlog.com’) AS MyWebsite...

0

SQL Commands / SQL Server

SQL RIGHT() Function

314viewsSQL RIGHT() function returns substring from right side of specified string from a given column. If any column cell contains NULL value then it returns output as NULL for that value. Syntax SELECT RIGHT...

0

SQL Commands / SQL Server

SQL LEFT() Function

381viewsSQL LEFT() function returns substring from left side of specified string from a given column. If any column cell contains NULL value then it returns output as NULL for that value. Syntax SELECT LEFT...

0

SQL Commands / SQL Server

SQL CHECK Constraint

529views SQL CHECK constraint enforces a condition to check the value to be entered into a table. If you will define a CHECK constraint on a column then at the time of entering a record it evaluates...

0

SQL Commands / SQL Server

SQL AVG() Function

380views SQL AVG() function returns the average value of a numeric column of a table and it ignores NULL values during calculation. Syntax SELECT AVG(columnName) FROM TableName In this article we will consider Student...

0

SQL Commands / SQL Server

SQL COUNT() Function

520viewsSQL COUNT() function returns the number of records from a table in a SELECT statement. Syntax SELECT COUNT (columnName) FROM TableName OR SELECT COUNT (*) FROM TableName Note: Count(*) will return all the records...