557
yesterday 1,365
visitor 23,761,318

MS-SQL

3

현재 사용중인 MSSQL의 버전 확인하는 방법

조회 수 19893 추천 수 0 2011.10.20 14:14:18
제리 *.243.13.12

*** 검색어: MSSQL, MS-SQL, 버전

 

-- 서비스팩 확인

select SERVERPROPERTY('productlevel')

 

-- 사용중인 SQL 빌드넘버와 서비스팩 확인

SELECT 'SQL Server '
+ CAST(SERVERPROPERTY('productversion') AS VARCHAR) + ' - '
+ CAST(SERVERPROPERTY('productlevel') AS VARCHAR) + ' ('
+ CAST(SERVERPROPERTY('edition') AS VARCHAR) + ')'

 

-- 사용중인 SQL종류와 빌드넘버

select @@version

 

-- 아래의 두개는 똑같은 결과를 보여준다.

EXEC sp_server_info

 

EXEC master..xp_msver

 

위의 쿼리문중 마음에 드는거 실행하면 된다.

(모두 결과가 같은 것은 아니다)

 

 

 

출처 : http://blog.naver.com/nabiro/130040337993

이 게시물을...

 

 

'헬로마켓'과 함께하는 스마트한 중고 아이템 거래

https://www.hellomarket.com
엮인글 :
http://www.underroom.com/index.php?document_srl=324&act=trackback&key=f33
목록
1
profile

Lisa

March 02, 2023
*.153.246.204

Pandora Charms Sale Clearance Air Jordan 11 Low Nike Canada Cheap Nikes Nike Air Max NFL Shop Louboutin Pandora Jewelry Jordans Wholesale Nike Canada Adidas Wholesale China Nike SB Dunk Jordans 2021 Nike Air Force 1 Nike Air Max 270 Jordan 31 Nike Wholesale Distributors Jordan 11 Retro Baby Jordans Adidas Store Huarache Nike Free Jordan 12 What The Jordan 5 Air Max 270 Nike Huaraches Jordans 12 Nike Air Zoom Nike Shoes Outlet Store Online Shopping Nike Flyknit Racer Pandora Jewelry Jordan Shoes Jordan AJ 1 Nike Sneakers Air Jordan 32 Pandora Jewelry Official Site Nike Store Nike Nike Outlet Store Online Shopping Jordan 11 Jordans 26 Nike AF1 Lebron James Sneakers Retro 12 Air Max Nike Zoom Yeezy Air Force 1 Air Jordan 15 Nike Factory Store Nike Women's Shoes Wholesale Air Jordans Nikes Jordan Shoes Pandora Jewelry Official Site Jordan 27 Pandora Nike Hyperdunk Nike Shoes Cheap Jordans Wholesale Nike Off White NHL Jerseys Hockey Jerseys Men Nike Shoes Pandora Outlet Jordan 6s Jordan 13 Pandora Jewelry Pandora Bracelet Charms Nike Shox Women Jordan Retros Nikes Nike Shoes Nike Air Max 720 Jordan 23 MLB Shop Air Max Wholesale Nike Shoes Jordans 33 Pandora Rings Jordan 33 shoes Cheap Adidas Shoes Pandora Charms Air Force 1 Women Pandora Jewelry Official Site Air Force Ones Nike Cheap Nike Shoes From China Pandora Charms Sale Clearance Cheap Jerseys From China Cheap Adidas Shoes Nike Wholesale Air Jordan 13 Pandora Jewelry Charms Wholesale Adidas Shoes Nike Clearance Store Christian Louboutin Shoes Cheap Jordans From China Cheap Jordan Shoes Supplier Cheap Jordan Pandora Bracelets Clearance Nike Jordans Pandora Jewelry Pandora Charms Pandora Rings Wholesale Nike Clothing Nike Outlet Air Max Shoes Jordan 21 Adidas NMD R1 Jordan 1 Air Jordan 18 Kids Jordans Nike Outlet Air Max 97 Nike Store Jordan 4 Retro Jordan 19 Cheap Nike Shoes From China Nike Outlet Store Air Max Jordans 34 Nike Blazer Low Nike Blazer Air Jordan Nike Outlet Christian Louboutin Jordan 17 Jordan 14 Nike Jordan 1 Jordan 28 Jordan 30 Nike Shoes Cyber Monday Air Max 95 Yeezy Boost 350 V2 Nike Shoes Nike Outlet Jordan 25 Jordan 24 Uptempo Nike Running Shoes For Women Jordan 29 Pandora Charms New Nikes Shoes Nike Huarache Jordan 22 Air Jordan 33 Jordan 20 Jordan 35 Best Nike Running Shoes Jordan 11s Jordan 2s Pandora Jewelry Outlet NBA Store Nike Shoes Nike Ice Jerseys Pandora Jewelry Nike Free Dior Jordans Jordan 16
문서 첨부 제한 : 0Byte/ 2.00MB
파일 제한 크기 : 2.00MB (허용 확장자 : *.*)
List of Articles
번호 제목 글쓴이 날짜 조회 수
목록
쓰기
 
Copyright . All rights reserved. @XE

Program Note 로그인 :)