r language

Technical Article

RE: SQL SERVER AGENT ERROR

  • Reply

Can forum participants tell me if the following would possibly have an adverse impact:a.  an OS backup in progress which was temporarily reading the event file.b.  a virus checker which might have been reading the event logc. a remote reader of the server's event logd.  an OS search type function which was scanning the event log for […]

You rated this post out of 5. Change rating

2004-03-19

1 reads

Technical Article

RE: Return multiple rows from a cursor with just one fetch

  • Reply

You can do 10 fetches. But this will generate 10 result sets ... :create procedure aa  @rowset integer as begin  SET NOCOUNT ON  DECLARE @pos integer, @co int DECLARE cPartners SCROLL CURSOR FOR SELECT * FROM partners    OPEN cPartners    set @pos = @rowset * 10  set @co = 0  goto FETCHNEXT  while @co < […]

You rated this post out of 5. Change rating

2004-03-18

Blogs

Small Data SF 2024

By

I can’t remember how I heard about Small Data SF 2024, but it caught...

A New Word: Moledro

By

moledro – n. a feeling of resonant connection with an author or artist you’ll...

Snowflake + Azure blob

By

Let’s go back to data platforms today and I want to talk about a...

Read the latest Blogs

Forums

7 sept, scheduled book

By philip.scott

Comments posted to this topic are about the item 7 sept, scheduled book

7 sept, schedlued article

By philip.scott

Comments posted to this topic are about the item 7 sept, schedlued article

6 sept, published book

By philip.scott

Comments posted to this topic are about the item 6 sept, published book

Visit the forum

Question of the Day

Azure Data Lake Storage Gen 2

Azure Data Lake Storage Gen 2 is built on ...?

See possible answers