Skip to primary content
Skip to secondary content

Spearcross

All About Programming, Piece of My Mind, And Anything

Spearcross

Main menu

  • Home
  • About

Tag Archives: Reseed

SQL Query For Reset Table Identity

Posted on August 3, 2012 by silentcross
Reply

This is SQL Query for resetting Table Indentity :

1
DBCC CHECKIDENT ([Table_Name], reseed, Reset_Number_To)

place your Table Name in [Table_Name] and replace Reset_Number_To with number you want to start the identity for the next record, for example if you want your identity number start from 1, you replace Reset_Number_To with 0

Posted in Programming | Tagged Reseed, SQL, SQL Query | Leave a reply

Recent Posts

  • Run Deepseek R1 With Ollama + (Open Webui Docker) Easy way
  • Mikrotik Script For auto reconnect PPPOE to get Public IP
  • Change to another Hosting & 2020 Updates
  • DDNS Cloudflare API
  • Change Hosting in 2018

Categories

  • ASP.NET (2)
  • C (1)
  • Event (3)
  • FreeWare (2)
  • IIS (5)
  • Intro (1)
  • Linux (3)
  • News (3)
  • PHP (4)
  • Piece of My Mind (18)
  • Programming (17)
  • Uncategorized (8)
  • Windows (12)

Tags

  • .NET
  • AI
  • Apache2
  • ASP.NET
  • ASP.NET CORE
  • ASUS
  • blog
  • Cloudflare
  • DDNS
  • Deepseek R1
  • Event
  • Hosting
  • IIS
  • IIS 6
  • IndoComtech
  • Linux
  • Mikrotik
  • MS SQL
  • MySQL
  • Netlify
  • ollama
  • open webui
  • OpenWRT
  • PHP
  • PHP5
  • Reseed
  • S46CM
  • Script
  • SQL
  • SQL Query
  • SSL
  • T-SQL
  • TPLINK
  • uBuntu
  • VS2013
  • WDR3600
  • Windows
  • Windows 7
  • Windows 8
  • Windows 8.1
  • Windows Server
  • Windows Server 2003
  • Windows Small Business Server 2008
  • Windows Small Business Server 2011
  • Wordpress

Calendar

May 2025
M T W T F S S
 1234
567891011
12131415161718
19202122232425
262728293031  
« Jan    

Blogroll

  • Cybernations
  • Kaskus
  • Namecheap
  • Support Forum
  • Themes
  • WordPress Blog
  • WordPress Planet

Tags

  • .NET
  • AI
  • Apache2
  • ASP.NET
  • ASP.NET CORE
  • ASUS
  • blog
  • Cloudflare
  • DDNS
  • Deepseek R1
  • Event
  • Hosting
  • IIS
  • IIS 6
  • IndoComtech
  • Linux
  • Mikrotik
  • MS SQL
  • MySQL
  • Netlify
  • ollama
  • open webui
  • OpenWRT
  • PHP
  • PHP5
  • Reseed
  • S46CM
  • Script
  • SQL
  • SQL Query
  • SSL
  • T-SQL
  • TPLINK
  • uBuntu
  • VS2013
  • WDR3600
  • Windows
  • Windows 7
  • Windows 8
  • Windows 8.1
  • Windows Server
  • Windows Server 2003
  • Windows Small Business Server 2008
  • Windows Small Business Server 2011
  • Wordpress
Proudly powered by WordPress