Database

<br />
ALTER TABLE tableName ADD value int NULL<br />
<br />
DECLARE @i AS INT<br />
DECLARE @j AS INT<br />
SET @i=0<br />
SET @j=0<br />
<br />
WHILE @j<=(SELECT MAX(id) FROM tableName )<br />
BEGIN<br />
SET @j=@j+1	<br />
	IF(SELECT COUNT(id) FROM tableName WHERE id=@j)=0<br />
	BEGIN<br />
	SET @i=@i+1	<br />
	UPDATE tableName SET value=@i WHERE id=@j<br />
	END	<br />
END<br />
<br />
SELECT * FROM tableName WHERE value =3<br />
ALTER TABLE tableName DROP COLUMN value<br />
<code><br />
<br />
Hope it helps... <br />
<br />
<div class="ForumSig"><hr><small>  <font color="Brown" size="2" face="Curier New">I Love T-SQL</font></small><br />
<small>  <font color="Brown" size="1" face="Curier New">"Don't torture yourself,let the life to do it for you."</font></small><br />
</hr></div>

DECLARE @val AS VARCHAR(255)
SET @val='-0.026880000000000'
SELECT SUBSTRING(@val,1,CHARINDEX('.',@val)+4)

SELECT TOP 3 * FROM viewName 

SELECT TOP 1 * FROM viewName where Columnanme=conditionvalue

SELECT TOP 1 * FROM viewName where Columnanme=conditionvalue

select top 1 * from TestView where customer_name='CustomerNameInRowSix'