Don't get confused with the word "Constraints" as in English the meaning is totally different than what we are going to discuss today. SQL Constraints in simple words are the set of rules imposed on the data in the columns of a table. How should be the data in particular column, how should the data be displayed, which another data it is referring to and so on like these rules. So here I am going to add Interview Questions which are commonly asked about SQL Constraints in SQL with explanation … [Read more...] about SQL Constraint Interview Questions in Sql – Explained with Examples.
We have already seen how to add foreign key relationship from table designer in sql server. Now we are going to see how to add foreign key relationship using sql queries in sql server. In this we are going to create two tables Students and Department. We are going to add Foreign Key Relationship between these tables at the time of creation of tables using sql queries. create table Department( DepartmentID int not null, DName varchar(55), primary key(DepartmentID) ) create … [Read more...] about Add Foreign Key Relationship using Sql Queries in Sql Server
Before moving forward to the subject "Add foreign key relationship from table designer" I want to shed some light on the following stuff about database structure. In database creation and management, we know that it is very important to create tables in such a way which are easy to understand. Table structure should be simple to understand. So how would you create tables which are simple to manage and understand. Obviously by keeping the number of columns less. So how can you show more … [Read more...] about Add Foreign Key Relationship from Table Designer in Sql Server
You may have heard from people encouraging to learn code. Trying to get more interest in coding and programming like stuff. Every geek is talking about it. And yes there may be a lot of questions hitting your mind like what is the benefit of learning to code ? Why some of the guys are really curious about it ? Why Coding Will Make You An Awesome Geek Simple Answer Might Be Like Learning to code is very interesting. Its good to know how the technology and all IT related stuff around … [Read more...] about Why Coding Will Make You An Awesome Geek
Hey Geeks! I hope everything is going awesome with you guys. As an .NET Developer I want to share 10 things you should know while working in .NET. I have been working in .NET and have experienced some things that every .NET developer should need to know. In every field of developing there are some things, you may also call it basic information about the technical aspects of that particular technology. These 10 things that I am going to explain are very helpful for an .Net developer to grow in … [Read more...] about 10 things you should know while working in .NET