Answers were Sorted based on User's Feedback
Answer / reva ram sahu
constraint is a rule which can not be voilated by end users.
Different types of constraints are available.They are:-
1)default constraint:-which is used to define a default
2)primary key:-the key which does not allows duplication
and null values.
3)foreign key:-the key used to refer primary key defined
field in another table and it allows duplication.
4)null:-which allows NULL values.
5)not null:-which does not allows NULL values.
6)unique key:-which does not allows duplication but allows
|Is This Answer Correct ?||4 Yes||0 No|
Answer / surya
Constraints are used to provide the scope to table data...
|Is This Answer Correct ?||3 Yes||0 No|
Answer / anand
foreign key constraint
|Is This Answer Correct ?||0 Yes||1 No|
How to Run a Query on a Remote SQL Server?
Which is best Subquery (or) joins in sql server? explain why
how do u do Performance tunning ?
how to insert the values in 5 table at a time Using any single statement ?
How to retrieve data from log files in SQL SERVER ?????
What is normalization?
What command do we use to rename a db?
I am having table Title with TITLE id,Author ID, Publiser ID , table AUTHOR with Author ID, Author Name, table PUBLISER with Pub ID, Pub name Here hot to find out the publiser id who have relesed the books of patriticular author?
Why we need to use secondry database file? though, we can do same work using primary database file also.
1.How to check the backup file details if we do not have access to that folder 2.how to check the backup file size without connecting to the folder
Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .
i need to know how i display department which has salary > =5000 for the below table Department ----------- salary deptname 1000 a 3000 a 2000 b 3000 b 4000 c 5000 c kindly send the query to firstname.lastname@example.org