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)
확장 최소화
이 항목은 아직 평가되지 않았습니다.- 이 항목 평가

FILE_NAME(Transact-SQL)

SQL Server 2005

지정한 파일 ID에 해당하는 논리적 파일 이름을 반환합니다.

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

복사 

FILE_NAME ( file_id )
file_id

파일 이름을 반환할 해당 파일 ID입니다. file_id는 int입니다.

nvarchar(128)

file_ID는 sys.master_files 또는 sys.database_files 카탈로그 뷰의 file_id 열과 일치합니다.

다음 예에서는 AdventureWorks 데이터베이스에서 file_ID 1 및 file_ID 2에 대한 파일 이름을 반환합니다.

복사 
USE AdventureWorks;
GO
SELECT FILE_NAME(1) AS 'File Name 1', FILE_NAME(2) AS 'File Name 2';
GO

결과 집합은 다음과 같습니다.

복사 
File Name 1           File Name 2
----------------      ------------------------ 
AdventureWorks_Data   AdventureWorks_Log 
(1 row(s) affected)
이 정보가 도움이 되었습니까?
(1500자 남음)

커뮤니티 추가 항목

추가
© 2013 Microsoft
|
사이트 의견
© 2013 Microsoft. All rights reserved.