1. Background
The purpose
of this article is to describe how to reset the identity column of a table in
SQL Server.
There are two ways of resetting the value of identity column in SQL
Server:
·
TRUNCATE TABLE
·
DBCC CHECKIDENT WITH RESEED
2. Steps to reset the Identity column:
i. Reset Identity with TRUNCATE-TABLE:
TRUNCATE TABLE quickly deletes all records in a table by deallocating the data pages used by the table. This reduces the resource overhead of logging the deletions, as well as the number of locks acquired. Hence SQL Server does not maintain identity values of a table after truncating the table.
TRUNCATE TABLE quickly deletes all records in a table by deallocating the data pages used by the table. This reduces the resource overhead of logging the deletions, as well as the number of locks acquired. Hence SQL Server does not maintain identity values of a table after truncating the table.
Below
is the example:
·
Table Schema:
CREATE TABLE [dbo].[City](
CREATE TABLE [dbo].[City](
[ID] [int] IDENTITY(1,1) NOT NULL,
[City] [nvarchar](250) NULL
) ON
[PRIMARY]
GO
·
Data Insertion:
INSERT INTO City
VALUES('Bhopal'),('Indore'),('Mumbai'),
('Hyderabad'),('Jabalpur' )
·
See the data in table:
SELECT * FROM City
SELECT * FROM City
·
Delete the data using DELETE command:
DELETE FROM City
all the five records deleted.
DELETE FROM City
all the five records deleted.
·
Re- Insert the same data:
INSERT INTO City
INSERT INTO City
VALUES('Bhopal'),('Indore'),('Mumbai'),
('Hyderabad'),('Jabalpur' )
·
SELECT the data:
SELECT * FROM City
Here we can see Identity value increasing after deletion.
SELECT * FROM City
Here we can see Identity value increasing after deletion.
·
Now TRUNCATE the table:
TRUNCATE TABLE City
TRUNCATE TABLE City
·
Now Re-insert the same data:
·
Now check the data:
![](data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAUcAAAETCAIAAAAqNFPdAAAgAElEQVR4nOydd1gU1/r4935vfjc3N7k3uemJianGNG9MNc1o7D0WigWNBZRx6L333quAgoJ0FOm9l2UXkN5772Vhd9m+vL8/FgwobZci4vk87+OzMzlz5pzJfDhT3yEAAoFYWxAAgEKhGCIQiCccCoXyl9WGhobbtm3TQSAQTyzbtm0zNDScZrWOjs4oAoF4YtHR0ZnB6hEEAvHEMrPVdDqdhUAgnkz09fUftlpfX7+lpSUnJyc7OzsHgUA8aSgpKT1staGhYW5ubmBgYG5ubhYCgXjSUFBQmMHqnJyc3Nzc8fFxpkgwGAwOhzM+Ps5HIFaE8fFxDofDYDBE22PXGDMcgQvG6qysLCaTKexpOoVCodFoPB6voaEhNTU1E4FYEVJTUxsbG1ksFoVCWY7rT08WM1wtE83qh3wmEom5ublkBGJFyM3NzczMRGILWBqrKRQKi8VqqG/Oysuvqa+vrKzk8/lL88AbArEwOjo6MjIyGhsbaTTasjqz+lkCqwVKNzY2k4vi/cyUDDBZU0NtJUUlJQ0d9+j8nuWzm96UFmBj5Bld1i/0otSahNt2OoZGelo2fnG1tL/+Q19plKeRTWB689iiW9Unag1zV7ugznK7sgLMzXzTCkvy7zqItommrdc3LSczys/cIoTYBwB95FAXW8/YymEh6+J2ZQWYG99IaKON1Sb7metrqyriOI7jJj5x9SyA4eJ7bloKOC6vrGHin97IAmDXRXoamYcQewGAURPlZWQeQuwdn6yuKyMpJbqaMWUF+fn5KSkpLBZrubVZ5SzW6kmlG1NSsgdGyrJNjr5EIPz384OXMek9G/793Ds7TeJbp253oWG1ZwTbWPmnTGj2YJIF0HdP+jMC4d/7XYqErpVaHar1238IhL+/c9widqrVJV5i6wmEX5Tje0Vq5NRWlQKMd0xr/GLoiVX8iUB4T+J66QIKD+da7/ri5c1aqYURhtufWehSc6z3k8tuMbf1v339zZ9NUvqgLwb/4rn//KiTIpzWglZ9pnCvjdZy88wGwt/e/kkMwzAMM/KOrWMBI+e2CXZQAsPO7974+lufSzhnto3Vhip+/sqbPxsldPCY1YG44Hc/QEuij+WVA59+/Mm6nyUtbz34u0wmkzMzM0W4HrTGWJTVU5RO6erqBaAmGRx8nfDWCZtiABi6p/jd3wlfXfCvF3WPAgBovC31AeH/tuvmMQEAoGFykgcAncQob7fg1GqKCPVSs42PvE74Dr/bPG121z3sW8LL+/VShRrcGmdoVT0DoM1/WuMXw0Ci9t5XCZsv3a6cv+xwgsYvn26Rut0NQNLb+wph86XbFaKutzdJZ9+rhK9kIobGB4P+/PCZD8/c7ARGmd2BjZ/vMEgZFaKmiVbdaACAqutnPlv3nWLC1O3CaGzr7hsGAKj3Pf8R4f/9qhBPA2j1lvrwmQ9PezXwAZq8pT585sNzvh3c1mQvmf+9RSAQCO9uvuydUo+snoboVk9XukuwCyQbHnyd8NYJu1IAqHc7/tYzr+6zzO4BABhrTL2lryyH4wqqRn7pjUwA6CZFuWipKk4cgnEAWFPLZHcCvyvZ+c/N7/yD8K8PfvjDKDQ0MsRHdnJSNyC7uLoyxe9aOLGjvYkU7mpka2trYWyooKJlFphWOwIAQG9M9zVUUcDllDR0DI3c72ZOGTP7knX2vUrYfMmvYqLkbWN1JRw/veeL1wnvHdNP6X+kza08gM6MYOepK8ps5bPak53PP9KqqMLC3Dgv6cn5Jt7eAX5+RsY3E2vpAJ2ZQTb6buFF3ZON4XeT/9oUCS0AvJaJ9iip6xgauUfk9bYQjQ4u0Oq+WM3f1n111KYEgJ6uve9VwlcXfesAYLAgwklDSU7Qm6aJTcFsTvc1VFXEcVzVOaKiu6v8nrMKPnkU3MQBRqbO3lcJmy8GNAG03br4xb83nvJqGofWG6d/fO1rpeAO1kKlnmxVPgcASjxObiD8bd3PksoznKbxCqz3vkj44OS1MiYAt8b74hf//vT0tSoWcOu9L37x742nrzezmfetVU7vPnbsrLiaY3jj5P9WZLUAEa2eSWkA6Es2PPY+4bn3fxBTVJY5f0bqknU0qYsDwGpPtz3x7Y9bTmkZGMju++KLz095RSWFmO9Y9+7H+6W1NZRNvWPrR9vTHaeW2XTaI5aYdPPqlveeIzz3/vdHDENCIoJv4t9NTBr4Z+WE6G5/hrBBOiopzuLgiwTCK98dU9CX2vbOcy99r3p3mDKc5yy+ccP7v57CLh/47EUC4d+7NKYcV09YfTGgHqCH6Cy58fVXPzuAYUe/eef/ET44bpbFgd6sh9tMLo002vufqSv6SSumpjnJ6/IjrfrkotO92AD5HwTz/7C4ccNGZsczhOd2Wd6nDCXi//sb4WuFiAmrqQ3h2r9ObAolU++EquZcz9MT7Tn0+YsEwr8PmBWVl1seWaDVJe6SGzdskQvvARhN0dn3KuEbLLKs/X4I9u1HH23cfxmT/Pndjz4Rd84b5HEbksz2b/j4/S1HMQxTdrpX3t1VFu6qpaGtryL59TvrPr0S1NCcaXboNcLmS371AIwszX0v/muHSgoNoNHz1IZ/bJDyqlmo1pOtagMA6CuNu2Wqq6l8fueGF55bt9MsUfDXoSs/1FEFP7H1x227tCNKh8YBAAbSNfe9+K8dqokUAGq65r4X/7VLK6t3iBQQFU/q7m6OjAm5WzaCrJ6GKFbPovQDq5/f8NuhXdveW//xbrucPj4AMMq8zm4iENb9eE7byOjq/o/+RnjhoJTipTPvE/7zrZRZciUdAKDW68yX08oQvlfJAahyPv4W4a0TtvfZAAB0os3EJACMpWrtfYXwg1JCeoqj5DrCv3YZ5gDQE+S/Jfz9d7079wKufEn4+1btLD5Ai/fZDYRXDxpMOa6esPry3e6xdr9znxD+/pXcvWGA1ptnNxBePWxVMtQffGl6m/+x08TLz0Pqvakr+r8fZKNHAEpsH27VVxfCegFK7QXziwCAkWa87xXCp9LX46PcDn/03m795KGJplDT9Ha+PLEpmADQ7nPmY8L/TW3PMduyylKLh60WOIDjuKpTaP6DcR+gwuPUp1v2aqbQAYaTdPa9SvhZ3T/AU+5/hL9tuhrWBwCFVnv+Q/hcxjc10X7/C4QXD9jkcaf6Ry2OtNc+9+uH/4/wPR6VlGx7/A3C5ku3awE4hTbH3tuwSyNpEIBbde30x//45MyNGvbCrJ5s1fRz8bZguc3P/P2zc15lYwDQRQ52UMLO7997+CjmHF/QxQKAMfLESocBWILf6omznB8hqwUIbfXsSgNAX7LhwdcJ6055lVP6/E69RfjXZ1cDm9jQFYr98gLhne8On1fCMTllHSMzn0RSATnrxoXNrxAI//h4n1ZYXKSL7K5/TyvjFUnuBGq64YHXCG8cNhII2ZOoNzE5AkBJ1tn36oTV4m8T3vrDnMSD1mCZbwiEbbpmluoSbxPWHTfLYQC0hFz+nvDKft1Hrb4a2d9NNNr/EmGdmAWRBdAccvl7wmvHbfKyU9R3TG/zjbhicoT1sekr+lomqAU42YYPt2rzpZC2KfMHAGAoxWjP6//aKXH+1KGtG3bpJv+1ew9XJLidE2yKgwZ3g+0u7X6T8O6U9rzyh+WMVpODHZQwDMOUHULIU6wucZfcuOHHKWP1b9rmlupibxDWiVnmUAGg4S62hfD6CUVjfcUfCC/s10uZvFzPaMkOc7qye+eeA/uPbN3wwj+3qSWkp9gce4Ow+ZJfLcB4mYPEex9sV4rrBQBWe6DC5ld/OnO9atqfhFkpcZP4ZMOPE2P1A0ZzrcTXEV7YoRozpQOUWN0tLxDelXAuYgDwiydWOjTl9yzXMpHVAoSzek6lAaAv2fDQG4Q3DpkSAfqjtba+RHhpm1H6yHCByY7nCK/ttSdNlBtnDgn8aib64L+/TyBsOqNjon385allgD3SB0DNsf7jHcKrx63ucwAA6A8mYfpYLf424Y3DpkSOQLa/bdO95mF19kPC//vdIAcAiuyPvE544/DUsXriaplSInW8zuWPNydLljodfZPwpphdTnmhxe7np7WHOzbanWly6PWpKyJ8eyW4FXhF9g+3avOlafM5AABDKUZH173y8n9f+u/vR8zShmG4PMbLyMgruoI2dVN8v0tC/NCXhGentOf1EzYzWT0bfbEav6376pjtg/Pqn9X9AzywLwh/+1UznQkA+VZ7XyR8LnMrJdFm7/OE9ae8qyfEbAk8/zmB8LJUaHtPucOhFwg/KE9afTGgCaDV58/Pnv/41LUyusDIRL3tn39+zI1UW5nqY2R0K7WssjTl5kw/rsdVU/vSdLet++qYbT4PYLCls2+QAgDQFnD5i7+98LViWBOd0jY5E0ocD79CeO+EcxkDuHXXBSutYv31e6IByOpZEMLq+ZQGgJ5Yta3PEJ75TT1hEIBW4Cq2jkD4z8+G4TV1qXaHPn791Y93/YnjuNhhebvI2JJ0P3NlDW2lk9+8u27jJd/Kmqosm31Tylw1C8jmAgzlWR9Z9/xLn+3X9ImrZcBA/sSkQUD21PPqvc8SnvlNO5MDTb4nPyAQNl70zS1P0vvhrTfXb5PCFcR+Wv/3Z98//pfV1Jow7d9eJBD+vl7SMaWiJk77R0HJM7+++38Ewot7dTKHWQ2p5tPaYxtd15Jr+Psz01b04ekbVQCUR1r1nsS0+Zo+cfUsGMowF3uXQCCsP2qRSQOocD34EoHw1mmLwLggq4lN8e5GWe/UtPDJlp/ZvuElAuEjKceK8vt62xZ6Z2soXuOXT7dI+fcCZKn8RCB8IBVS1E4OuPzN15t/PYXjkj+t/2iDmBNxkMetTzTZ8+GH7/1wHMdxVdeotBArsfX/96+NB+Rwya9fIhA2yUYlxRnteIbw3qngvvGh4PMfPfPBac8Hp9LDSbpb3/34uJ6l8cn3CIR3z7t4OZ97e6Yf//3DqwGYWdq/fLpFyrsFoDfWUVNqz2UcP7/7ow8+/FbtTg0doDXGUVNqjzSO48d+XP/RBjHHrI5xGG/ylvromQ9OedYLroFPbwCyemYWavUClAYAemN6oI2BTWBGEx0AOB3ESCc9TXPfxBaA8bY0P0M1RRzDMHkNj7j65to0X2MMw3BFNaPbaXWjAABjTVPKuIUXDwAAcDqJka5aaoom3rG1DAD+xKS5f9b9UnKYncH1hIbmJlKonYFNYGY7DygVUZ4GBh5RlWMAQ4WRzhpKOG6ucfH3T/7+2h61B1fLqNXxvrZa+gY6GpY3k9oAKEWRzhpKOCanpK5jYOAalt7IAADGtPZEVjIYXTlBNtNW5Bld2gcA3Idb5RE5bb6Jd2wdC4CeY3fijedfOWiaSgGA/pIoTwND34ycrNhA8webopYBAL35E+05vffLNwjvnTAntfRkB1lPVjsfwzlWO794eZNKVF1Nhr+1wbWIYgoADObftVeWwzA5ZQPftMnrxoymtFv6yvIYhim7RNa2dRbHeeioKxkbm1lYWpr6JjY0N+UG2xh4xBYU+at/9dqbPxnGTLnsPZRntff9j/4npufhZ2Tok1xaUZrkbWDw6A/P6LIhACrRaucXL3+mcLd2pCXJ11zxKobhimqOEQWCLo01TszE5CcbSKvxl/v8lTd/Mozv4DFrggS/Y2a/7o6sFrAgqxem9Comw+jnfz+3ST6gaZYjt5ViPN9y9/q3ftNOGpq/rADB/fN9usmDQq2I25npb2rgEVm7+BvlE7BrI68ZmATl9oxPnctpT7/t4XinhDbbYtPgdGb6mxp6RtYurDgAtTrSw9A0KLcHABiTv8dnL4+sFjC/1U+s0tSaOG9jHMfxczs//fLL3SYJNcI8M7EcrdE79v0nX21XCqpY+DNZoj3r9rSCrBYwq9WZmZkcDofJZHK53IaGhidNaQCgVsfeMMIwDMMV9XxSm5ds1BK9NTryylbhZKGeD+8rjbhmYB2Q9riPMp4MSCRSTk6OyHkB1gyzvl+dm5vb0dHxILtCd3f3XJsTgVgFkEikgIAAwZj0NDNzLpTc3Nz8/HwymRwUFJSRkdHW1sbj8RaSBo3JBC43FcAIwAggEwDq6+vr6xf1JDgCsUB6enoez+vdqwxlZeWZrSaTySQSiUgkAgCNRqMsjOFhYDLlAAgABAB1ALh3715ERMTj+x+NQDx1CCwW/H7YajKZnJ2dzRQuIwqwWJqTVhsBQGxsbFxc3GPsIQLxtIGsRiDWGshqBGKtgaxGINYayGoEYq2BrEYg1hrIagRirYGsRiDWGshqBGKtgaxGINYayGoEYq2BrEYg1hrIagRirYGsRiDWGshqBGKtgaxGINYayGoEYq2BrEYg1hrIagRirfH4rR6tAE9NwHGQdwaXIOguB6BAqBtoaoCaEuA44HKgbgAZ1QA8iPMGBRVQUwMlOfCJg4ls8V0zlS+fXEE3hFgBjgOuB+mJ0NoMFXWQ7ANqiiCnDBoaoCwHimpwIxYG5ttY45TWtva2Xsb8m7UrH9z0QE0dFPDJJjlCYTlkBf/VTnkdyKmessyDdmpCbi0AQE0cmGiBbxpM5DFnQVYYaKlBYv6c6+4mhljJ4ziO6/mlJya21BU9SD8+UhrmH+ST2Tbn4ognn8dsNa8D/CxBUhwwDKT+hP++C5YOABQIVIENn8HXh0FRBZSV4JMPQMUOgAexN+Dkb/Ddt3BIBrxj/7J6hvJWAAC8RrDTgH1igGGAnQWxTbAHB/9AuHIAvjwG0rvh009hjzQc/QJ2noY8/mzNBKDSWVxg9uTmEUm1o1zKYG/XwFyfguwig9IW+G4znJIHNTVQweCTnWB8C7IcYMNn8M0RwDA4vRMuaUFBLwAArxnstCbbKQZiVyC+BBoT4MBr8MzX4NcKAMAqhavfwFtbIIQ863p5jbF2Gvv2iZ3FMAw7e1Fs0392XlAPannQrPT4uBBS57RFRstaq8uR6GuKx2w1Ox0ua8LNHsEE3LkJUYUAAFAGxvYQSQMYgIEaKM0BEnFiEUo8+PpA1UMVPVo+D4APSdfhpCIkd07UH+4CBn7QWAvZeVDDA34GmJtD5jhwqyAnFdrnsLqvoSgnOTDM5/Zt38CQ8MjkvMr+eT7wWuwGoaEAAE110EiD0hIg1QPUgJEleNcBAEAvaGiDWTQAQLI9SJ6fbCcD3BThijH0sCHcDta/AdZBAAAZIXByEzgGwywfbwbgdyZd1zipaDnZ3+pwFw0975SWsYlvXStoGtsG5zRQHizQlR/qKPb1b99/89sZHMdx3MQnrnYMALry77iqq6lfu1fQCwA9+feuqaqpuyXmo5zwTwaPf6z2tQRJCcBxkNeHysnvWvCLQfEk7JSCPVvB2mnaIk0h4OYMxOmf4pi5fB+YOoJrxqydbw0DXV2407qA7cQeaMq+bWFuZaBpec31Zmp977zf0ijyBOm9cEYSvj4CzoWT1RBB02TCamYZaKqCVz5AD2irgXvUX8vy7oOZFYSQ4FYYGJwF/yCIywY3D5A8AqEe0DTbKvuiTB2vuWbM9HG5LnKwg9KVw19vOiLjXMCfOvfkT7u2/rxbCsMwDDPyjq2lA0AX2e3kF99/c9ypsB8A+kscj/72/aaTfmRk9ZPBqjiv9lCfOPI8KQ/xxQAAvGJQPAk7TsPuX8FqAVbPXL4WbD3A/v6sq267A7q6cHdhh5+jFfeTYtNJeWRiSmZFG3Xe8kWecGkPnBKHzUfAuWBipuCvz1YxwOXg/HmwugXNPOBlg4oBOJVNWbgLHG6AZwJ4+4D/HYh2hU/WgakPhNjCdUdonm2Vtf62Hi7292c/5Ki9bmii7UCadpRR4RHj6xU78lBJZuM992DPyFoWALAa73kEX4usXsD1BMSq4PFb/RdMMPgDrqgCBYCXB5omENAOfVVQlTut1FSrue1ALoBqGvDyZyo/AKZG4Hxv1hUKZfVgU09H5zAAq72uvrlp/o9a5liDjw8M84GUA3ntEzMFVv8iAdhF+PBLUA8HAOC1gLY6uEf/taxgrA4mwQ1PcE2F3nC4fBbuNECDB7jazW71QIypkZXzvVk/5MUhOWjoazmRp1mdaxt8zTHk0eOV7kg/WzuXeBpQ427b2rtGo3H6yeExW10dC4nR8GAQCDUBQ0OgAEA5GFnCjZqJ+dQyKCGB4GOv086rS8DREQJ6AeoeKU+GUYAka1BQhtKJbzVDZzL4uEDF5IdW6Ulgbg7Jy/NhupJr4OsJD3+GsxSM7SFkEAAgwwi2nIPITgCAZHs4eR5SBJ8nZIK7Elwxhl4ueN8CzyQAAB4P+ABV7uDrBbP71RVnfUVB2WpKf6/7uIQ/6C/UXjeyNJk4q58ky9zNyuJ256PFxypu2/ne8Au5dcPP3r9kDBBPDI/Z6uBzsPGfcFhw++cKnFCHyDqAHghShU8+h2+PAo4DjsP+jXBOAwYBEr3h9Db4/js4cgVwHK4chkNycK8IIrUfKa8CHQD8BnDRhKNiE/PF94GiKZTTALog1BGkfofPPoPfpabcJFsiuvJB+Uf4/hs4g4NT6KSHVIg2gk8+h28lIa4AYAScNWHzQbhHAl4T2GrCfnHAccAl4IQsxBVD8V3Y8i18sw2cwoEGUBoGYl/D999A4OyHPuyGGBdNiaNiOI7jOH5OfN9uRdO75bSJj/5if3zzyecbvz2KCa6LCbrckXxdWWLPERzHz08Wn6ytOy3eevdPe8xvp6KB+oniMVvdlAl2mqCAAYYBdhU8o2AUAHogxAXU1UBFATAMMAwUVCEwGwAg4QbIKYGKCihcBQyDqwpgGwYtDRDh/kj5dBAML9SqyfN2DCxDQHC5Hbog2AHklCZuff91k2yJ6CKDqw6oqIIcBg4hf1kdewvU1UBFHWLJAAC0crA3gHDiRJOCLADDAFOHnDoAAHIw6KiAqhI4hAEFoCgU1FVBRRUSYudaNbUq20MdwzAMw3DLkNwegAcf/b2qoKqupqaicFVwXWyiy9zWjCBrhanFH8BPMVPRwX0XcjkRsYpYTefViFXDxOB+atu3v/78h2VC/dL+zUMsM8hqxAxMDO5ySqoqKjZ+kwfriCcEZDUCsdZAViMQaw1kNQKx1kBWIxBrDWQ1ArHWQFYjEGsNZDUCsdZAViMQaw1kNQKx1kBWIxBrDWQ1ArHWQFYjEGsNZDUCsdZAViMQa435rWYwGJQFMzwMLJbcpNUaAHDv3r2IiIjH2EME4mljLqtJJBKRSOTz+QwhGOdwksbHDQCMAXIAoLm5ubl51vx5CARiyZlnrM7MzBwdHR0Qgv7BQWZvL7+ysj87+35aWhqRSCQSiekIBGKlUFBQmNXq/Pz8pKSkjo6OJmHo6Oggk8kxMTGpqakpCARixZnLajKZnJqaOjAw0PUInVN4aM7g4GBycnJGRsb4+DiPx+NwuChQoFjJ0NfXn8vq9PT04eHh3kn6+vr6+voEv2k0Go1G632E0dHRxMTEjIwMPp9Po1FHR6eGACoKFCiWL3R0dOaxmkKh9E3S398vsBoA7t+/n5WVRaPR+qZDpVKTk5PT0zM4HO7o6OjwMGUYgUCsIMJZLQAA8vPzJSUlfX19ORzOgzF8utXpLDZ7eJgyODg0MDCIAgWKFQvhrH4wSm/btm337t1kMnlsbGxGqzMyMlhs9tDQ8MDAYH//AAoUKFYstLUXbHVvby+DwcjMzPz55583bdpkYWFRUVEhOLV+1OrU1DQqldbZ2dXa2t7S0oYCBYoVC01NTeGsTktLO3LkyOnTp2/evFldXU2lUh+1OiUlJTk5ub9/oL6+sbKypqKiCgUKFCsWampqwh2B8/n8+vp6a2trT0/PxsbG0dHRGa1OSkru6+uvqakrL68sLa1AgQLFioWqqjBWC2Cz2U1NTREREZWVlbON1UlJyT09fVVVNcXFZffvl6BAgWLFQllZVeg7W319fWNjY11dXS0tLRQKZUarE5OSOjq7i4vLyORCEqkABQoUKxbKysrCWf1AbMFLWn2PILA6Pj6hrr4xMzM3IyM7HQUKFCsY8zwxmpGRMTIy0j/JxAscc0Kj0bKysmJj4qqqavLz75PJhSRyAQoUKFYs5hmrs7Ky6HT6Qh5nGZqERqNVV1fHxcXFxMRGRcVERkZHRkahQIFixQLH8bner87JyWGz2dRJBM9+U+dE8Fegvr4+P59MJBLzEAjEyqKkpDSz1fn5+WQyOTAwMCsrS9jXOzMyMrKzs4kIBOJxMKvVRCKxo6MjC4FAPGnMerUsMzOTw+EwEQjEk8as71dnZWUxhckuikAgVgmzvrOVmZnJ5XLZbBabteaCzaLT6RQK5XFvfARiWZjVaiKR2NzcFhOfHBO35iI+uba2nk6nP+6Nj0AsC7NaXVhYkJyS5ebpm5KWvcbC1eNmYnIGADz+owZ0VIJYBma1uqAgPzE5IyuHBGsOYl6h27WbiUnpj/+oYZkjNj4FHZU8hcxldVJKZmp6zuP0b3nIzMrzvH47JTU7OTVLEKnpORmZeRlZeZlZpAeRlUNOzyQmp2Q9KPZkRUpatuu1W7FxKRw2+3HvZogVRUSr67qpYXnt98htEeS2ewVtUUVtMffb4kraAtLaXMPbrkW0XYtoc7/X5hjWXlRPWzFdF4hgj586h8mgdXe1Nzc31dfXCaKhob6+poYyOPS4GrkkpGcSo2OT2CzW497NECuKiFaHEltPXyvXjuzSjOzSvtV1xaHrlGvXeY+uI+ZdW9W6tmt2bdfs2qHdtf5suWN424rtxAskJS07Nj6Fy+UI8hgzmWNkck1qamF1dXV5eXlVZUV1RXltRalXaFBkViaXxR59AhkZGQGA5NSsmLhkZPXThohW3yvo+PNGlU5Ut2ZUt97tXnnX3n3G3T8pdf+u1bdTt2+7Zvd2ze49Rj2bTjZ6+vfOVEF/Wex1A3UlORzHcRyXU7INyezgCS8or4OUkpZMnnEVs5KSlh0bl7fCK1wAACAASURBVMLlcAQPrrPZ9OTkBiKxW/BfGQDDAD1ssApM84tKG+ey537ufXUyOjoKyOqnFRGtTiF32IWUh5Pa7pHabqaUB2RW+Ke2udxpM/EuMfEucbvX5navXd+r5vttIdecC2eyMd9R+vCmbw5fwTAMw7DLB/ecUnVL7xJKTgAATra5nIaaWXB2Tk4aqYO/sIVS0rKn7utMJi0ltb4wvwf4vN7ujpqW1szWsbBClopWbLB/Bp8//6M4lBE6iw8AwGVQKZS/pvks+shjuvxMoVAAxpHVTyciWp2b3V5c0CP43dfV1t81cZjd3V7X11kn+N1cP3L8qLqLq9dMNubZaRob3aidnO4JVtZVU4keWJiWUyh00LR0cHGxMLfUdi5e4DKPWp2V3hiSVJNXUxoZnn4nOCEgPMEnIFUJ9wwMyARgMak0OpU6MjIy8y2iUTpzpCHX31bT5Hp0eS97jEZj0VqIIU4W9gHZDRQWfXQl/39Ogqx+mhHRahKpJiWlsKenp6mpqaCgoKCgoL6+vqGhgUjMTEwkFRY2lRTlxcVWiYuruLs7zrD8w1Z3BihoKKokUoFRFeupieM4rukVVzkKANTymBtacrii7q2U5pH+8vSMFMGYzOsgpeXk5oQ7W5tKS0ie2vPjt9u1QotHgVsbJyh/M76aOrvVMckMxpjgzfCxsdHMtIbgxOriloayktaCwsbK0sJ0YqGrd+zdmOKc5r6UxtrmwR4GbXTmN8tHWeODGXbnNxL+9ovC9VI28HjsxjD57/5GeOOwfTYFWLMstrwMDQ2N8/nJKcjqpxERrS4oIKelpfT09DQ2NhYUFBQWFgqsTku7HxZWVECuzC4ovBN3/5TkZTc3lxmW5xd5Kp786VexqziO47iSsoqigX9i0dBA/h1nhYsyBgYG+jIXFdwiqqsq/Gzl/jijqXPu129OG9m5GerpKFpkcwGAk22uoGdgYufgan1ZQvLk7i3fbNMNK+6o9LWTF5T/6oi8c9nILFZHxSTS6bTBwcHBwUEajZKcUped2Qx8LgCfzYL2IUhqgPwGSusAndjPuVveomURFB+TweGMDQ4ODT4EZYzbm2JvgG3+8KCxk38FC6A92h7/5ZlXDii5ZPRz2UwWV7BeLos+MjgwOEKfmMFl0SgDAxTa1MmhUQZ78kSCz2ZQhwemLPDoMjPUSR8ZHBgcHBgY4PG4yOqnE1GPwHNrCgoaBb9bm5vbJr87X1zcXFRYyQdoBciqajspdsLNzW1Gq70UT/74y3FZDMMw7OCXn51U9u0HXrLmkZ+/237ByMjI8M+fNn5z1MDDU1/l+KfiuiHRkSHkrIRbhkYmOo4kLgBwSA7aFla2jlZWTk6uHk6OzmbXawHGElQuHvxEXDckOjIwNympenQWq6NjEsfG6ILkLXT6SFpaQ2xsWUNDdUnJfXJedXhcuVtySfkwC3r7ICe8JDxN3yBaU905I4PMYtEHBweHpjLC4PUkWKibYYdPGnpZ36wFepq7q/nhzUd09GwyxqAnL8heUfrSJWlFh+DcFtY4qzU7yFFJ5tIVFZeQvA4+vyP3wWR+N3+wMMRZW1paWvqSjKyxd3R5P4/HaCWGOCpfvnhRWlZe3TEop5nD6yDOUWcLlTkyNDA4yOfzkNVPJyJaTSRWx8YSW1tbG+vqMstK0orzC/Pr799vSE7OjY4oTs6pjsnLj0pIPykp7u4+01g9/Qh8LNvgopK2VyE56PzRL/93TAbHMExFz9Q6LK++uTk/1FzrwiUpTMMlJjfCwsRY2yWfDwC8fGddK1tbR2trR1tbR2sLCx1HEh+A0Z4daKp14ZIUpmp/l9zLmanxqWk54RGxg4MDgk/zDgx0JyRUZWQ09vR0NzU2tLY0tjZURxfl5/X1QM8gFCS15uX4xxF3n1DZsVUhIy1/cLB/6od+O3uGaK3RBvLa+spK6qYm2oF5Se5217QvXFQyULVJrCD6mF4Ql5TT1paTEL9g5kMszHHWO7/7iIzq0W8/2y/rHJ/kYXxxYnKPtE1eRXGYi7asnIKy2tWj+8XlrKMbGrLMFA5t+emw7JUzOz7bsOusbXJV3s3Z69xzwTS1lT7Y3dHBYjKTkjOR1U8hIo/VWTExUa2trQ11ddE5VeEZxfmkajKpKjYq3Se0JDa56m5kvl9YlLjYeTe32zNZTXLQ0NMUjLoAwCy0UrEwcLkbrCslo+DbBwAAXRmkzPjUpPio+Nwh4JW67v/5T3lZTMnazFTwECvJXEVH1c7JztrR1trO3NzGxKcBYJAcHBojKL938xEZj/KZLounpeeGhEW0t7c1NDQ0NDS0tjZGRZXk53cDwCgPqBxg8SCxvYvY2wP9tRDtD/XtTkmOOy+c/XmXlq69R39vd8NUmjv6qsN0Lisqmzpaa5mYq8heMDbX0Tc3U9dUNXV3Vj743aYfxRT09BSPf/3hF7uuGhjjF/Z8uO+q93VPh/DouBA7/NSODwSTIUG305uoLXnh7trKKhrykr98d+yKqaud5kmpy9Y5AwBDSeYKaqombnPWGRrsn1Tc0dpQV0cdHU1KzoyNT0FWP22IaHVmZiaJNPGIeEVpU1FBDQCwAdJJhQnp90s7ILoaAlPvHzuCu7hEzWR1tjmuLCc4QwYAoKeonJY9ax5RFeEme1j8HI7jJ/7Yq+YWFhPlLLPjfz9IKGtevqToFhOfdN1Rbuee0ziOyx/euOWspq2tib6ZodN1L+PzW76/eD2lIN7xQXl5O7+c1tmtbmtvra+vr6+vb2lpiIoqIZO7AXidA6N1vdSqUU5QQTu5thcG6iE+mF/XUd2Tdyc39oyOl4G9R293Z/1Umtp7q8O0pa/iltFp/rZmhz/6Eje1DAq2VVJX09LROnngs427JS9LnTp98aqSunNoclr6XVct5RPHj5y+qHMzoaioINRZQzCp55eSnRpogu3et++UtPSZfd99J66sp6mooIUbJ7RR+/qrwrSvqM5bp3cUubqzpb62dnR0JCkFWf00IqLVOTk5SUlJAwPdDQ29GRn1KSnVleUt+ZW1EcmZMfeKIpPb/ZML78QmSYipOjtHzrA8ryMvOS15yh3mnsLAe+GxLQADxGALHMMwdY/4ShoAUKvib2jLYZiaR0zlGACzIvq6phyGYXr6Bi4x5fcLcrKJ2ZUNzaRAMxVdz+ROLjQnT5avmPFaGUBaRm5IWERra0tdXV1dXV1zc/2E1eOc7v7hsmF2+SBEhA+RCnqhoQmCPHiVJGJ1yu2Ku5Lq7oYanj09HXVTaWzrqQrVuoRdNkxsqfaW37Lh2xPOmXXJRlcUlUxcbGSOSJ6zIvEBoD3HPzTgxk2fG9duhle2tCTobd20/8RlY0/fgIjKlpYEvV+/OoJd/PPYhUviXhUAMJKsh8ldNHS21Th5RsYyqxegP8FETk3ZyNl6jjp//fR3caPotp6W2pqREUpicgay+ilERKvz8/NVVJTOn1cUF1c9dszo+HHjY8eVJcSkpc6IS0hqnzimKHniwJlTEl9u+tXR8ebMbj0+0jJyg0LCm5oaa2pqampqGhtrIyKKCgv7ADhNFGZZD0RXZduFupaUdUFjM8fPbYiYHF8Q6pVw+6TMNX3da11drTVTqW/trghQOvXnaZWQhv77dx1ueHhnNLeEqpw6f077Tl6erYbYjn1HMOzcnp2/XtR3DfbSEd+y4cv9srik+HlDO1cnBcmfNn65XxaXFDun537Lz0RXauu2o7KXrxzZ8va6LfvMY4uSDGT3ff/zEdkr5/Z//9WhS1YxJOLsdYqd0bAMINa21lVXjgwjq59SRLS6r68vNDTIxsbb2dnHxcXbxcXb2fmms/NtV1cHZ+dbLi6+bm4urq6uTk72JSX3V0zXBZKWkRsYfLehob6qqqqqqqq+vjoisjg3u6mzZSCtsjejafh6dYRZjHZ5eRM0F0OIxXBuol/8bZtrQWckPPX13dvbm6umUl3XWJEWeOOmd2BaeWNTc1tra2tLc1lq4A2fG4GZTcMNGX62SqfExSUvGHhGFXZSOgqjPU2kT0tIXDBwjyzu6yuN8TSemIy639NTHOlmdOmUuLj4qbMXZY09wvO7hxqyQlzU5OWVT+/a8PXeYxbxffSm2eu8Fpnf1FZfXVZePjw0hM6rn06exjcx0zJyA4Lu1NXVVlRUVFRU1NZWJMRW6tnfkdMyP69je9zF/oSjm6bj9fbOTl5TZZWdYknEHQvvUEtPH+kL9jo67q2tjRXTKC+vqGlobGxsqKkoL58+p7q8tLKmsaW9q6urq7O1qa66vKy8ur6ptXNiuqq8vKpuxsmurq6uzo6OjsIoNzMV6StXFVQ0pPZtP6tqFFXSVlszV53VFeXlFaWlpYODA2isfjp5Oq0m+geG1dRUl5WVlZWVVVaW5edVOflFGTvZWrk6abq6ari42Hl63fAIUjGJOKofduyKm5SE1+VLDt9+e05Ly721taFshaisaSBFuRrKSkhISIiLn7xo4BpOqmmsKp9/yeLi4oGBfmT108nTaHV6OjEw+G5jY311VVV1VVVVVVVNTWVLU117S0tbS3NHc3N3W1t1RZm7e6CqsqOBtruBroeBwTV9PU9dXc+IiJTGxjrBgssflVWV1fXNrV093T093T09XR2tDXVVlVULWLa8vIxKHUlNz05MSoenIZcTiikxa+bgNWx1alqOhbVzYPDd2wGhs0VA4J074ZGR0TERUdEPIio6JjTsnp9/yBwLrpLwux0SGR3vcd3P3fPW05DLCcXUwHH5p87qvr6BnNz83LxC4hoOUmF2bj6JfJ9ELsrKIWfnoniKQkFplm9iPmT1wMBQcUnF8kVJaWVJaeXKVFVRWVNX31Rb1/hERF19Y139428Giico1NQ0FmR1cUl5VExScUn5MkVBYXFBYfFqq2o1xBrrDooVCGVV1QVZXVRcVlZevXxHxXw+n89fYC6TlatqNbDGuoNYAQQWC37PM1YXl1QsXzsEX/1abVWtBtZYdxArALJ6tbPGuoNYAVax1bwOUkp6an4vAKUi9rq+2kRCUoug3LmzFs6sAb0m3lMDx3Ecl7cKncwn+iSArEYIy2qxmsFgMBiMabM42ea4irxNEUCFq/ThTd8cESQkvSglYeUf38gWpqrBohAr7NAxMQzDMExK7OABHSM758C87MwcIjE3ndy5mk9bZ+gOAjEnq9hqLslBQ1/LtQygxEnTxNh7InUptcBK6eJVh9RZh9tHq+q9q3dW7KJtycSI15lyM9DB0eteaWlRhI2eiZZz0RJ3ZklBViOERRiri8sBgMvjL3nwx8dpdDqNRufzxydm8gGYRDs1PQ3nEoBiRzU9DYc8JgCfBwB1N+T1VNXiBwHGufNVxQdgNwfoauhZRPYA8Hl8Lm8cAADo9aU5wR5aZ7Z++80+M68b1zzu3U5uZAAAtT42PMo/q5kHML5UHVzUlqHR6XT6yu8ZiCeXhVtdcb+4HAAYTPaSB5fLp4yMUigjHC5vYiYHgJptraqj6nAfoNBOVUfVNocKwGbyAQYTdNS15K6RWTDOnq8qDsBoupmyrqo9mQHAflD5aIa5ior4gaPiu7Z8vcfiupfakd93nzYrYQEzz1Dm3Am54CbeOJe7HJ0VestQRkZGZ8yqiEDMzOO3eozJ5nH5lJGRoWGKUFbnP2L1DFVNWK2jYk9iALCmVG6lZmbl4GZn62DkUQ5ATdK8cFXBoaGnxhLTvGqSRwNgMx6z0hPdoYyMjCCrEUIgjNVFZePjMMZgLW3QGSwejzdMGRkaorA53In5bIDRbGsVHVWHQoBCOxUdVdvsUQAWEwCqPXFdJZWYbgDOvFWx+MCqu6WtpmUa3g7AY7LGGBweAECRo6axiYWdmYmphm02DYCeYyJvamhi7W5rZ2BXTAUedwn7uMgtQ0FWI4RhFVg9xuLOY3WBraqhnke5oCXDOeZyf162iO3gjPMY81fF5sJ4c4DWqWN/mpMnzk4bEm4GWCqdk3W0sbQ2MrY08CjlA8AIyUbr8rtv7jT2Cm/hAZfJfPxWT3YHWY0QilVhNYfHGxqmDD5k9Uia4RVFWXMSQJH9+UNffnNYRk5OXl723KkTJt6xdTTgspj0+atiMjg8bm+Br4n0vj9OXJaXl5eXOrb/kJ6W1pk/TQ0cr7npn/3hmzNOMVUjwK5yPfb1Z99jd3oA+Iyxx6z0g+4MD49QKMhqhBAIYXVhURlvHOh0Bm1Jg0pjcDi8oSFK/8AQk8WdqJ/BZVMbUmMSojNb2Zzu/Duu6gpXZaRlLknLGNxMrR8D4Cy4KjpjbBygvyTcSUlaWuaS9BWj29mdDFpBYmJCYUVlxi19eU3He3U8gEondTlp7ehO4LNZS9vHxWyZwaHhoWHK49o/EE8iwlh9v4zL41PpY1TaUsYolc7h8IaGhvv7B5lM9l/10zm8ceDz2FQa66FPcLDGhKyKNkZl8sen1MBgsLjjwOPyWIKPZlNro90u/PTdeRP3Sirwxpa0g4vcMoODQ0NDw8u9HyDWEkIdgZfzx4FGZ9LHljJodAaXxx8apgwMDrE53MXUL2JVLD63rzTUQV3OPrSgd3yczaItaQcX3x1kNUIoFmp1aVlVZhaxu7unpbWtdUmjpbWto7Ozqam5sbGpvaNjMfWLXFVLe08/hU4fHe7pbFvyDi6yOw2NjX39/Y9r/0A8iQhhdVZ2Xn9fX/fy0NXVRaVSR0ZGFvMN9wfLUqnUrq6uZWrqCtPZ2UmlzvIlbgRiJoQ6ry7l8/nM5QEAgoODYmNjY2KiF/lvdHR0cHAwTL7t9ETDYrF4PN7j2TUQTywLtbqktDKPVMBmsxjLA5fLDQwKiYyJvx0YEhgSFhAcKtq//kGhUdGx4eHhMPlexBPN6OgoE72GiRAS4aweHx+fraJFwuVyg0NC/YPv8ABGmTyRgwfgHxgSGxuzTO1cYZhMJgO9sIUQEuGsXr4EWlwuNyg4xD/4DpXB7h2iihyjDHZAUGh09Eyf130CEYzYj7sViCeMVWR1cEhYYGj4KIP1iKujPQP0YTaPymL1D4z2zGM1KzA4LCYmepnaucIgqxEisDRWd6blZsVWLuYBqNnG6p5B6gAdxmGsJDI5MrignsEaEH2s7i9P8DbUVJHHcVxO0yu+lg2jRSnpqYvPhSJIxrQMOVWQ1QgRWKzVXfmhjipSv7+/7Qx+r3MR7ZhlrKYPMailyf5WqpK/rP/1hHRQCcCw6GN1ofOJ3z/8YIcUhmGXT4jJusTmxdiqaSpY5nAX0XKAyWRMi6/nEZDVCBFYrNXd5GAHpbN7vzxwWSu+ZxHtmGWspg8xqKVJfhZKJ7d/ukdK8W45jM9n9RxjdYHTcVlMM4MFANAdqGJiKq+jY2NleG3RmZt4RHt1fS0nMrIasRoQ0moej8+blvcHAABGE5SM9WVDmwDGRcrjw+PxeTxuSOgM59WCI3CAntCrumoX/e/Pb/UcY/U0q4NUTEzltPXdfdQVzHzscBxXsg3J7OABAK0q/oa2PI4r2t7J7QcYLs7LDHB3dNDDcUXbO9ldAMCoifM2xnEcx+WUbMOIA8zaa9p6yGrEKkE4q7lcLpvzUN4fAGgIvKylKRtaB8ATLe8Hi8Nms4NCZrsGzqJDlfdFNWXpgKJFjdWl1y8c2fy/A+dxHJeVPKPunVZJvKUutfOXQ4qGGHb18L6T6l6k3t4KF12J33b/iWF/7N5x1Tm1gXgLk9jy1WFFHQw7vHsHZh3RxGBUx9+209Y3MDDQOycmbRYcl+BqaqKNrEasDpbS6vpFWM3hsINnGquFt3qOsbr0+oUjX23afw7DsKsyctiNzNQ4e5U/xGT92gAAaj10TI0cQ/ztMXmtW10AwIxTVlDW9rh1Q0VWWiuBBgCsBBXJU6ctigGgJz/czsjIyEB617ZLug7OtlZWushqxOpAaKtZbM70l/vHARoCL2tqXgmpA+CKliGAyWazOcHLPlZPPQKHPFMjq/Onzxm5WXiWAABwSA7aVtaWlkYmDgaeNQAAUOqpZ2dtbmNu72DsUQwAAOVeMpqqpuHFGX6GxyXEMQzDxbZulTFz97C3tERWI1YJq8NqBpvN5sx4Xr2kY/VUqxkJmmraMmfP69sbuZC5AMAhOWiamV+7428vOzFWM2IUcSVtDx8vZR1Vy3wAAGqMIq6kGRsbegVTuBjLBgCodzEw1bRxskNWI1YNS2J17c3TcnJn/KoXZTV7jrF6DCquSWBXTvkUzn9na46xutD5+I6PPtx5Dsdx/PCe3cqeAaHGelpKFjlcAOBkm19VVXYp6im/pi+xbc8FHD8pdkT/ZnoDOVj9wvavTyjiOC4udkTHM7Wzq83XVnbPgXM4jkttX7/hgLSDk4W+vhK6s4VYHQhnNYfLYTA505Mcsdmc3sK78bHhxV0cLkPEbD5MNpsdEho6y1g9NszoyA6OvhtSuICnUOYYq/vK4q/rqyvhGIZhCtZ38oZ4jNLU1GRSBx8AeB15yWnJpD4AVnXcdU0cw9Q94muYAOXXzOWP7L2gg2GYukd8FRUAYLQ8+rqmHIZhuJK6kW9GSTEpJydVUM+SgqxGiIBQVhdyOBwGg/VIkiMWG4C/uMRALBZL8HbHTGO1UE+MLvVz4OwsU0xd1bl8ySoUBmQ1QgSEs5rL5bHYnCVPckQfY3I4c5xXCxFL/xw4ryMvOS1lGcbhhYCsRoiAEFaT84soFEpbW/vSJzlqaR0ZoYSG3UHvbD0EshohAkJZfX9kZGSZMgeNjFBCQsMiYxO5i3u/mgMQGR2/ZqxG71cjREC4q2VsNpvFYi1HHh82mx0UGHjgwKGomOjA4LCgkDui/RsZHXXg4KE7d8KWIhPJ44dKpaJcKAhhEcJqErlw+TIcCRLuRUVGRkVGRkVFRkdHifZvRETEmklvxEBWI0RCuLF6+TIcMRiMsbGxpaptCat6vKAjcIQICGf18uVCEQxNq62qx85a6gtixUBWr2rWUl8QK8aire7MDrGSx3FcaeLVYxGZa/cVchWzVrWQPETLlqtINJDVCBFYnNVtGY76p/Yel8Iw7NDuHVcsw+rpIrZj1t1X+FXMWtVC8hAtW64i0UBWI0RgsVb73LmX1AEAwErSkL961aNCxEFu1t23Nd07LDyxAwCAmaQufxXzKJ9nFbNbTXLQ0NN0Kppz6drrhibaDnnIasSTi5BWP5ThaEpFg7EaCnK4WzEfQJQMR/SxsXl335EETSUFuUVZrWliZH8nr6gmPsj31oxZja5KbPvljOqNSgBWzQx5jmzMVUyCUgtImb46OI7jml5xlcv6wXhkNUIEhLN6hlwoDDYLAIYLrc7/dljOvXwUeBxRcqFQqbR5bsxSS+2ltx9V9lrEETjJQdvK2t7FRu3kz9/sVXgkq9HOcxh2btfGLw9dCGkYqPDQnyHP0f6rSqb2hoZmulcxAwMD/csXFZxDCheThVHUviAQs7M4qxksFgAMlwTqn/7trFnA/aHxcR6TsQxWU0vvmJ7dftEqrHj+pONzWm1p5eDhqH5CDJshq1EHAEC+hZquikd4kL2s3KN5jrTTOQBEY/Gt326/YGRkZPjnTxv/t0s2dDEpk0XsCwIxO0JbPTVrAoMPQCkONpL65aRBYPEIADBFzXA0OofVtNJ7Fn/+dtb0TumCPvg6j9W2jtbWDsbXZslqNF7kbujgaGlh+HCeI1tzGztDz2qAcjfJI5v+d0wGxzBMRc/UOjitsnfBm1tYkNUIERDdajqbOz7WEG149fdTZuEdE9Xx2Cz6mCi5UGa1mtWUbK6wU8oqrnuhXZrPaiebB9mIZshqlKQtc1XF617QQ3mO3G54WlhoOxcD9N25ckJa0bcPAAC60rITE+poC22a0CCrESIgutUsgOFs012vPv/cJ4cwdSX8iqy8bWBmE4vLZYti9ejMDzxTC6z2vvb8cxuPyKsp4jiu6hSaP5/ec93ZUtA3MLY0epCN6NGsRpd+W7dxD36zqv+hPEc1aW7K6nIWuXyAgaIbNjKHxc/hOC72x25Fm7CyEZE3/3wgqxEiIJzVUzMcMTnc7pLYW9Zqqkpyl6VlpGVkcCv/jEYGh8MSIcPRyGxW1yYHO2lpT6QlwpQdQsgiW83ryEvJySGSch9kI3o0q5GBobFrVH7J4CN5jvrzkv7KndCRFWyBT2Q8Wr6Beq6+IBCzI5TVD2c4orMfro7DFDHD0cjIkn1+fS2ZsJb6glgxhLN6+TIczXYELgJryYS11BfEiiGE1cua4ai7p4fNfmTonx1uWcWYqdWYqRW39OE8gWvJhLXUF8SKIZTVy5jhqL+vb+FWc0n5Izv29xOeHSA8O3ro+ENuMxbwmNqTAnq/GiECwl0tW74MRzQajUajMRYCwKih6QDhn0PrNwyt3zD48jqB2wwHF4aZFfN+MQ2AyuUuqKpVD8qFghABIaxe1gxHNBqNSqUuqOhUq9/5eOidjyfcfu7lAcI/h/YdGTKzppELWADMJz/PEbIaIQLCjdXLmuGIseBDTW4eeeT3ff2EZwdfWfeX2+98PPTuhqFX1g0SnqUeFmOaW/PLF/25+ccNOgJHiIBwVq+eXCjcsvIxY4vRg8dmcHv6YfmMV9SeFITdLAgEPLlWC+CWlD1we+C5l6fp/ddh+QxX1J4UkNUIEVis1eOd2WE2ijgubx2W2QGiM8fuO+8qBG4z7J3nHbrB1jbAJ+lu38SCQ2VR1x2vRRT3L7SVK57/CFmNEIHFWT1S6qN75qff/8CwsxJHVK+F1C7opaqZmHX3FWYVk0P38QHCs4Mvz+A24x/Pe735k6+M2Zi5PZQmRdjsJRDeEfMoW2grF5L/iNeSFhkbldGyJOYjqxEisFir74RG3innAECBiY62rHupqPvy7FaXhIVEhAmzCmbB/VETyxkPywfe2cB+ez3rxVcHCC8wDv14f8+mH57fczm8faGtHCfZqenreVbNWaaNmLRkX9tDViNErSIVWQAAFuVJREFUQEirH8pw9NcVcWq82tUrmHsxH0DI9EYLznA0lqSOy16dN8ERMGCcBcArnfOw/N0NAy+v573yTu76rWlnNRIc7sY0svgAwGsnpeXkEvMLSoiB7g426gq6AYkZaZFeyopqXklN/UU+FqYX/9Rw0MdxxYmMp4yaOG9jHMdxXE7JNow4wGHX5pNJZb3IasTjQjirH81wxOLxGa15t40Pbt2h6BDZyQQuezlyoXTl+1sc3rZLxS2+e948gQwGgzHl2x1Trqg9P/jq+0Pv/uX24DsbGO+8Dy+9FPHPL4MPybPLawHq9TUt1M2cbdWkfv76mJrqmR2/Hzx+StVUXmLLIRWP8Dg//WPff7n1oiqG/bF7B2Yd0cRgVMffttPWNzAw0DsnJm0WHBdto6mpsERZSpHVCBFYvNU8RlOunxkuJXPJOTS1foTHWY68ZV3k2+YK52VlPCLSmkTKW8YtKRszVuQc+GHsny8NvfDW8JsfD707zW3GP54fPXKS4WicvuNYqoeBnqHWWd28cegLwC6cU0/lQZefkZWZlYu9hoQk7t8FAJwEFclTpy2KAaAnP9zOyMjIQHrXtku6Ds62VlYTWRkWDbIaIQJCWz01w9HYlD13MFJJ+pK0UwEbgCN01oS5MxxNMhavIntZVvQco9CQY3g15ph2r+4FyrfrOP95ffi/b0+/E/b2wHOvjT3/OuvEz9EHxSN9iQAdzkbmetcqAUqctC2tbByt7ZxMvQRX18q9ZDRVTcOLM/wMj0uIYxiGi23dKmPm7mH/INfKokFWI0RAdKuZXB69NskzMCy6AQBgMEr5soyMUz4bxoW3eo4MR20ZN+9ECFKOMxLVrsouwmpOnrmGsdLtLhoQY/Z85/ObXLvkWdY//8t4573Bdx56QO095j9fokhK8e11TfbjikFdAC0uxrZWdk42agaaVoUAANQYRVxJMzY29AqmcDGWDQBQ72JgqmnjZIesRjxWRLeaweWxmtKstCR2/SElL4cfPXZIzTGyZnScw2IuYYYjaE130D+198Q5HMfFxY7ouMct8tsdclYkgKHs0ITA/OHB2oSErXsi/vU1/dl/P/oQy/DLb4/986XEV7fEXDACe3WTQ+rGgSH2+PGP3/t9sjWeqZ1dbb62snsOnMNxXGr7+g0HpB2cLB5kUFo0yGqECAhn9dQMRzQ6gwkwVp98y+jKJWkZRefIwl4AngjpjebKcAQgdD6hWU3gdeQlP3TPqTutuDzRPhJsbWe8Wi445Wb+9zX6P19KfO2XFHGpQkcVIxszOVUVTN0jvooKADBaHn1dUw7DMFxJ3cg3o6SY9CCD0qJBViNEQCirH85w9FCSI5HTG62SDEdTnz996E7Y4DsbGO+8N/aPF9mSF8HLB7qXMbP/VJDVCBEQzuqnIcPR/M+Wr+B7I8hqhAgIYfWqynA0B0tiwlzPlq/geyPIaoQICGX1aslwNDdLawKvtJxhakk9dHyQ8OzQK+9MfYhl6tC9TG6j96sRIiDc1bJVkeFoPqhU6kLTqiwAJgALgJpHHjS2GNxzaIDwz7lf5xZkWVqqTCwoFwpCBISwerVkOJqPpbVagMBtRsF9xizvjTycZcnUikrOX7zbyGqECAg3Vq+SDEcrVtWMzPM695JmWUJH4AgREM7q1ZYLZbmrmps57oQt1dXyFesLYi2BrF4s0++EvT7ttbBFXy1HViNEYGmsZjWlJCSE5S/i6+zz7r4LX8WsVT2Un2jedEXC5DOaOCy30+Ec+GHs2ZeGpr43MsfVcl773KtAViNEYEmspmSb/L7ph/2O90Vvx3y7rxCrmLWqh/ITzZuuaCH5jB6mPsfwarSkzrCYxNCch+VjplZcwevcarrSlmSesH1ZVsaaOXcCWQnlfJGvooy1cu56MsPzePM9tD/DImPzl0XMzRJYPVQcarbj7fUH1W+WiX58PvfuO1QcarbjrfUH1X0WsIrZrSY5aOhrPXibikOyV9fVuVY5e0211w1NtB3yhLCam2uqZqx6bxgGBsDDE8QlBgnPDr/47sjbG2dwW/A692977njGz7bzL7vVM7rUm0Df+zPlgg9PGKvHm3JYt/3ZZQMAAN0JtF9fGNiqzR4GaJsyfw4eLNIrdCeEZVpT1yJCWj0twxGPMw7ArHI3N/jz4A4Zc3OXPBbAuLDpjebPcMSpvmZpeOHQTllLS/f8+RWb3eo8O00TY++6yenamxYOVy9qud67ndLCBgBGU9y96NCyPlpzio+2PI5fldj2yxnVG5UAY1Wxnpo4juOaXvG1bKCVkzMD3G1tNK2tbe3t7aekN2LW3TAzvnhO3dFcTd7sVohLAsvKqv3S7to3CMP/eOWRO2FvDzz32thzL4+ISw7Mcsq97Fb3ptIPrB86aMLpmzKTmTcmuXdELlA4q7MtR7b8SA3qBABgdXATg1mJJXyAceKU+XPA6OImhbCSivnLP1ZPa+paRDirp+VCYfC4QK/xtpFVvOERYmNhrGmTRQfgCZ0IZZ5cKMx6P3tc9dbNcHs7cx3HBby2PKsJ/GIvxZM/bRW7iuM4juOY2PadcnJyp/84dOhP6//f3p1GNZWmeQDv+TCnZztnTk3Pcsaa7urpPtX2WHZT2FVaWraUiluNuBSlIoqKsl2jQAgQIAmbYoCEACKLSOFSiluJgCK4gSIQ40JKEBQLSx13lCRkuUlubvLMhwASIEIgiF6f3+GLOe9N3qv8zZt7c//3phmohi1BAeuj91buEK76avYagljjPn7iQt+Dt542luwI2RAQGxsrCFjPLjgtO7MjeMUXLvOJCKEwNWNHXq96o8oLu/mLeyqQZnOyStXQ8UzaflAMhYdgXQB88O/6cb958V82y3LFv3z40s7htFFPdftFnZeLYqWIUgGQd6kj6VpOjD57i9pjhSpkPw0AoKerD5HhMdpIHnmwltYDwHNTRQVVctLwQ4GWw9MVnqOVlKWpgtzgrpgwSenhTx6Rml+oTFVHDZcaTDXVpL/18UCypJqquWDILTLeUgGA5eY5Q/ZeY0P3WzP52HTmsOHMj2YAuHfJkMrXhkWSRRfoV1fp6eiaMuP3B/QFebrcUtNzADDazE0HAGBp67Wtrs/8680WsDSWv5qqzfMzx/BTrTcB/fBESgg/85gOnu8TJMbmXAMAWufc3rInlZKwuJwyPaiKErcl7BrC2d9BUv2lZxBBEARBBH4zbapP/KHLZ8XB7LDMh+13RcEJ/LTiI1nEJm7hQwAA2bZwXtjO0uJtK2d8NtM3Pj4+bu3U/5m6PIATsSmEiK60dhg/kfaqN8rMzRyoAunu5WNRcYLAL2dt/MeJpb+ZCR/8B/nBv3X0bWIZ4EyYHqB3B5vzWVPtnW5SG+jDHNWU6ap1XHKzl/J3Uzu5x2jQ0pUi7fqNmmiRTshWe63S5spo8mc9sVj5+wXqmFSt7wLFxDmawit00ynSb7ZiwiTlwg3k4XpzW71u0Ucd3yboz1bpg6yP+5PHq6gDQtXvPulMkVoATBk+yt8u0JZ1X/1mXTUsERnbbhtCvFUL/bR8AXmwulfqnhnivZR/P0HpGazJLjG1d9AVYpu55V2j798xbFrZtW1RNa3roCt6z99HW1BrajhJ+ndP9UA1prp3awJFg6l1b4C76x8+92KHLvvS5S+uMyO+r39AmWhnNhw9PETMnTR+ymp28Irprp9Pco8+JHsyyC4NfQWeH5vAy7+nbZOEJycK03dmZIv3y8/vjBby8m4BAFiuZ8dJ0sXp4sAVn/55qT+LIIgwfqK4uHIXNyIlPkcOoG89lR3Tu95oR7bIfgXSxvCVk5eER/vwLnp4VvgJtcuWd/zNP/duUOtzJozcmqyWygwO/os6xprqtXnUTTm57HOlVw4NAC171K5/UnFPmDW39eu+6JiwSCPMItP56j//a8eMaOOdB0bego6P15HXASxSncdEhU+2CQCuZXbOm68pfgoA8LJat8JF4SWmLAANvR5Xyci1sxVfi6mfW43sb1SeIkphO5P1+VTdWe0s146/btQ39PmE3W5MXqcc942ush0AQC8jfWzn5h5rrCjRuv/l1ba0jPSZYjNmWohRCfDj9ldTYqLhp5oy6e/W/ZDFZYcEE+sXTXVx/fQrzr66B0aTyZkNR0+ule7khYdtJgKXTnP9bNLsqKLLw09136NlkkgBd/sNoG9nCYiPxs0R7qnsBGUxz2dj1O7HAECejvbfGFZwvCjGJzBkj/WD5+PquqoTexITt/Ay5ADP9y3z3dS73kicKX59BRI/LrywpCCH7ZdWef/RCxD4GiZ/SP7Dr+ycCfu7l/MXqbemjOL1ntYsbdhlPHdCM9NVxS2hAUB/mVy3RBV23PzkKrl28stJizUR8dqYRF18Enm4hn7WbODMV86NMtwD0NbrvF0UK1IpHVguCjvnzNPsb331tCvFFGn7OFCm/Rzl+KWayCjNyv9VC6stfWayKsP0VEVX7dfM+kQxYbpmdw398tUIY4K3yp1raAMAgKfndatt53bkkvnxU/pCUde2By6bb1eR66bYjDlYRSvBXJ3ca0oMNOxU67U6g6HngPRVcWgURyQFAJNW59SGox5NGeEC7nb54Lvk2JmtbfUA8HOe52cTpgSXqQDgxRVx9HK3ub4s1oYZH46fyypoam8uSvP3WLaGxWJ9u3h+9HdF3/GiY0KF9RbQtuQn29QbZe3c7rvgdRVI/z1zWeGt9sYc/rd/nUeEB0V7+n066dTK2IHPhP36445fjfLl3NYs+e6kZDW6hZ90rMqnAaB5t9plYtd7tY/rS/ctlM1fZ4sheJ5yVoShDUBT+yq91Vs7Xadq9rQBdL9X938cwHJrv3be1Jfjfq9Y4keeV/SdyZpM45V75naVhWzRf/vHF39YTdb0LJHbjYmrVG5hhhYLAIBWRnr3m9vDFvOT7m0nBBoqzhkCJvebP5grbabEPI6luk/DkfVHZzSpWy+UniqvuqM1Gkeh4QgABqwnsuM130KxeQrrH2XPAaAtO4odJDjbteLTNJfnc1kEERuXkFUqu94OAI97SpYq75hA03Dm3BnpQwsAqJts6o1uNN+o2h0XEdpdyNSvAil2V3mjEsDQUp7PZREbY2MjssqrHoHhdot+TG4DaP00uyiZevrClOGlmOiiWh+ti16r/O2UTmI/DVq6NFE1ZYZyaaiOF6sNS9KfvGkxtxn8vlBMIvStAOrqrkPoarC07tFMGd/xp6W6I1Lz3Xrdon6PWw9NGR4ZRWs6/vaflOtyKEW/mSwRGxtbjTsE2qgY9Yz5ysXJxrs9qX5miPJQugTom6xv8B10se3cyhrNd68b03u2FVP3HphPJtmOkZsBLM22U2Ich1I9QMOR9UdjALMFTAby3Ws4MrWVZftPn7whpaBtzL/DNfTbADot29r71NEc8mgtbQZolxt3xWnZ0eTREmNxtfGU3AwA0G46VaDl8rUxfG3oFv2JJotFQ1fu0+85beoAMD6gjuaQR+toPYDpkenUXm14BHm43vy83VTc7/HuQ1PmsoTOj1zUaTWWAWYiNQPQdcVkCEcb9Z3R5qO1lr7wg76w0tTevZ3Fdm6lNywA5tpX21oAwPzcdkyDGQCovlNiGMdSzcCGI3VL6Q5u6PbipmHf+G8U9Hy3/MVrqxreybtza34yhM16+YmXrkox+GA0LA6k+r1qOHobmOQ3OhOF1qoG5tydW/MTVbRd9301jaEeNQ6l+n1sOBpbRoDOOimZKHyjy3L0jnPsaNl72HA0ttSdnT3nq9/A5dyIGRxI9fvccDRW+jccDV5s/C4uy5FTOfZejQ1Hb5i9hqMxOFqO3h2OpRq7UN6wQfdliMtyzPZ7BVP9VhvivrxV9xtBY26Eqdb9fPGgOCosmMVisTgZhwe98sIu+7++Dr/EIEmw11s0lD4jRzqPnMKh/6Ecu99I42vqItC7bYSpfnw8aOWMX8/wIgiCYEsODXrlhV32f30dfolBkmCvt2gofUbD6TwakeGtO4ayLFfNXmCSykZjzmjMjSzV5qb8kKTU7U649sXury/dmB+y1aGXGCzVUkmkgJte3++9uk4cLuDnNb/uqem6tAg+N2ME/WwOGsmnidcvy1/84pe6pBTnzha9JRxMde+GIzOA6VpOqPf0r5Zbu3+aVABgoUxObTiyNOwMWzXdzfoSFS0juX+1FSWVRAp4eTcVD84UJvQrJ1obKRGwWCGiozWPAYC8VV5gM+Z2TkxCfNqxy/K6A9npEj6LFSI6WtsO0CE7070ypx9Kz1+qrZNdkdcdyBZtCxXknbg97O8aj/wYwcDLckw1ozmWapuGIxrgWQV32Yz/nLR4I0EsWeoRmVl2qxMoyqldKKqz/BVu4z5bupEglnku4uWcujNYbeVQUs3Pvam4f26/2G450Swi5fhdkmw5ta/3mPKKrG1iUVpmarjPNBePkBiC8Jgza3NW1U8Xc0MjNllX5lRNUrAgdmtaarjPNJf5/sG8nLKxTHUPm7fuX/xSNWs+VX/ZKc+M3jYjSDVFm57JjxwuPdKgBoAXxzb7bfDPuk6BhXJqqptKjpeXNOsBQHsiJCggMP/mIMeqBkt1vSSSH5neAACPZYOXEz3tPUaSKRJliiQ70jiEf1SFBgAMFWHeGzYlpIlTknnWPgZKKokWJneNqRzhFUFOP55vzbYuYZvpxohuFYTeZg6nurs1waDT6XVd+bLoAahrWRGxnC1nNAC0ExuObDTlRidyky9Srx81cBLoB7XnLlY1vAS4vp27JaHgQnN1oWDI5URdY7Jz01IzRKnpKeK0+NyGrpFBAkEoL1KcIsi6YgYAWpbJSxGlpqekiuKyR/oJnEln6dAbM/xU60209vbpvANHyn4CAGjN4/ivjt57hwLa6MSGI3hQXXj0+OmHAAD/V8gNWss/PFhxgp1UyyWrfHxDqgFuJ28KZ+39/juCFepQOVHsFm5qhjg1QyTJFIXxwoWyrpGb2VFFh/dGJvATpAAAIE3i8Dji7WlCIS9jCJWow9gXhF5r+KkmTbTh7vnkqOXui302b1o9c7pneHLdE7AY9U5tOLpfJRGsnOe5lsVa6z5jeYzkavtgu2QnCdrWg0kBc772Xr1wvjc/p6mleX8a4VA50cdf+0kytsULE5IysxKCZrt6hnSNzD379Omj3SkBM+d6s1iszR5//MKHK0rbIhCEjvgcGKYaDYNjqe7TcKQH0N05szs+cINfIHvH8avPwUKNQsPRQ2u9ECsqv7x5CHd4sZsEy6OLh5I2sdhdT6NudKycKH5PtbxBWiutqzmeJQlbMs83ZsCRfEFc1snGa1drL106N5RCpuHtC0L2OZTqARqOtL2uiab0w6w3GsuGo+Go3xoYzsl8E9+7xFSjYXAs1QxsOBqGoRcjjhimGg2DA6nGhqM3j0n7gt4Yh1KNDUdvGkmSulG9Iw9iIodW4LLRazhyYoEJk7pQSJKkqEHOzyPUx1BT3SBvunpNTlHGUfrdtcb7bXuqMUfT9u5Xj5BdQ091o/xHvCIXoXeAA6lukOM3hxF6B2CqEWIaTDVCTIOpRohpMNUIMQ2mGiGmwVQjxDSYaoSYBlONENNgqhFiGkw1QkyDqUaIaTDVCDENphohpsFUI8Q0mGqEmAZTjRDTYKoRYhpMNUJMg6lGiGkw1QgxDaYaIabBVCPENJhqhJgGU40Q02CqEWIaTDVCTIOpRohpMNUIMQ2mGiGmwVQjxDSYaoSYBlONENNgqhFiGkw1QkyDqUaIaQZItZubW2hoKJvN3hwcHBwcah3B5nDYnPA4hNBbz83NLa53quVy+VhPCSE0UnK5/FWqEUJMgqlGiGn+H+M807lF83LXAAAAAElFTkSuQmCC)
ii. Reset Identity by DBCC CHECKIDENT WITH RESEED option
In case, you can’t use TRUNCATE command then you can go with DELETE command and DBCC CKECLIDENT with RESEED option.
In case, you can’t use TRUNCATE command then you can go with DELETE command and DBCC CKECLIDENT with RESEED option.
·
DELETE data from table
DELETE FROM City
DELETE FROM City
·
Now use DBCC CHECKIDENT with RESEED option to reset the
identity:
DBCC CHECKIDENT ('City', RESEED, 0)
DBCC CHECKIDENT ('City', RESEED, 0)
- Now insert the data into table and see the result
Now Identity has been reset.
3. Conclusion
By using TRUNCATE
TABLE and DBCC CHECKIDENT with RESEED, we can reset the value
of Identity column of a table in SQL Server.
of Identity column of a table in SQL Server.
No comments:
Post a Comment