The Normalisation is a data analysis technique to design a database system. The Normalisation allows the database designer to understand the current data structure within an organisation. The end result of a normalisation is a set of entity. We remove the unnecessary redudency by normalising the database table.
The Alias name is the name that is referred to any column name or table name that is given by user. The alias name also used to represent some column or table without using its real name. As we will proceed in this article we will see that how we can use both the alias [...]
The convert() function is used to convert an expression of one specific data type to another type. Also this function can be used to represent the value of date/time type variable in different different format. As we will discuss later in this post we will see how we accomplish this task.
In this article we will see that how can use and execute the SQL Commands in Visual Studio. In this article we are using C# language. As we proceed in this article you will see that what steps are required to perform this task. We need the two main classes to do this. These classes [...]
Today we will learn that how to use an if-else statement while inserting records into the database. We are talking about the SQL Server database. To understand this example we are understanding a problem that will make easy to learn if-else statement. Our problem is we want to insert a record into the table named [...]
While working with database we need to store our information time to time. and for that purpose we take the backup for that database. Backing up a database provide many solutions for us. The main thing is if we lost our database from SQL Server then we can restore our database from our computer. Also [...]
When we are working with Tables in Database we need to perform some basic operation with Tables. These operations may be inserting records, updating records etc. The most important operation we need to know about the table is fetching records from the Table, also we can say retrieving records from tables. Sometime we need to [...]
Hello guys, I hope you are enjoy reading article. Today we are going to discuss the Constraints that we need to use in SQL while programming. Some time we need to put some type of restriction on the column of the table. These restriction are called constraints. Also we are going to discuss the types [...]
A Combobox is a commonly used Control in WinForm. It is a combination of a List Box and a single-line TextBox, allowing the user to either type a value directly into the control or choose from the list of existing options. Sometime, We need to fetch the data from Database and bind data with Combobox Control, so [...]