Search results
1 cze 2021 · Standard SQL Functions Cheat Sheet. TEXT FUNCTIONS. CONCATENATION. Use the || operator to concatenate two strings: SELECT 'Hi ' || 'there!'; -- result: Hi there! Remember that you can concatenate only character strings using. ||. Use this trick for numbers: SELECT '' || 4 || 2; -- result: 42.
1 cze 2021 · Standard SQL Functions Cheat Sheet. TEXT FUNCTIONS. CONCATENATION. Use the || operator to concatenate two strings: SELECT 'Hi ' || 'there!'; -- result: Hi there! Remember that you can concatenate only character strings using. ||. Use this trick for numbers: SELECT '' || 4 || 2;
2 mar 2012 · Just use the FORMAT function (works on SQL Server 2012 or newer): SELECT FORMAT(EmployeeID, '000000') FROM dbo.RequestItems WHERE ID=0 Reference: http://msdn.microsoft.com/en-us/library/hh213505.aspx
25 sie 2021 · This 2-page SQL Basics Cheat Sheet will be a great value for beginners as well as for professionals. Download it in PDF or PNG format.
SELECT LENGTH(first_name) FROM table_name ORDER BY length DESC; Function to return the length of each field entry, e.g. this could find us the longest number of letters used for the first_name field SELECT POSITION('@' IN email) FROM table_name; Function to return which position the @ sign occurs in SELECT TRIM(first_name) FROM table_name;
Whether you need a quick reference for major SQL concepts before an interview, or you want to level-up your existing SQL skills, our SQL cheat sheet is the ideal starting point. Plus, we’ve broken it down into 11 essential SQL topics to help you get the most from this SQL query cheat sheet.
12 wrz 2022 · Learn how to build conditional logic when writing SQL code using IF, BEGIN, END, ELSE, and ELSEIF logic.
