In this article, we will discuss how to Create, Alter, and Drop a database in SQL Server. In my previous article, we have discussed all about the Types of SQL Commands.
Database : In the SQL server a database is a place to store the data in an electronic format. It is an organized collection of database objects such as tables, views, functions, stored procedures, triggers and so on. It allows a user to easily access or manipulate the data.
Create Database In SQL Server
In SQL Server, there are two ways to create a user-defined database, either by using the Transact-SQL statements or by using SQL Server Management Studio.
SQL stands for Structured Query Language. SQL is a language used to store, retrieve, and manipulate data in a Relational Database Management Systems (RDMS) such as SQL Server, Oracle, MySQL, etc. SQL allows a user to communicate with the database using commands.
Features of SQL
SQL is used to create, truncate, and drop the database and table using SQL commands.
SQL can be used to execute the queries against the database to perform various operations.
SQL is used to create a function, stored procedure, trigger and view in a database.
It provides security and allows a users to set permissions on the tables, stored procedures, and views in the database.
What is a Database?
A database is a place to store the data in an electronic format. It is an organized collection of database objects such as tables, views, functions, stored procedures, triggers, and so on. It allows a user to easily access or manipulate the data.
Monitor class: In C#, the Monitor class provides a wait based synchronization mechanism that allows only one thread to access a critical section of code at a time to avoid the race condition. Here all the other threads have to wait and halt the execution until the locked object is released.
The Monitor.Enter method is used to acquire an exclusive lock on the object whereas Monitor.Exit method is used to release the locked object.
In order to use the Monitor class in a multithreading , we first need to import the System.Threading namespace.
This post series we will go through the understanding of the lock statement, monitor, mutex, and semaphore available in C#.
All of these classes provide a synchronization mechanism to protect the shared code or resources in a multithreadedapplication.
Let’s first understand the lock statement in C#.
C# Lock Statement
Lock Statement: In C#, the lock is a synchronization mechanism that allows only one thread to access a specified piece of code or a common field at a time.
It is mainly used to achieve an exclusive lock to avoid inconsistent output while reading and writing to a common variable in a multithreaded environment.
Generally, the lock keyword is placed around a critical section of code, where we want to allow only one thread to access the resource at a time. All the other threads have to wait and halt the execution until the locked object is released.
Pictorial representation of mutual exclusion of lock