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

@@TEXTSIZE(Transact-SQL)

SQL Server 2005

SET 문의 TEXTSIZE 옵션의 현재 값을 반환합니다. 이 옵션은 SELECT 문이 반환하는 varchar(max), nvarchar(max), varbinary(max), text 또는 image 데이터의 최대 길이를 바이트 단위로 지정합니다.

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

복사 

@@TEXTSIZE

기본 크기는 4096바이트입니다. @@TEXTSIZE가 반환하는 최대 크기는 2^31-1바이트입니다.

integer

다음 예에서는 SELECT를 사용하여 SET TEXTSIZE 문을 통해 값이 변경되기 이전과 이후의 @@TEXTSIZE 값을 표시합니다.

복사 
SELECT @@TEXTSIZE AS 'Text Size'
SET TEXTSIZE 2048
SELECT @@TEXTSIZE AS 'Text Size'

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

복사 
Text Size  
-----------
4096       

Text Size  
-----------
2048
이 정보가 도움이 되었습니까?
(1500자 남음)

커뮤니티 추가 항목

추가
Microsoft는 MSDN 웹 사이트에 대한 귀하의 의견을 이해하기 위해 온라인 설문 조사를 진행하고 있습니다. 참여하도록 선택하시면 MSDN 웹 사이트에서 나가실 때 온라인 설문 조사가 표시됩니다.

참여하시겠습니까?
개인정보취급방침 및 청소년보호정책
© 2013 Microsoft
|
사이트 의견
© 2013 Microsoft. All rights reserved.