I am working with SQL Server 2000 (connecting with SSMS 2008).
In SSMS if I click on Open Table (or Open x # of Records) I can then edit the records that are displayed. If I run a Select Query and then view the results set. Is there a method where I can have the results displayed in edit mode? I want to be able to edit the records manually that are returned from a select statement without having to do this with an update query. I have no issue doing this with an update query, but someone else was asking me if their is a way to do this. Thanks.
Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.