SQL Constraint and Keys Archives - Page 10 of 14

SQL SERVER – 2008 – Interview Questions and Answers – Part 3

September 14, 2008

SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks

Database, SQL Constraint and Keys, SQL Index, SQL Scripts, SQL Utility

Click here to get free chapters (PDF) in the mailbox SQL SERVER – 2008 – Interview Questions and Answers Complete List Download 1) General Questions of SQL SERVER 2) Common Questions Asked Which TCP/IP port does SQL Server run on? How can it be changed? SQL Server runs on port…

SQL SERVER – Interview Questions and Answers – Part 2

September 13, 2008

Pinal Dave

SQL Interview Questions and Answers

Data Warehousing, SQL Constraint and Keys, SQL Cursor, SQL Function, SQL Index, SQL Joins, SQL Scripts, SQL Server, SQL Stored Procedure

This is the second part of the blog post series Interview Questions and Answers.Click here to get free chapters (PDF) in the mailbox

SQL SERVER – 2008 – Interview Questions and Answers – Part 1

September 12, 2008

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks

Database, SQL Constraint and Keys, SQL Index, SQL Scripts, SQL Stored Procedure, SQL Trigger

Click here to get free chapters (PDF) in the mailbox SQL SERVER – 2008 – Interview Questions and Answers Complete List Download 1) General Questions of SQL SERVER What is RDBMS? Relational Data Base Management Systems (RDBMS) are database management systems that maintain data records and indices in tables. Relationships…

SQL SERVER – 2008 – Creating Primary Key, Foreign Key and Default Constraint

September 8, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Constraint and Keys, SQL Scripts

Primary key, Foreign Key and Default constraint are the 3 main constraints that need to be considered while creating tables or even after that. It seems very easy to apply these constraints but still we have some confusions and problems while implementing it. So I tried to write about these…

SQL SERVER – Find Primary Key Using SQL Server Management Studio

September 6, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Constraint and Keys, SQL Index, SQL Scripts, SQL System Table

Imran Mohammed is great SQL Expert and always eager to help community members. He enjoys answering question and solving problems of other community fellows. His answers are always detailed and trustworthy. Today we will see interesting question from Prasant and excellent answer from Imran Mohammed. Question from Prasant: Hi, I…

SQL SERVER – Create Check Constraint on Column

June 22, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Constraint and Keys, SQL Error Messages, SQL Scripts

I found one of the Jr. Developer writing trigger for the requirement where he wanted to make sure invalidate data does not enter in table column. I suggested him to write Check Constraint. Check Constraints are very handy to make sure all the data in the table is validated before…

SQL SERVER – Create Default Constraint Over Table Column

May 31, 2008

Pinal Dave

SQL Tips and Tricks

SQL Constraint and Keys, SQL Scripts, SQL Server

Very frequently Jr. Developers request script for creating default constraint over table column. I have written following small script for creating default constraint. I think this will be useful to many other developers who want this script to keep handy.