As soon as you start a new job, the first thing you should do is look up the version and edition details of the database
Author: SHAFI SHAIK
Hi, this is Shafi Shaik, Microsoft Solutions Specialist in Data platform as well as in Data Management & Analytics. I am a certified associate in Oracle SQL*Plus and extensively trained in MongoDB Administration. My current role is Database administration with hands-on expertise in almost all relational databases namely Microsoft SQL Server, MySQL, Oracle SQL*Plus, PostGreSQL & Teradata. I'm also specialized in database development, warehousing, traditional data analysis and Big Data analysis.
Cursors in SQL Server
An object called a database cursor makes it possible to browse through the rows of a result set. Unlike TSQL commands that operate on all
Example – Cursor in SQL Server
The following gives a SQL Server cursor example. It is useful to back-up all the databases from SQL Server. Please click here for more information
mysqldump – extended insert
By default, –extended-insert, -e is enabled when using mysqldump to create backups of MySQL databases. As seen in the example below, the dump file is
Answer to – SQL Assignment-4
Below is an attachment with the assignment #4 solution. You can execute it all at once in the “dbCall” database that was built in Assignment-4
SQL Assignment-4
There will be no complex stored procedures available anywhere if you look for them online since complexity arises when you have a requirement that leads
Big Data & SQL 