SQL Server Management Studio Example

From NovoWiki
Jump to: navigation, search
JoNovoLogoVerbage3.gif



SQL Server Management Studio Example



The following example was executed in SQL Server 2005 Management Studio. The 'New Query' feature was used to open the pane entitled 'MAVSERV.M....QLQuery1.sql*' The script copied from the schema editor was pasted into that pane. Then the 'Execute' feature was used to execute the script. Finally the 'Command(s) completed successfully' message was displayed by SQL to indicate that the script had worked correctly. If the user wanted to verify that the command worked, they would then Refresh the data base and verify that the table(s) were created.

SQLServer.jpg

Personal tools