Thursday, December 20, 2012

UI Design using Bootstrap

CSS Design UI using bootstrap Link:

Sunday, September 23, 2012

Select 4th row in Sqlserver

Hi This is Simple example for getting 2nd or 4th row record frome SQL Server. Code: SELECT items FROM (SELECT ROW_NUMBER() OVER (ORDER BY items) AS RowNum, items FROM Tablename) sub WHERE RowNum = 4

Wednesday, April 25, 2012

Replace Square box in SQL table

In Sql Table some Column have value of Square box, if you want to remove that box please use below SQL Query:

 select REPLACE(ColumnName,char(13),'') from YourTable

 If You want to use in Where condition trim that Square box use this :

 where REPLACE(ColumnName,char(13),'')in ('ColumnValue')