SQL Server
한국(한국어) 로그인
홈 2012 2008 R2 2008 이전 버전 라이브러리 포럼
TechNet 라이브러리
SQL Server
SQL Server 2005
제품 설명서
SQL Server 2005 설명서
SQL Server 2005 온라인 설명서
SQL Server 언어 참조
Transact-SQL 참조
Transact-SQL 구문 규칙(Transact-SQL)
Transact-SQL의 새로운 기능 및 향상된 기능(Transact-SQL)
+(더하기)(Transact-SQL)
+(단항 더하기)(Transact-SQL)
+(문자열 연결)(Transact-SQL)
-(음수)(Transact-SQL)
-(빼기)(Transact-SQL)
*(곱하기)(Transact-SQL)
/(나누기)(Transact-SQL)
%(모듈로)(Transact-SQL)
%(와일드카드 - 일치하는 문자)(Transact-SQL)
&(비트 AND)(Transact-SQL)
|(비트 OR)(Transact-SQL)
^(배타적 비트 OR)(Transact-SQL)
~(비트 NOT)(Transact-SQL)
=(같음)(Transact-SQL)
>(보다 큼)(Transact-SQL)
<(보다 작음)(Transact-SQL)
>=(크거나 같음)(Transact-SQL)
<=(작거나 같음)(Transact-SQL)
<>(같지 않음)(Transact-SQL)
!<(보다 작지 않음)(Transact-SQL)
!= (같지 않음)(Transact-SQL)
!>(보다 크지 않음)(Transact-SQL)
-- (주석)(Transact-SQL)
/*...*/(주석)(Transact-SQL)
[ ](와일드카드 - 일치하는 문자)(Transact-SQL)
[^](와일드카드 - 일치하지 않는 문자)(Transact-SQL)
_ (와일드카드 - 문자 하나와 일치)(Transact-SQL)
$PARTITION(Transact-SQL)
@@CONNECTIONS(Transact-SQL)
@@CPU_BUSY(Transact-SQL)
@@CURSOR_ROWS(Transact-SQL)
@@DATEFIRST(Transact-SQL)
@@DBTS(Transact-SQL)
@@ERROR(Transact-SQL)
@@FETCH_STATUS(Transact-SQL)
@@IDENTITY(Transact-SQL)
@@IDLE(Transact-SQL)
@@IO_BUSY(Transact-SQL)
@@LANGID(Transact-SQL)
@@LANGUAGE(Transact-SQL)
@@LOCK_TIMEOUT(Transact-SQL)
@@MAX_CONNECTIONS(Transact-SQL)
@@MAX_PRECISION(Transact-SQL)
@@NESTLEVEL(Transact-SQL)
@@OPTIONS(Transact-SQL)
@@PACK_RECEIVED(Transact-SQL)
@@PACK_SENT(Transact-SQL)
@@PACKET_ERRORS(Transact-SQL)
@@PROCID(Transact-SQL)
@@REMSERVER(Transact-SQL)
@@ROWCOUNT(Transact-SQL)
@@SERVERNAME(Transact-SQL)
@@SERVICENAME(Transact-SQL)
@@SPID(Transact-SQL)
@@TEXTSIZE(Transact-SQL)
@@TIMETICKS(Transact-SQL)
@@TOTAL_ERRORS(Transact-SQL)
@@TOTAL_READ(Transact-SQL)
@@TOTAL_WRITE(Transact-SQL)
@@TRANCOUNT(Transact-SQL)
@@VERSION(Transact-SQL)
ABS(Transact-SQL)
ACOS(Transact-SQL)
ADD SIGNATURE(Transact-SQL)
ALL(Transact-SQL)
ALTER APPLICATION ROLE(Transact-SQL)
ALTER ASSEMBLY(Transact-SQL)
ALTER ASYMMETRIC KEY(Transact-SQL)
ALTER AUTHORIZATION(Transact-SQL)
ALTER CERTIFICATE(Transact-SQL)
ALTER CREDENTIAL(Transact-SQL)
ALTER DATABASE(Transact-SQL)
ALTER ENDPOINT(Transact-SQL)
ALTER FULLTEXT CATALOG(Transact-SQL)
ALTER FULLTEXT INDEX(Transact-SQL)
ALTER FUNCTION(Transact-SQL)
ALTER INDEX(Transact-SQL)
ALTER LOGIN(Transact-SQL)
ALTER MASTER KEY(Transact-SQL)
ALTER MESSAGE TYPE(Transact-SQL)
ALTER PARTITION FUNCTION(Transact-SQL)
ALTER PARTITION SCHEME(Transact-SQL)
ALTER PROCEDURE(Transact-SQL)
ALTER QUEUE(Transact-SQL)
ALTER REMOTE SERVICE BINDING(Transact-SQL)
ALTER ROLE(Transact-SQL)
ALTER ROUTE(Transact-SQL)
ALTER SCHEMA(Transact-SQL)
ALTER SERVICE(Transact-SQL)
ALTER SERVICE MASTER KEY(Transact-SQL)
ALTER SYMMETRIC KEY(Transact-SQL)
ALTER TABLE(Transact-SQL)
ALTER TRIGGER(Transact-SQL)
ALTER USER(Transact-SQL)
ALTER VIEW(Transact-SQL)
ALTER XML SCHEMA COLLECTION(Transact-SQL)
AND(Transact-SQL)
ANY(Transact-SQL)
APPLOCK_MODE(Transact-SQL)
APPLOCK_TEST(Transact-SQL)
APP_NAME(Transact-SQL)
ASCII(Transact-SQL)
ASIN(Transact-SQL)
ASSEMBLYPROPERTY(Transact-SQL)
AsymKey_ID(Transact-SQL)
ATAN(Transact-SQL)
ATN2(Transact-SQL)
AVG(Transact-SQL)
BACKUP(Transact-SQL)
BACKUP CERTIFICATE(Transact-SQL)
BACKUP MASTER KEY(Transact-SQL)
BACKUP SERVICE MASTER KEY(Transact-SQL)
BEGIN...END(Transact-SQL)
BEGIN CONVERSATION TIMER(Transact-SQL)
BEGIN DIALOG CONVERSATION(Transact-SQL)
BEGIN DISTRIBUTED TRANSACTION(Transact-SQL)
BEGIN TRANSACTION(Transact-SQL)
BETWEEN(Transact-SQL)
binary 및 varbinary(Transact-SQL)
BINARY_CHECKSUM
bit(Transact-SQL)
BREAK(Transact-SQL)
BULK INSERT(Transact-SQL)
CASE(Transact-SQL)
CAST 및 CONVERT(Transact-SQL)
CATCH (TRY...CATCH)(Transact-SQL)
CEILING(Transact-SQL)
CertProperty(Transact-SQL)
Cert_ID(Transact-SQL)
char 및 varchar(Transact-SQL)
CHAR(Transact-SQL)
CHARINDEX(Transact-SQL)
CHECKPOINT(Transact-SQL)
CHECKSUM(Transact-SQL)
CHECKSUM_AGG(Transact-SQL)
CLOSE(Transact-SQL)
CLOSE MASTER KEY(Transact-SQL)
CLOSE SYMMETRIC KEY(Transact-SQL)
COALESCE(Transact-SQL)
COLLATE(Transact-SQL)
COLLATIONPROPERTY(Transact-SQL)
COL_LENGTH(Transact-SQL)
COL_NAME(Transact-SQL)
COLUMNPROPERTY(Transact-SQL)
COLUMNS_UPDATED(Transact-SQL)
COMMIT TRANSACTION(Transact-SQL)
COMMIT WORK(Transact-SQL)
COMPUTE(Transact-SQL)
상수(Transact-SQL)
CONTAINS(Transact-SQL)
CONTAINSTABLE(Transact-SQL)
CONTEXT_INFO(Transact-SQL)
CONTINUE(Transact-SQL)
흐름 제어 언어(Transact-SQL)
CONVERT(Transact-SQL)
COS(Transact-SQL)
COT(Transact-SQL)
COUNT(Transact-SQL)
COUNT_BIG(Transact-SQL)
CREATE AGGREGATE(Transact-SQL)
CREATE APPLICATION ROLE(Transact-SQL)
CREATE ASSEMBLY(Transact-SQL)
CREATE ASYMMETRIC KEY(Transact-SQL)
CREATE CERTIFICATE(Transact-SQL)
CREATE CONTRACT(Transact-SQL)
CREATE CREDENTIAL(Transact-SQL)
CREATE DATABASE(Transact-SQL)
CREATE DEFAULT(Transact-SQL)
CREATE ENDPOINT(Transact-SQL)
CREATE EVENT NOTIFICATION(Transact-SQL)
CREATE FULLTEXT CATALOG(Transact-SQL)
CREATE FULLTEXT INDEX(Transact-SQL)
CREATE FUNCTION(Transact-SQL)
CREATE INDEX(Transact-SQL)
CREATE LOGIN(Transact-SQL)
CREATE MASTER KEY(Transact-SQL)
CREATE MESSAGE TYPE(Transact-SQL)
CREATE PARTITION FUNCTION(Transact-SQL)
CREATE PARTITION SCHEME(Transact-SQL)
CREATE PROCEDURE(Transact-SQL)
CREATE QUEUE(Transact-SQL)
CREATE REMOTE SERVICE BINDING(Transact-SQL)
CREATE ROLE(Transact-SQL)
CREATE ROUTE(Transact-SQL)
CREATE RULE(Transact-SQL)
CREATE SCHEMA(Transact-SQL)
CREATE SERVICE(Transact-SQL)
CREATE STATISTICS(Transact-SQL)
CREATE SYMMETRIC KEY(Transact-SQL)
CREATE SYNONYM(Transact-SQL)
CREATE TABLE(Transact-SQL)
CREATE TRIGGER(Transact-SQL)
CREATE TYPE(Transact-SQL)
CREATE USER(Transact-SQL)
CREATE VIEW(Transact-SQL)
CREATE XML SCHEMA COLLECTION(Transact-SQL)
CURRENT_REQUEST_ID(Transact-SQL)
CURRENT_TIMESTAMP(Transact-SQL)
CURRENT_USER(Transact-SQL)
SET(Transact-SQL)
CURSOR_STATUS(Transact-SQL)
커서(Transact-SQL)
DATABASEPROPERTY(Transact-SQL)
DATABASEPROPERTYEX(Transact-SQL)
DATABASE_PRINCIPAL_ID(Transact-SQL)
데이터 형식(Transact-SQL)
DATALENGTH(Transact-SQL)
DATEADD(Transact-SQL)
DATEDIFF(Transact-SQL)
DATENAME(Transact-SQL)
DATEPART(Transact-SQL)
날짜 및 시간(Transact-SQL)
DAY(Transact-SQL)
DB_ID(Transact-SQL)
DB_NAME(Transact-SQL)
DBCC(Transact-SQL)
DEALLOCATE(Transact-SQL)
decimal 및 numeric(Transact-SQL)
DECLARE @local_variable(Transact-SQL)
DECLARE CURSOR(Transact-SQL)
DecryptByAsymKey(Transact-SQL)
DecryptByCert(Transact-SQL)
DecryptByKey(Transact-SQL)
DecryptByKeyAutoAsymKey(Transact-SQL)
DecryptByKeyAutoCert(Transact-SQL)
DecryptByPassPhrase(Transact-SQL)
DEGREES(Transact-SQL)
DELETE(Transact-SQL)
DENSE_RANK(Transact-SQL)
DENY(Transact-SQL)
DIFFERENCE(Transact-SQL)
DISABLE TRIGGER(Transact-SQL)
DROP AGGREGATE(Transact-SQL)
DROP APPLICATION ROLE(Transact-SQL)
DROP ASSEMBLY(Transact-SQL)
DROP ASYMMETRIC KEY(Transact-SQL)
DROP CERTIFICATE(Transact-SQL)
DROP CONTRACT(Transact-SQL)
DROP CREDENTIAL(Transact-SQL)
DROP DATABASE(Transact-SQL)
DROP DEFAULT(Transact-SQL)
DROP ENDPOINT(Transact-SQL)
DROP EVENT NOTIFICATION(Transact-SQL)
DROP FULLTEXT CATALOG(Transact-SQL)
DROP FULLTEXT INDEX(Transact-SQL)
DROP FUNCTION(Transact-SQL)
DROP INDEX(Transact-SQL)
DROP LOGIN(Transact-SQL)
DROP MASTER KEY(Transact-SQL)
DROP MESSAGE TYPE(Transact-SQL)
DROP PARTITION FUNCTION(Transact-SQL)
DROP PARTITION SCHEME(Transact-SQL)
DROP PROCEDURE(Transact-SQL)
DROP QUEUE(Transact-SQL)
DROP REMOTE SERVICE BINDING(Transact-SQL)
DROP ROLE(Transact-SQL)
DROP ROUTE(Transact-SQL)
DROP RULE(Transact-SQL)
DROP SCHEMA(Transact-SQL)
DROP SERVICE(Transact-SQL)
DROP SIGNATURE(Transact-SQL)
DROP STATISTICS(Transact-SQL)
DROP SYMMETRIC KEY(Transact-SQL)
DROP SYNONYM(Transact-SQL)
DROP TABLE(Transact-SQL)
DROP TRIGGER(Transact-SQL)
DROP TYPE(Transact-SQL)
DROP USER(Transact-SQL)
DROP VIEW(Transact-SQL)
DROP XML SCHEMA COLLECTION(Transact-SQL)
DUMP(Transact-SQL)
ELSE(IF...ELSE)(Transact-SQL)
ENABLE TRIGGER(Transact-SQL)
EncryptByAsymKey(Transact-SQL)
EncryptByCert(Transact-SQL)
EncryptByKey(Transact-SQL)
EncryptByPassPhrase(Transact-SQL)
END(BEGIN...END)(Transact-SQL)
END CONVERSATION(Transact-SQL)
ERROR_LINE(Transact-SQL)
ERROR_MESSAGE(Transact-SQL)
ERROR_NUMBER(Transact-SQL)
ERROR_PROCEDURE(Transact-SQL)
ERROR_SEVERITY(Transact-SQL)
ERROR_STATE(Transact-SQL)
EVENTDATA(Transact-SQL)
EXCEPT 및 INTERSECT(Transact-SQL)
EXECUTE AS(Transact-SQL)
EXECUTE AS 절(Transact-SQL)
EXECUTE(Transact-SQL)
EXISTS(Transact-SQL)
EXP(Transact-SQL)
식(Transact-SQL)
FETCH(Transact-SQL)
FILE_ID(Transact-SQL)
FILE_IDEX(Transact-SQL)
FILE_NAME(Transact-SQL)
FILEGROUP_ID(Transact-SQL)
FILEGROUP_NAME(Transact-SQL)
FILEGROUPPROPERTY(Transact-SQL)
FILEPROPERTY(Transact-SQL)
float 및 real(Transact-SQL)
FLOOR(Transact-SQL)
fn_get_sql(Transact-SQL)
fn_helpcollations(Transact-SQL)
fn_listextendedproperty(Transact-SQL)
fn_my_permissions(Transact-SQL)
fn_servershareddrives(Transact-SQL)
fn_trace_geteventinfo(Transact-SQL)
fn_trace_getfilterinfo(Transact-SQL)
fn_trace_getinfo(Transact-SQL)
fn_trace_gettable(Transact-SQL)
fn_virtualfilestats(Transact-SQL)
fn_virtualservernodes(Transact-SQL)
FOR 절(Transact-SQL)
FORMATMESSAGE(Transact-SQL)
FREETEXT(Transact-SQL)
FREETEXTTABLE(Transact-SQL)
FROM(Transact-SQL)
FULLTEXTCATALOGPROPERTY(Transact-SQL)
FULLTEXTSERVICEPROPERT(Transact-SQL)
함수(Transact-SQL)
GET CONVERSATION GROUP(Transact-SQL)
GET_TRANSMISSION_STATUS(Transact-SQL)
GETANSINULL(Transact-SQL)
GETDATE(Transact-SQL)
GETUTCDATE(Transact-SQL)
GO(Transact-SQL)
GOTO(Transact-SQL)
GRANT(Transact-SQL)
GROUP BY(Transact-SQL)
GROUPING(Transact-SQL)
HAS_DBACCESS(Transact-SQL)
Has_Perms_By_Name(Transact-SQL)
HashBytes(Transact-SQL)
HAVING(Transact-SQL)
힌트(Transact-SQL)
HOST_ID(Transact-SQL)
HOST_NAME(Transact-SQL)
IDENT_CURRENT(Transact-SQL)
IDENT_INCR(Transact-SQL)
IDENT_SEED(Transact-SQL)
IDENTITY(함수)(Transact-SQL)
IDENTITY(속성)(Transact-SQL)
IF...ELSE(Transact-SQL)
image(Transact-SQL)
IN(Transact-SQL)
INDEXKEY_PROPERTY(Transact-SQL)
NDEXPROPERTY(Transact-SQL)
INDEX_COL(Transact-SQL)
INSERT(Transact-SQL)
int, bigint, smallint 및 tinyint(Transact-SQL)
INTO 절(Transact-SQL)
IS_MEMBER(Transact-SQL)
IS_SRVROLEMEMBER(Transact-SQL)
ISDATE(Transact-SQL)
IS [NOT] NULL(Transact-SQL)
ISNULL(Transact-SQL)
ISNUMERIC(Transact-SQL)
Key_GUID(Transact-SQL)
Key_ID(Transact-SQL)
KILL(Transact-SQL)
KILL QUERY NOTIFICATION SUBSCRIPTION(Transact-SQL)
KILL STATS JOB(Transact-SQL)
LEFT(Transact-SQL)
LEN(Transact-SQL)
LIKE(Transact-SQL)
LOAD(Transact-SQL)
LOG(Transact-SQL)
LOG10(Transact-SQL)
LOGINPROPERTY(Transact-SQL)
LOWER(Transact-SQL)
LTRIM(Transact-SQL)
MAX(Transact-SQL)
MIN(Transact-SQL)
MIN_ACTIVE_ROWVERSION (Transact-SQL)
money 및 smallmoney(Transact-SQL)
MONTH(Transact-SQL)
MOVE CONVERSATION(Transact-SQL)
NCHAR(Transact-SQL)
nchar 및 nvarchar(Transact-SQL)
NEWID(Transact-SQL)
NEWSEQUENTIALID()
NOT(Transact-SQL)
ntext, text 및 image(Transact-SQL)
NTILE(Transact-SQL)
NULLIF(Transact-SQL)
numeric(Transact-SQL)
OBJECT_DEFINITION(Transact-SQL)
OBJECT_ID(Transact-SQL)
OBJECT_NAME(Transact-SQL)
OBJECT_SCHEMA_NAME(Transact-SQL)
OBJECTPROPERTY(Transact-SQL)
OBJECTPROPERTYEX(Transact-SQL)
OPEN(Transact-SQL)
OPEN MASTER KEY(Transact-SQL)
OPEN SYMMETRIC KEY(Transact-SQL)
OPENDATASOURCE(Transact-SQL)
OPENQUERY(Transact-SQL)
OPENROWSET(Transact-SQL)
OPENXML(Transact-SQL)
연산자(Transact-SQL)
OPTION 절(Transact-SQL)
OR(Transact-SQL)
ORDER BY 절(Transact-SQL)
ORIGINAL_LOGIN(Transact-SQL)
OUTPUT 절(Transact-SQL)
OVER 절(Transact-SQL)
PARSENAME(Transact-SQL)
PATINDEX(Transact-SQL)
PERMISSIONS(Transact-SQL)
PI(Transact-SQL)
POWER(Transact-SQL)
조건자(Transact-SQL)
PRINT(Transact-SQL)
PUBLISHINGSERVERNAME(Transact-SQL)
QUOTENAME(Transact-SQL)
RADIANS(Transact-SQL)
RAISERROR(Transact-SQL)
RAND(Transact-SQL)
RANK(Transact-SQL)
READTEXT(Transact-SQL)
real(Transact-SQL)
RECEIVE(Transact-SQL)
RECONFIGURE(Transact-SQL)
REPLACE(Transact-SQL)
REPLICATE(Transact-SQL)
예약된 키워드(Transact-SQL)
백업 복원, 복구 및 관리를 위한 RESTORE 문
RESTORE MASTER KEY(Transact-SQL)
RESTORE SERVICE MASTER KEY(Transact-SQL)
RETURN(Transact-SQL)
REVERSE(Transact-SQL)
REVERT(Transact-SQL)
REVOKE(Transact-SQL)
RIGHT(Transact-SQL)
ROLLBACK TRANSACTION(Transact-SQL)
ROLLBACK WORK(Transact-SQL)
ROUND(Transact-SQL)
ROWCOUNT_BIG(Transact-SQL)
ROW_NUMBER(Transact-SQL)
RTRIM(Transact-SQL)
SAVE TRANSACTION(Transact-SQL)
SCHEMA_ID(Transact-SQL)
SCHEMA_NAME(Transact-SQL)
SCOPE_IDENTITY(Transact-SQL)
검색 조건(Transact-SQL)
SELECT @local_variable(Transact-SQL)
SELECT(Transact-SQL)
SEND(Transact-SQL)
SERVERPROPERTY(Transact-SQL)
SESSION_USER(Transact-SQL)
SESSIONPROPERTY(Transact-SQL)
SET @local_variable(Transact-SQL)
SET(Transact-SQL)
SETUSER(Transact-SQL)
SHUTDOWN(Transact-SQL)
SIGN(Transact-SQL)
SignByAsymKey(Transact-SQL)
SignByCert(Transact-SQL)
SIN(Transact-SQL)
smalldatetime(Transact-SQL)
smallint(Transact-SQL)
smallmoney(Transact-SQL)
SOME | ANY(Transact-SQL)
SOUNDEX(Transact-SQL)
SPACE(Transact-SQL)
sql_variant(Transact-SQL)
SQL_VARIANT_PROPERTY(Transact-SQL)
SQRT(Transact-SQL)
SQUARE(Transact-SQL)
STATS_DATE(Transact-SQL)
STDEV(Transact-SQL)
STDEVP(Transact-SQL)
STR(Transact-SQL)
STUFF(Transact-SQL)
SUBSTRING(Transact-SQL)
SUM(Transact-SQL)
SUSER_ID(Transact-SQL)
SUSER_NAME(Transact-SQL)
SUSER_SID(Transact-SQL)
SUSER_SNAME(Transact-SQL)
시스템 저장 프로시저(Transact-SQL)
시스템 테이블(Transact-SQL)
시스템 뷰(Transact-SQL)
sys.fn_builtin_permissions(Transact-SQL)
sys.fn_translate_permissions(Transact-SQL)
sys.login_token(Transact-SQL)
sys.user_token(Transact-SQL)
SYSTEM_USER(Transact-SQL)
table(Transact-SQL)
TAN(Transact-SQL)
TERTIARY_WEIGHTS
text(Transact-SQL)
TEXTPTR(Transact-SQL)
TEXTVALID(Transact-SQL)
timestamp(Transact-SQL)
tinyint(Transact-SQL)
TOP(Transact-SQL)
추적 플래그(Transact-SQL)
트랜잭션(Transact-SQL)
TRY...CATCH(Transact-SQL)
TRIGGER_NESTLEVEL(Transact-SQL)
TRUNCATE TABLE(Transact-SQL)
TYPE_ID(Transact-SQL)
TYPE_NAME(Transact-SQL)
TYPEPROPERTY(Transact-SQL)
UNICODE(Transact-SQL)
UNION(Transact-SQL)
uniqueidentifier(Transact-SQL)
UPDATE(Transact-SQL)
UPDATE()(Transact-SQL)
UPDATE STATISTICS(Transact-SQL)
UPDATETEXT(Transact-SQL)
UPPER(Transact-SQL)
USE(Transact-SQL)
USER(Transact-SQL)
USER_ID(Transact-SQL)
USER_NAME(Transact-SQL)
VAR(Transact-SQL)
varbinary(Transact-SQL)
varchar(Transact-SQL)
VARP(Transact-SQL)
VerifySignedByCert(Transact-SQL)
VerifySignedByAsmKey(Transact-SQL)
WAITFOR(Transact-SQL)
WHERE(Transact-SQL)
WHILE(Transact-SQL)
WITH common_table_expression(Transact-SQL)
WITH XMLNAMESPACES(Transact-SQL)
WRITETEXT(Transact-SQL)
XACT_STATE(Transact-SQL)
xml(Transact-SQL)
xml_schema_namespace(Transact-SQL)
YEAR(Transact-SQL)
확장 최소화
이 항목은 아직 평가되지 않았습니다.- 이 항목 평가

