Save Each Worksheet as a Separate PDF in VBA
Hello friends!! We’ll be learning quick way to convert Excel sheets to PDF in VBA . These quick VBA tip will help you to save lot of time.
Read moreTag: Database
How to Use the SQL INSERT Statement
The INSERT statement in SQL allows you to add data to a table. Let’s take a look at it and see some examples in this article.
SQL: Update Statement
Today we’ll be learning about one of the most important statement in SQL that is ‘Update’ statement. As the name says Update statement is used to update the records in the existing table.
Below the table called new_table in database.
SQL Tips and Tricks
Today we’ll be learning some SQL tips and tricks that could save a lot of time.I’ll be using MYSQL workbench 6.3 for the tutorial. As you know SQL is not case sensitive so query can be written in either of the case.
Below is the table in the database named “new_table”
Excel Functions in SQL
Today we’ll be learning about SQL functions. We have functions in SQL similar to Excel.
The following Table ‘cricket’ we have.
SQL: Select Statement
Today we’ll be learning about the SELECT statement in SQL.
Query the entire table
Using the ‘Select *‘ statement in the query will return the entire table (all the columns and all the rows). Read more
SQL Basics: Start with SQL
In this tutorial we’ll be starting with SQL and learning basics. I’ll be using MYSQL workbench 6.3 for the tutorial.
SQL is NOT case sensitive: select is the same as SELECT. We can write our queries in either upper case or lower case or in both of them.