Ensure Table Has Only 1 Row

• Peddi Praveen kumar

  SSC Enthusiast

  Points: 115

  More actions

  January 24, 2012 at 4:26 am

  #249546

  Comments posted to this topic are about the item Ensure Table Has Only 1 Row

• Mitesh Oswal

  SSCrazy

  Points: 2798

  More actions

  March 6, 2012 at 7:17 am

  #1455284

  onclick:if_IFCode('DECLARE @tbl TABLE

  (

  ID SMALLINT IDENTITY(-32768,-1),

  NAME VARCHAR(100)

  )

  INSERT INTO @tbl

  SELECT 'mitesh'

  select * from @tbl

  INSERT INTO @tbl

  SELECT 'mitesh'

  select * from @tbl');

  Regards,
  Mitesh OSwal
  +918698619998

• akljfhnlaflkj

  SSC Guru

  Points: 76202

  More actions

  May 11, 2016 at 7:05 am

  #1878179

  Thanks for the script.