Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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
value.
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
NULL values.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
How to get the number of affected rows?
Do you know data definition language, data control language and data manipulation language?
What will be the maximum number of index per table?
What are joins in sql and what are the different types of joins?
in the physical file layout, where should the transaction log be stored in relation to the data file?
Explain datetime2 data type in sal server 2008?
What are the new features of sql server 2012 reporting service?
What is multi-statement table-value user-defined function?
What is tempdb in sql server?
Explain about link server in sql server?
when would you go for denormalization? : Sql server database administration
How will you monitor replication latency in transactional replication? : sql server replication
What are the different authentication modes in sql server?
You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?
In my application I have a process which picks the scanned files (tif format) from a shared location and it links to application and shown on it.The actuall issue is that my process picks the file before it is completly written or scanned which results in displaying few parts of the image or incomplete image.I need to check if the file is not completly scanned or written then do not link it to application.Please help if any body tell me that how can i check that file is in written phase or locked through DTS.thanking you in advance
