Mysql mostly provide a Case sensitive search because of its default collate configuration. However SQL server use different collate and hence by default it is not case sensitive. It is…
Tag: SQL Server
Reseed Auto Increment Value in SQL Server
You can reseed the Auto increment field to desire number by using following SQL statement [I think it is specific for SQL Server only] other Database have their own methods….
WordPress on SQL Server
http://wordpress.visitmix.com/ enables you to use wordpress software with SQL server instead of MySQL. Not sure if it is a good move or bad as SQL server are expensive to get…
Pagination Query for SQL Server
In recent past, we got few problem when we need to do Pagination with SQL Server. I specially got frustrated when I saw that MySQL server has “limit” word that…