STATS_DATE(Transact-SQL)

SQL Server 2005

업데이트: 2006년 7월 17일

지정한 인덱스에 대한 통계가 마지막으로 업데이트된 날짜를 반환합니다.

항목 링크 아이콘 Transact-SQL 구문 표기 규칙

복사 

STATS_DATE ( table_id , index_id )
table_id

사용된 테이블 ID입니다.

index_id

사용된 인덱스 ID입니다.

datetime

오류가 발생하거나 호출자가 개체를 볼 수 있는 권한을 갖고 있지 않으면 NULL을 반환합니다.

SQL Server 2005에서 사용자는 소유하고 있거나 사용 권한을 부여 받은 보안 개체의 메타데이터만 볼 수 있습니다. 즉, 사용자가 개체에 대한 사용 권한이 없으면 STATS_DATE와 같은 메타데이터 내보내기 기본 제공 함수가 NULL을 반환합니다. 자세한 내용은 메타데이터 표시 유형 구성 및 메타데이터 표시 유형 문제 해결을 참조하십시오.

시스템 함수는 SELECT 목록, WHERE 절 및 식이 사용되는 모든 위치에서 사용할 수 있습니다.

다음 예에서는 특정 개체에 대한 통계가 마지막으로 업데이트된 날짜를 반환합니다.

복사 
USE AdventureWorks;
GO
SELECT name AS index_name, 
    STATS_DATE(object_id, index_id) AS statistics_update_date
FROM sys.indexes 
WHERE object_id = OBJECT_ID('Person.Address');
GO

릴리스 내역

2006년 7월 17일
새로운 내용
  • 예외 섹션을 추가했습니다.
이 정보가 도움이 되었습니까?
(1500자 남음)

커뮤니티 추가 항목

추가
© 2013 Microsoft. All rights reserved.