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

_ (와일드카드 - 문자 하나와 일치)(Transact-SQL)

SQL Server 2005

패턴 일치 작업(예: LIKE 및 PATINDEX)과 같은 문자열 비교 작업에서 어느 한 문자에 해당합니다. 자세한 내용은 검색 조건의 패턴 일치를 참조하십시오.

다음 예에서는 _ 연산자를 사용하여 Contact 테이블에서 an으로 끝나는 3개 문자로 된 이름을 가진 모든 사람을 찾습니다.

복사 
USE AdventureWorks;
GO
SELECT FirstName, LastName
FROM Person.Contact
WHERE FirstName LIKE '_an'
ORDER BY FirstName;
이 정보가 도움이 되었습니까?
(1500자 남음)

커뮤니티 추가 항목

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

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