Today i studied an interesting thing related to GO statment See in the following queries executed .***The batch preceding GO will execute the specified number of times***. create table test( id int not null identity (1, 1) primary key) g...

...

...

...

...

...

...

There are four schedule types. 1. One Time : It executes once as per the schedule 2. Recurring : It is recurring type and execute on specified interval on specified time till schedule end. 3. Start when CPU Idle : It executes when CPU is sufficien...

There are four schedule types. 1. One Time : It executes once as per the schedule 2. Recurring : It is recurring type and execute on specified interval on specified time till schedule end. 3. Start when CPU Idle : It executes when CPU is sufficien...

...