IF condition1 THEN
statements;
ELSEIF condition2 THEN # OPTIONAL
statements;
ELSE # OPTIONAL
statements;
END IF;
Here is what the above code is Doing:
1. If condition1 is true, then execute the statements.
2. If condition1 is false, then check if condition2 is true. If condition2 is true, then execute the statements.
3. If condition1 and condition2 are both false, then execute the statements.
select * from Names where nameList like ‘a%’; Here is what the above code is Doing: 1. We’re selecting all the columns from the Names table. 2. We’re using the LIKE operator to find all the names that start with the letter ‘a’. 3. We’re using the wildcard character ‘%’ to match any number of…
SQLiteDatabase db = this.getReadableDatabase(); long count = DatabaseUtils.queryNumEntries(db, TABLE_NAME); db.close(); Here is what the above code is Doing: 1. Get a readable database 2. Use the DatabaseUtils class to get the number of rows in the table 3. Close the database
BEGIN TRANSACTION ;WITH CTE ….. SELECT…..etc. COMMIT TRANSACTION Here is what the above code is Doing: 1. It’s creating a temporary table called CTE. 2. It’s inserting the data from the table called “table1” into the temporary table called CTE. 3. It’s selecting the data from the temporary table called CTE. 4. It’s committing the…
Es gibt aber noch etliche Elemente, welche für die Definition der Datenstrukturen und für die Datenabfrage zuständig sind. SQL-Befehle sind grundsätzlich in drei Kategorien unterteilt: Art Beschreibung Befehl DML Data Manipulation Language SELECT, INSERT, UPDATE, DELETE DDL Data Definition Language CREATE, ALTER, DROP DCL Data Control Language GRANT, REVOKE Here is what the above code…
select top 0 * into #mytemptable from myrealtable Here is what the above code is Doing: 1. Create a temporary table with the same structure as the real table. 2. Insert the data from the real table into the temporary table. 3. Delete the data from the real table. 4. Insert the data from the…
USE Databasename SELECT ‘DROP TABLE [‘ + name + ‘];’ FROM sys.tables Here is what the above code is Doing: 1. It’s getting a list of all the tables in the database. 2. It’s looping through each table and generating a DROP TABLE statement for each table. 3. It’s printing out the DROP TABLE statement.