SQLServerLog.com

Category: SQL Commands

0

SQL Commands / SQL Server

SQL UPPER() Function

350viewsSQL 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

352viewsSQL 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

430viewsSQL 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

561views 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

423views 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

547viewsSQL 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...