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.
Hello, friends in my last article I wrote at length about various pitfalls which one can encounter while launching a startup. So, in continuation to that, I would like to highlight the challenges which are faced usually while raising series A, B, C funding. Make no mistake as much important it is to plan your product meticulously it is equally important to devise a clear strategy for persuading investors to invest in your product. Let's get this straight persuading doesn't work if your product … [Read more...] about Challenges for startups while raising funding
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
The tide has changed and so is the young and exuberant Indian youth. Also, with the initiation of startup India more and more people are getting inclined towards having their own startup and helping a cause. So far so good, right? But have you ever thought how many of us actually go on to make a real difference in the society with our idea or more precisely why is it that not all of us can have the same fairy sailing with our IDEA? I deliberately stressed over that word IDEA because that's where … [Read more...] about The familiar failings for STARTUPS