SQL RIGHT() Function
SQL 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...
Category: SQL Server
Configure SQL Server Memory To Optimize Performance
690viewsDatabase performance is always a headache for Database Administrators as over the time performance may degrade due to several reasons and DBAs has to identify and fix this issue. In previous articles we have...
SQL LEFT() Function
SQL 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...
SQL CHECK Constraint
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 that...
SQL AVG() Function
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 table...
SQL COUNT() Function
SQL 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...
