In this article I will explain how to Change MySQL server connection collation in WebsitePanel. Learn More
Tags: arvixe websitepanel tutorials, asp hosting, change, changing, collation, connection, how to, iis hosting, mysql, mysql collation, mysql tutorials, phpMyAdmin tutorials, server, websitepanel, websitepanel hosting, websitepanel mysql, WebsitePanel Tutorials, windows hosting
Posted under WebsitePanel Tutorials
Sometimes you have tables that have an identity column (SQL Server) and whatever reason you need to reseed (reset) the identity column values. This may be a result of inserting and deleting a lot of data during testing a process. It might also come up if you want to start the sequence at a different number or you backed up data and want to start it over again (like in a new year). You could create a new table and then import from the original into the new without the identity column, however; this is not necessary and a lot of extra work.
There is a way to do it without having to create, insert, drop.
For example if you want to reseed a customer table starting with 50 then your syntax would be.
DBCC CHECKIDENT ('Customer', RESEED, 50)
If just want to know what the next number is then your syntax would be.
DBCC CHECKIDENT ('Customer', NORESEED)
As you can see that whatever your seed number is the next record inserted will be the seed + 1 so in the above example the new number would be 51.
Word of Caution: It is not a good idea to reseed an identity column in a table that contains data without validating the impact of doing it.
Tags: MS SQL
Posted under ASP .NET 4.0
This article is for those that wish to make basic code edits to their Opencart store with Adobe Dreamweaver. There are in fact many ways to edit code in Opencart including just using a basic notepad. Adobe Dreamweaver is a pretty popular web editing tool and is one that I have used many times. You don’t have to be a genius to use it either which makes it even better for those that are not web savvy. We’re basically going to load up a .tpl file and show you some tricks to finding your way around the html elements of that page. Learn More
Tags: adobe, dreamweaver, dreamweaver find replace, find, how to, OpenCart, opencart dreamweaver, opencart use dreamweaver, replace, use, using
Posted under OpenCart