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(); – – – – – – – – – – – – – – – – – – – – –…
C# for Java Developers – Reference List Source: download.microsoft.com
In a Nutshell Arithmetic in C# is very similar to virtually every other programming language out there, particularly C++, C, and Java. Addition works like this: int a = 3 + 4; Subtraction works like this: // int b = 7 – 2; Multiplication uses the asterisk character (‘*’) like this: //int c = 4 * 3; Division uses the forward slash character (‘/’) like this: int d = 21 / 7; The modulus operator (‘%’) gets the remainder of a…
