December 3, 2013 at 12:31 pm
Hi,
I have a table and I'm doing a truncate table to that objects. The table has one key (two columns).
It seems that data is not always truncated.
Should I expect some kind of throubles because of the key?
Thank you
December 3, 2013 at 1:33 pm
river1 (12/3/2013)
Hi,I have a table and I'm doing a truncate table to that objects. The table has one key (two columns).
It seems that data is not always truncated.
Should I expect some kind of throubles because of the key?
Thank you
Not sure what you mean here.
TRUNCATE TABLE MyTable
The above will ALWAYS truncate the table unless there are foreign keys and it will raise an exception in that case.
Maybe you can explain more clearly what is happening? Post the statement you are running?
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply