A couple of queries in SQL,Please Help..

[SIJUTHOMASP]

Hai, The following is my queries. 1: Is it possible to have check constraint with a local variable? 2: Given the following scenario: I have three columns in a table ,say ID int,name varchar, address varchar, and I added 10 records into that table keeping ID colums NULL.Later I want to add values to ID columns 1 thru 10 but with a single update query.(It doesn't means you are bound to use only 1 satement in the batch, no loop permitted ) Please show me a right way.Thanks very much. Thank You, Rahul.P.Menon.

[goyal manish]

just use cursor or while loop in urs stored procedure.

[SIJUTHOMASP]

Hi Goyal, Can you please explain with an example or with the code snippet.Thanks very much for the reply. Thank You, Rahul.P.Menon.

[goyal manish]

for eg. in urs stored procedure use following declare @temp int set @temp = select count(*) from table declare @@count int set @count = 1 while(@temp >0) Begin Insert query set @temp = @temp-1 End