ALTER TABLE txoCheckDetails NOCHECK CONSTRAINT ALL
TRUNCATE TABLE txoCheckRequest
but am getting the following error.
Cannot truncate table 'txoCheckRequest' because it is being referenced by a FOREIGN KEY constraint.
So my questions is sinze I am diabling the only foriegn key constraint on the table it will not let me Truncate the table. I can do a DELETE on the table and remove everything, but how come I can't do a truncate.
Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.
SQL Server Integration Services can read XML files, that’s known by every BI developer. (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.)
But how far can you go? When does the XML Source component become …
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables.
Make a table:
Update a specific column given a specific row using the UPDATE statement:
Remove a set of values using the DELETE s…