UI Design using Bootstrap

CSS Design UI using bootstrap Link: http://twitter.github.com/bootstrap/index.html

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

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')
-->