Course Content

Course Content


The query tag is used to run a SQL query and get a collection of results. To update a database row, use the update tag. The transaction tag is used to atomically execute a set of SQL statements.

Select Edit -> SQL Formatter -> Format Current Query from the drop-down menu (or press F12). The present query would be the only one that was formatted. — Selected Query Format: Select the query(s) to be formatted from the set of query(s) to be formatted. (Ctrl+F12) Select Edit -> SQL Formatter -> Format Selected Query.

The FORMAT() function applies the provided format to a value (and an optional culture in SQL Server 2017). To format date/time and number values, use the FORMAT() function. Use CAST() or CONVERT for general data type conversions ().

  • Breaking down SQL queries into numerous lines makes them easier to read.
  • Proper indentation makes it easy to identify the data source, such as tables and joins.
  • Because the conditions are on distinct lines, you can run the query by commenting out one of the conditions, for example.

Share With Friend

Have a friend to whom you would want to share this course?

Download LearnVern App

App Preview Image
App QR Code Image
Code Scan or Download the app
Google Play Store
Apple App Store
598K+ Downloads
App Download Section Circle 1
4.57 Avg. Ratings
App Download Section Circle 2
15K+ Reviews
App Download Section Circle 3
  • Learn anywhere on the go
  • Get regular updates about your enrolled or new courses
  • Share content with your friends
  • Evaluate your progress through practice tests
  • No internet connection needed
  • Enroll for the webinar and join at the time of the webinar from anywhere