SQL Server 2012 - Which of the following statement restars the numeric value generated by a sequence to a value of 1?

Sequence object definition is
CREATE SEQUENCE [dbo].[SequenceObj] AS TINYINT

 Posted by Bandi on 6/26/2015 | Category: Sql Server Interview questions | Views: 1837 | Points: 40
Select from following answers:
  1. ALTER SEQUENCE [dbo].[SequenceObj] RESTART
  2. ALTER SEQUENCE [dbo].[SequenceObj] RESTART WITH 1
  3. EXECUTE [dbo].[sp_sequence_restart] ‘SequenceObj’, 1
  4. Option 1 and 2
  5. All Above

Show Correct Answer


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response