Examples and sample queries for various scenarios are provided below:
- Creating database
- Drop database
- Create database by defining size etc.,
- USE Command Example
- Creating tables
- Insert data into table
- Insert data into table without providing column names
- Update data in a table
- Deleting data from a table based on a condition
- Delete complete data from table
- Truncate data
- Simple Stored procedure
- Stored procedure with an input parameter
- Stored procedure with input and output parameters
