In this article, we will see How to repair corrupt SQL Database (.mdf and .ndf) files
If you are working with the SQL database then usually you may face the problem of data corruption, whether taking backup on the daily basis is a good practice for data safety but however, if the backup is also corrupted, what should you do then?
In this article, we will see what is 'Computed Column in SQL Server'.
First of all What is a Computed column in SQL Server?
Computed column as the name gives an idea it's related to something calculation/ computation, Yes, computed columns are similar to a column in Excel with applied formula that calculate the value automatically of the given query or the columns.
Computed columns are columns with some user defined expression or with some formula to calculate the corresponding columns with operators or with some query.
In this article, we will see 'How to Create a SQL Server Database backup'.
Database backup using SQL Server Management Studio, SQL Server provides a large number of options to create backups. We will discuss here FULL BACKUP and DIFFERENTIAL BACKUP.
In this article, we will see how to use 'CROSS JOIN In SQL'
When each row of Table 1 is merged within each row of Table 2, then it's called a CROSS JOIN or Cartesian Join or in simple words, we can say it like CROSS JOIN always returns the Cartesian product of the sets of the record from (another two or more tables) joined table.
In this article, we will see How to update tables with joins in SQL. When we are dealing with the data we need to store that data in the database like MySQL, Oracle etc, In daily practices, we need to create tables, alterations that may be lead us to update table's data.
We can use iteration While loop or a Cursor for the same purpose but today we are talking about updating tables with joins in SQL.
DotNetKida is a Tech blog that provides Articles on various programming languages and technologies like HTML, CSS, Javascript, JQuery , C#, SQL, SQL Server , Windows Form Application, Asp.Net etc...
