60 seconds with Abhishek Kant, MVP India Lead(dotnetvj.com)

submitted by Kadiyalavj(580) 2 years, 9 months ago

60 seconds with Abhishek Kant: MVPs are champions of community. VJ caught up with Abhishek Kant, India MVP Lead, to get his view on the Microsoft Most Valuable Professional Program(MVP). read more...

add a comment |category: Community |Views: 7

tags: VijayaKadiyala dotnetvj Community another

Constraints in SQL Server (dotnetvj.com)

submitted by Kadiyalavj(580) 2 years, 9 months ago

There are total six types of constraints in SQL Server to implement different types of business rules and they are: 1) Check Constraints. 2) Rules 3) Default Constraints 4) Unique Constraints 5) Primary Key Constraints. 6) Foreign Key Constraints. read more...

add a comment |category: Database |Views: 6

tags: VijayaKadiyala dotnetvj Database another

RULE in SQL Server (dotnetvj.com)

submitted by Kadiyalavj(580) 2 years, 9 months ago

In this article I would like to explain about “Rules” which are part of Constraints family. Constraints are one of the key factors in designing a table. Constraints are mainly used to implement business rules. Let't take one real world example. When you are opening a bank account, there is a bank rule that says, you need to maintain a minimum balance of 1000 in your account. This is a business rule. read more...

add a comment |category: Database |Views: 3

tags: VijayaKadiyala dotnetvj Database another

Change Data Type in SQL Server (dotnetvj.com)

submitted by Kadiyalavj(580) 2 years, 10 months ago

Today, I will talk about how to change the data type of a column which has data. read more...

add a comment |category: Database |Views: 38

tags: Vijaya_Kadiyala VijayaKadiyala Database dotnetvj another

Add Primary Key in SQL Server(dotnetvj.com)

submitted by Kadiyalavj(580) 2 years, 10 months ago

In this story, I would like to share about adding a primary key to a table in SQL Server. One of the cirtical factor in database/table designing is to prevent duplicate records. There are several ways to do this. You can place Unique Index or Unique Constraint or add a primary key. Well there is only slight difference between these things. read more...

add a comment |category: Other |Views: 30

tags: VijayaKadiyala dotnetvj SQLServer another