Search results
SQL Handwritten Notes Repository: A collection of PDF notes covering SQL concepts with concise definitions and examples. Explore fundamental commands, date/time functions, joins, and more. Contributions welcome!
Explain plan on a database with 11,000 rows in tbl1 and 3500 rows in tbl2 shows that it's doing a full table scan on tbl1. Seems to me that it should be faster if it could do a index query on tbl1. Update: I tried the hint a few of you suggested, and the explain cost got much worse!
Mobile-friendly 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.
24 maj 2021 · The IF…ELSE structure will execute a certain block of code if a specified condition is TRUE, and a different block of code if that condition is FALSE. Here is the basic layout and syntax of the IF…ELSE structure: IF(<condition is true>) BEGIN <execute some code> END ELSE BEGIN <execute some different code> END
12 wrz 2022 · Some examples of an argument might be "@NumberValue < 1", "@TextValue ='Hello' " ,or "BooleanFunction ()". Combining AND and OR keywords can sometimes yield surprising results. This tip about the WHERE clause details how those keywords work together. When the argument (s) evaluate as TRUE, the subsequent code is executed.
22 sty 2014 · SQL Server's full scans/sec performance counter sounds like a sure-fire way to identify problematic IO patterns. But this counter isn't as simple as you might thing.
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;
