Feedback will be sent to Microsoft: By pressing the submit button, your feedback will be used to improve Microsoft products and services. Privacy policy. Applies to: SQL Server all supported versions. SQL Server provides tutorials to help you learn new technologies and features. Tutorials for earlier versions can usually be used with more recent versions. When tutorials address a newer feature, they will indicate the minimum version to complete the tutorial.
Tutorials for SQL Server Did you know that you can edit SQL content yourself? If you do so, not only do you help improve our documentation, but you also get credited as a contributor to the page. The information laid out above is given in good faith, we are not endorsing and third party company by offering a link to their site.
You should always do your own research prior to making a purchase or using any service linked to via this website. Prices or details may alter and any information listed can not be guaranteed to be accurate.
Note: While this course is comprehensive in regards to covering material on the exam, we do recommend using other aids to guide your study. How to take the Microsoft Exam: 1. This course covers the material that is within the certification exam, and will help put you in a great position to succeed in the exam 3. Pass your exam! If it isn't displayed, right-click the Databases node, and then select Refresh. In this section, you create a table in the newly created TutorialDB database.
Because the query editor is still in the context of the master database, switch the connection context to the TutorialDB database by doing the following steps:. Paste the following T-SQL code snippet into the query window, select it, and then select Execute or select F5 on your keyboard. You can either replace the existing text in the query window or append it to the end. To execute everything in the query window, select Execute.
If you've appended the text, you will want to execute just the portion of the text, so highlight that portion, and then select Execute. After the query is complete, the new Customers table is displayed in the list of tables in Object Explorer. Insert some rows into the Customers table that you created previously. The results of a query are visible below the query text window. To query the Customers table and view the rows that were previously inserted, follow these steps:.
You can find information about the connection properties under the results of your query. After you run the previously mentioned query in the preceding step, review the connection properties at the bottom of the query window.
You can also view the query duration and the number of rows that are returned by the previously executed query. You can change the server that your current query window is connected to by following the steps below:.
0コメント