12/13/2023

MS SQL learning note

  •  comments:  /* comments */ or --comments
  • Right click on a table -> "Select TOP 1000 Rows" will run the script below:
    • SELECT TOP (1000) [RoomID]
    •       ,[RoomNumber]
    •       ,[BedType]
    •       ,[Rate]
    •   FROM Table.[ROOMS]

没有评论: