Browse: Home / SQL Server

SQL Server

Case Sensitive Search in SQL Server

By Sumit Gupta on January 19, 2012

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 good to not having case sensitive search by default, as except password compare you most often doesn’t need case sensitive search. Do you? well I [...]

Posted in , , | Tagged , , , , | Leave a response

Reseed Auto Increment Value in SQL Server

By Sumit Gupta on May 7, 2011

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. DBCC CHECKIDENT (<TableName>, RESEED, 0) Works great for me on Sql Server 2008

Posted in , , | Tagged , | Leave a response

WordPress on SQL Server

By Sumit Gupta on May 22, 2010

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 and how many BIG fish are actually going to use it ? But this is good technical Advancement. Keep it up guys.

Posted in | Tagged , | Leave a response

Pagination Query for SQL Server

By Sumit Gupta on June 17, 2009

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 does pagination work in MySQL in best known manner for me, BUT microsoft didn’t consider that option yet. But today I found a method for [...]

Posted in , | Tagged , | 3 Responses