Monday, March 2, 2009
How Can we use Truncate command on a table which is referenced by FOREIGN KEY?
We cannot use Truncate command on a table with Foreign Key because of referential integrity.
Subscribe to:
Post Comments (Atom)
skip to main |
skip to sidebar
Labels
SqlServer SourceCode - sqlserverdude.blogspot.com
Followers
Blog Archive
-
▼
2009
(50)
-
▼
March
(39)
-
▼
Mar 02
(39)
- How do you select a row using indexes.
- What is OLTP(OnLine Transaction Processing)
- What is the basic functions for master, msdb, mode...
- What are the different types of replication? Explain.
- Properties of Sub-Query
- What kind of User-Defined Functions can be created
- What is User Defined Functions?
- Difference between Function and Stored Procedure
- Define candidate key, alternate key, composite key.
- Difference between a primary key and a unique key
- How do you implement one-to-one, one-to-many and m...
- What is denormalization and when would you go for it
- What is BCP? When do we use it?
- What are the authentication modes in SQL Server
- What is a Linked Server
- When do you use SQL Profiler
- What is a Join in SQL Server
- What do you mean by COLLATION
- What command do we use to rename a db
- What is the use of DBCC commands?
- How Can we use Truncate command on a table which i...
- When do we use the UPDATE_STATISTICS command
- What are cursors
- What is an Index
- What is a View
- What is a Trigger
- What is Normalization
- What is Normalization
- How to copy data from one table to another
- How to Find all the Views within a Database
- how to select the second largest salary from a table?
- Types of Constraints
- Types of Joins
- Types of Transaction Isloation level in SQL server
- Difference between Delete and Truncate
- Type of cursors
- How Three command to get version or operating syst...
- How command to get all table names from a database
- What are sub-queries? Give example?
-
▼
Mar 02
(39)
-
▼
March
(39)
No comments:
Post a Comment