Friday, September 23, 2005

Cursor in SQL SERVER



DECLARE country CURSOR FOR SELECT PKID,CountryName FROM countryMaster

OPEN country

FETCH NEXT FROM country
WHILE @@FETCH_STATUS = 0
BEGIN
FETCH NEXT FROM country
END

CLOSE country

DEALLOCATE country

2 comments:

Anonymous said...

How the Internet dealt with Katrina
It took nature a moment to expose the vulnerable side to the world's lone superpower.
Your Blog. It's nice . Here's a subject that interests many; bipolar depression. It's some insight into dealing with bipolar depression.

Sonny M.

Anonymous said...

Microsoft Start Points the Way to Better Home Page
After several false ... um, starts, Microsoft's latest trial version of Start , with Gadgets Preview, is one juicy interface with lots of Ajaxy goodness.
Hey, I like your blog here! I'm definitely going to bookmark you!

I have a expire domain traffic site/blog. It pretty much covers expire domain traffic related stuff.

Stop by for a short visit if you get time :-)