SQLServerCentral: Content tagged Truncate Table

Truncate Table

By Vinay Kumar 2013/03/28 | Category: t-sql

Rating: (not yet rated) |

Discuss |

Briefcase | 2,033 reads

What will the max id be?

By Ben Kubicek 2012/12/19 | Category: identity property

Rating: (not yet rated) |

Discuss |

Briefcase | 2,046 reads

Table Variable

By Clare Newman 2012/08/16 | Category: t-sql

Rating: (not yet rated) |

Discuss |

Briefcase | 2,865 reads

T SQL

By Samith C 2012/07/10 | Category: t-sql

Rating: (not yet rated) |

Discuss |

Briefcase | 3,117 reads

Grant Truncate Table Permissions in SQL Server without ALTER Table

How do you grant a SQL Server developer truncate table permission without giving them the ability to alter the table? Check out the examples and explanation in this tip. Read more...

By Additional Articles 2012/01/16 | Source: MSSQLTips.com | Category: truncate table

Rating: (not yet rated) Rate this |

Briefcase | 2,643 reads

Difference between Truncate and Delete

This article explains you the differences between the Truncate and Delete commands in SQL. Read more...

By Prashant Pandey 2011/07/04 (first published: 2007/11/22) | Source: SQLServerCentral.com | Category: delete

Rating:

|

Discuss |

Briefcase | 27,530 reads

Truncate All Tables Part 2

Restore relationships between tables Read more...

By Jorge Novo-@ETLDEVDBA 2011/06/03 | Source: SQLServerCentral.com | Category: truncate table

Rating: (not yet rated) |

Discuss |

Briefcase | 944 reads

Truncate All Tables

Script to Truncate all tables part1 Read more...

By Jorge Novo-@ETLDEVDBA 2011/06/02 | Source: SQLServerCentral.com | Category: development

Rating:

|

Discuss |

Briefcase | 7,346 reads

Truncate Table Partition command in SQL Server

Procedure to automatically truncate table partition Read more...

By Vidyadhar Pandekar 2010/11/03 | Source: SQLServerCentral.com | Category: truncate table

Rating:

|

Discuss |

Briefcase | 4,717 reads

Truncate Transaction - All Databases

Script to help you to truncate TL for all databases. Read more...

By Disney Hammerschmidt 2010/05/03 | Source: SQLServerCentral.com | Category: administration

Rating:

|

Discuss |

Briefcase | 1,892 reads

Truncate Table Partition command in SQL Server

Procedure to automatically truncate table partition Read more...

By Vidyadhar Pandekar 2010/11/03 | Source: SQLServerCentral.com | Category: truncate table

Rating:

|

Discuss |

Briefcase | 4,717 reads

TRUNCATE

By Prakriti Agrawal 2010/02/05 | Category: truncate table

Rating: (not yet rated) |

Discuss |

Briefcase | 4,684 reads

usp_ShrinkAllLogs

Replacement script for usp_ShrinkDBLogs, updates for SQL 2008 deprecating the WITH TRUNCATE_ONLY method. Read more...

By Banyardi Schmardi 2009/11/27 | Source: SQLServerCentral.com | Category: truncate table

Rating:

|

Discuss |

Briefcase | 894 reads

Identity Crisis

By dun 2009/10/29 | Category: t-sql

Rating: (not yet rated) |

Discuss |

Briefcase | 4,706 reads

TRUNCATE vs DELETE

By Noel McKinney 2009/10/09 | Category: identity property

Rating: (not yet rated) |

Discuss |

Briefcase | 5,202 reads

sp_truncate

Truncates referenced tables Read more...

By Sergey Benner 2009/01/23 | Source: SQLServerCentral.com | Category: foreign keys (fk)

Rating:

|

Discuss |

Briefcase | 1,608 reads

Truncate Referenced Table

Often during the development phase one is required to truncate a table. often the task of removing foreign key references is necessary to truncate. this sp takes the pain out of it. Read more...

By Chris Morton 2009/01/19 | Source: SQLServerCentral.com | Category: foreign keys (fk)

Rating:

|

Discuss |

Briefcase | 1,225 reads