{"id":3907,"date":"2023-06-21T13:17:06","date_gmt":"2023-06-21T13:17:06","guid":{"rendered":"https:\/\/wiki.thomasandsofia.com\/?p=3907"},"modified":"2023-06-27T11:52:31","modified_gmt":"2023-06-27T11:52:31","slug":"mssql","status":"publish","type":"post","link":"https:\/\/wiki.thomasandsofia.com\/?p=3907","title":{"rendered":"MSSQL"},"content":{"rendered":"

SQL Server Crash Course<\/a><\/p>\n

1:24:00<\/p>\n

Connect:<\/p>\n

C:\\>sqlcmd -S <instance>\\<username><\/pre>\n
Basic Commands<\/p>\n
* sp = stored procedure<\/p>\n
> sp_databases\r\n> go<\/pre>\n
Backup Files<\/h2>\n
C:\/Program Files\/Microsoft SQL Server\/MSSQL15...\/MSSQL\/Backup<\/pre>\n
Restore Backup File<\/h3>\n
    \n
  1. SSMS > Databases (rclick) > Restore Database…<\/li>\n
  2. Source = Device [elipse menu]<\/li>\n
  3. Select backup devices\n
      \n
    1. Backup media type: File<\/li>\n
    2. Backup media: [Add]<\/li>\n
    3. Select .bak file<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n
      Query Order<\/h1>\n
        \n
      1. SELECT<\/li>\n
      2. FROM<\/li>\n
      3. WHERE<\/li>\n
      4. GROUP BY<\/li>\n
      5. HAVING<\/li>\n
      6. ORDER BY<\/li>\n<\/ol>\n
        Processing Order:<\/h2>\n
        FROM > WHERE > GROUP BY > HAVING >SELECT > ORDER BY<\/p>\n","protected":false},"excerpt":{"rendered":"
        SQL Server Crash Course 1:24:00 Connect: C:\\>sqlcmd -S <instance>\\<username> Basic Commands * sp = stored procedure > sp_databases > go Backup Files C:\/Program Files\/Microsoft SQL Server\/MSSQL15…\/MSSQL\/Backup Restore Backup File SSMS > Databases (rclick) > Restore Database… Source = Device [elipse menu] Select backup devices Backup media type: File Backup media: [Add] Select .bak file Query ..<\/p>\n
        <\/div>\n
        Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[81],"tags":[],"class_list":["post-3907","post","type-post","status-publish","format-standard","hentry","category-mssql"],"_links":{"self":[{"href":"https:\/\/wiki.thomasandsofia.com\/index.php?rest_route=\/wp\/v2\/posts\/3907","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wiki.thomasandsofia.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wiki.thomasandsofia.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wiki.thomasandsofia.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/wiki.thomasandsofia.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3907"}],"version-history":[{"count":6,"href":"https:\/\/wiki.thomasandsofia.com\/index.php?rest_route=\/wp\/v2\/posts\/3907\/revisions"}],"predecessor-version":[{"id":3913,"href":"https:\/\/wiki.thomasandsofia.com\/index.php?rest_route=\/wp\/v2\/posts\/3907\/revisions\/3913"}],"wp:attachment":[{"href":"https:\/\/wiki.thomasandsofia.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3907"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wiki.thomasandsofia.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3907"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wiki.thomasandsofia.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3907"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}