The BETWEEN operator is used to select values within a range. The SQL BETWEEN Operator The BETWEEN operator selects values within a range. The values can be numbers, text, or dates. SQL BETWEEN Syntax SELECT column_name(s) FROM table_name WHERE column_name BETWEEN value1 AND value2; Example SELECT * FROM Products WHERE Price BETWEEN 10 AND 20;
The IN Operator The IN operator allows you to specify multiple values in a WHERE clause. SQL IN Syntax SELECT column_name(s) FROM table_name WHERE column_name IN (value1,value2,…); Example SELECT * FROM Customers WHERE City IN (‘Paris’,’London’);
A wildcard character can be used to substitute for any other character(s) in a string. SQL Wildcard Characters In SQL, wildcard characters are used with the SQL LIKE operator. SQL wildcards are used to search for data within a table. With SQL, the wildcards are: Wildcard Description % A substitute for zero or more characters _ A substitute for a single character Matches only a character NOT specified…
The LIKE operator is used in a WHERE clause to search for a specified pattern in a column. The SQL LIKE Operator The LIKE operator is used to search for a specified pattern in a column. SQL LIKE Syntax SELECT column_name(s) FROM table_name WHERE column_name LIKE pattern; SQL LIKE Operator Examples The following SQL statement selects all customers with a City starting with the letter “s”: Example SELECT * FROM Customers WHERE City LIKE ‘s%’; or SELECT * FROM Customers WHERE Country LIKE ‘%land%’;
The SQL SELECT TOP Clause The SELECT TOP clause is used to specify the number of records to return. The SELECT TOP clause can be very useful on large tables with thousands of records. Returning a large number of records can impact on performance. Note: Not all database systems support the SELECT TOP clause. SQL Server / MS Access Syntax SELECT TOP number|percent column_name(s) FROM table_name; SQL SELECT TOP Equivalent in MySQL and Oracle MySQL Syntax SELECT column_name(s) FROM table_name LIMIT number; Example SELECT *…
Here are the 25 most common passwords of 2013, along with the change in rank from last year. 1. 123456 (Up 1) 2. password (Down 1) 3. 12345678 (Unchanged) 4. qwerty (Up 1) 5. abc123 (Down 1) 6. 123456789 (New) 7. 111111 ( Up 2) 8. 1234567 (Up 5) 9. iloveyou (Up 2) 10. adobe123 (New) 11. 123123 (Up 5) 12. admin (New) 13. 1234567890 (New) 14. letmein (Down 7) 15. photoshop (New) 16. 1234 (New) 17. monkey (Down…
Pseudocode is a kind of structured English for describing algorithms. It allows the designer to focus on the logic of the algorithm without being distracted by details of language syntax. At the same time, the pseudocode needs to be complete. It describe the entire logic of the algorithm so that implementation becomes a rote mechanical task of translating line by line into source code. In general the vocabulary used in the pseudocode should be the vocabulary of the problem…
Topic Overview Division in C# follows standard “integer division” rules when done with integer types. Many things are implicitly cast from narrow types to wider types. You can explicitly cast from one type to another by putting the type you want in parentheses in front (float a = (float)3.4948393;) Division by zero causes an exception to be thrown for integer types, and results in infinity for floating point types. NaN, PositiveInfinity, and NegativeInfinity are defined for the float and double types (float.NaN or Double.PositiveInfinity for example)….
1. Sign into Gmail and Google+ using your universal login details. 2. Click on the gear icon in the top right corner, then click on “Settings.” 3. Find the “Email via Google+” option (ninth down from the top). 4. Next to the question of “Who can email you via your Google+ profile?” click the drop-down menu to choose: anyone on Google+, extended circles, circles, or no one. That is all! Image:
LINQ to SQL in C# – Cheat Sheet Database context & database create var db = new MyDataContext(@”server=.\SQLEXPRESS;database=my;integrated security=SSPI”); if (!db.DatabaseExists()) db.CreateDatabase(); Select one Insert var only = db.Customers.SingleOrDefault(c => c.CustID == “CHIPS”); var first = db.Customers.FirstOrDefault(c => c.CustID == “CHIPS”); var customer = new Customer() { CustID = “CHIPS”, CompanyName = “Mr. Chips” }; db.Customers.InsertOnSubmit(customer); db.SubmitChanges(); – – – – – – – – – – – – – – – – – – – – –…
