[Solved] How we can insert data without using insert clause? [closed]

by


Yes, you can :

  • Right mouse button on the database -> Tasks -> Import Data…
  • SELECT * INTO FROM
  • Right mouse button on the table -> Edit Top 200 Rows -> copy the record from another source or fill in the data yourself
  • OUTPUT DELETED. * INTO/ OUTPUT INSERTED. * INTO
  • OPENROWSET

And probably some other ways someone will find 🙂

solved How we can insert data without using insert clause? [closed]