SQL Commands: The standard SQL commands to interact with relational databases are CREATE, SELECT, INSERT, UPDATE, DELETE and DROP DDL - Data Definition Language: CREATE: Creates a new table, a view of a table, or other object in the database ALTER: Modifies an existing database object, such as a table DROP: Deletes an entire table,
Read moreMicrosoft Azure Blob Storage is a scalable, online cloud data storage service that stores data blobs in containers. This article helps you understand how to write backups to and restore from the Azure Blob Storage Service and to do so we will create an Azure Blob Container, credentials for accessing the
Read moreSQL - Structured Query Language is further categorized on the basis of various commands and functionality types done by a particular set of keywords and the overall impact on a particular set of database objects. They are as follows:DDL - Data Definition LanguageDML - Data Manipulation LanguageDCL - Data Control
Read moreTechnologies Used: Visual Studio 2013 Express Sql Server 2008 R2 Express MVC 5 Nuget SqlDependency MSDN SignalR 2.0.1 Nuget Jquery 2.0.3 Nuget Toast Notifications Script to Create Broker & Service: create a user called "GeneralUser" with a password of "dbpassword" in your SQl Server logins. Run the following script in a Sql query pane, to create a message broker\service for
Read moreIf you have data in excel and you want to add data in you database using C# this is useful example. Follow below steps: Step 1: Create database tables to import data [crayon-661e31137aaac780594117/] Step 2: Add below namespaces in your project [crayon-661e31137aab6656411395/] Step 3: Add below method and send file path to this method as parameters. [crayon-661e31137aaba761925548/] This method get file path
Read more