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...
by Manzoor Siddiqui · Published September 10, 2015 · Last modified September 24, 2015
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...
Articles / Database Administration / Performance Tuning / SQL Server / SQL Tips and Tricks / SQL Troubleshooting / Tutorials
by Manzoor Siddiqui · Published September 9, 2015 · Last modified September 24, 2015
694viewsDatabase 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...
by Manzoor Siddiqui · Published September 8, 2015 · Last modified September 24, 2015
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...
by Manzoor Siddiqui · Published September 7, 2015 · Last modified October 20, 2015
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...
by Manzoor Siddiqui · Published September 6, 2015 · Last modified October 18, 2015
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...
by Manzoor Siddiqui · Published September 5, 2015 · Last modified September 24, 2015
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...
More