2010-07-16

Star works In SQL[Use of while loop]


CodeOutput
DECLARE @count INT
DECLARE @ct INT
DECLARE @print varchar(10)

SELECT @count =10

WHILE @count > 0
BEGIN

SELECT @print= ''
SELECT @ct = @count
WHILE @ct > 0
BEGIN

SELECT @print = @print + '*'
SELECT @ct = @ct -1

END

PRINT @print
SELECT @count=@count-1

END

**********
*********
********
*******
******
*****
****
***
**
*

DECLARE @count INT
DECLARE @ct INT
DECLARE @print varchar(10)

SELECT @count = 0

WHILE @count < print=" ''" ct =" 0" print =" @print" ct =" @ct" count="@count+1">

*
**
***
****
*****
******
*******
********
*********
**********

No comments:

SQL Query Stuff

1 . By using this query can search any string contain within stored procedure, function or view SELECT object_name(id) FROM sys.sysc...