{"id":1832,"date":"2021-11-15T23:28:27","date_gmt":"2021-11-15T20:28:27","guid":{"rendered":"https:\/\/burakcaliskan.org\/blog\/?p=1832"},"modified":"2021-11-15T23:30:03","modified_gmt":"2021-11-15T20:30:03","slug":"mssql-komutlari","status":"publish","type":"post","link":"https:\/\/burakcaliskan.org\/blog\/mssql-komutlari\/","title":{"rendered":"MSSQL Komutlar\u0131"},"content":{"rendered":"\n

MSSQL Database Versiyonu \u00d6\u011frenme
# DBCC CHECKPRIMARYFILE(‘C:\\db\\Database_Data.mdf’,2)<\/p>\n\n\n\n

Database name databaseadi
Database version 852
Collation 53274<\/p>\n\n\n\n

SQL Server Version<\/strong><\/td>Internal Database Version<\/strong><\/td><\/tr>
SQL Server 2016<\/strong><\/td>852<\/td><\/tr>
SQL Server 2014<\/strong><\/td>782<\/td><\/tr>
SQL Server 2012<\/strong><\/td>706<\/td><\/tr>
SQL Server 2008 R2<\/strong><\/td>660\/661<\/td><\/tr>
SQL Server 2008<\/strong><\/td>655<\/td><\/tr>
SQL Server 2005<\/strong><\/td>611\/612<\/td><\/tr>
SQL Server 2000<\/strong><\/td>539<\/td><\/tr>
SQL Server 7<\/strong><\/td>515<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

SQL Kodu ile Attach Etme
# <\/p>\n\n\n\n

USE [master]
GO
CREATE DATABASE [DATADB] ON
( FILENAME = N’C:\\db\\DATA.mdf’ ),
( FILENAME = N’C:\\db\\DATA_log.ldf’ )
FOR ATTACH
GO<\/p>\n\n\n\n

veya
# <\/p>\n\n\n\n

USE [master]
GO
CREATE DATABASE [DB_Data] ON
( FILENAME = N’C:\\db\\DB_Data.mdf’ )
FOR ATTACH
GO<\/p>\n","protected":false},"excerpt":{"rendered":"

MSSQL Database Versiyonu \u00d6\u011frenme# DBCC CHECKPRIMARYFILE(‘C:\\db\\Database_Data.mdf’,2) Database name databaseadiDatabase version 852Collation 53274 SQL Server Version Internal Database Version SQL Server 2016 852 SQL Server 2014 782 SQL Server 2012 706 SQL Server 2008 R2 660\/661 SQL Server 2008 655 SQL Server 2005 611\/612 SQL Server 2000 539 SQL Server 7 515 SQL Kodu ile Attach […]<\/p>\n","protected":false},"author":2,"featured_media":1833,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/burakcaliskan.org\/blog\/wp-json\/wp\/v2\/posts\/1832"}],"collection":[{"href":"https:\/\/burakcaliskan.org\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/burakcaliskan.org\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/burakcaliskan.org\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/burakcaliskan.org\/blog\/wp-json\/wp\/v2\/comments?post=1832"}],"version-history":[{"count":2,"href":"https:\/\/burakcaliskan.org\/blog\/wp-json\/wp\/v2\/posts\/1832\/revisions"}],"predecessor-version":[{"id":1835,"href":"https:\/\/burakcaliskan.org\/blog\/wp-json\/wp\/v2\/posts\/1832\/revisions\/1835"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/burakcaliskan.org\/blog\/wp-json\/wp\/v2\/media\/1833"}],"wp:attachment":[{"href":"https:\/\/burakcaliskan.org\/blog\/wp-json\/wp\/v2\/media?parent=1832"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/burakcaliskan.org\/blog\/wp-json\/wp\/v2\/categories?post=1832"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/burakcaliskan.org\/blog\/wp-json\/wp\/v2\/tags?post=1832"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}