Sumit Gupta

Tag: SQL Server

  • Case Sensitive Search in SQL Server

    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…

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

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

  • 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 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…