여러분이 사용하고 계신 브라우저는 HTML5를 지원하지 않기 때문에 몇몇 요소가 제대로 보이도록 JScript를 사용하고 있습니다. 하지만 여러분의 브라우저 설정에서 스크립트 기능이 꺼져있으므로, 현재 페이지를 제대로 확인하시려면 스크립트 기능을 켜주셔야 합니다. SQL SERVER - 참조 - 함수 - REPLICATE()
SQL SERVER – 참조 – 함수 – REPLICATE()
1년전 작성
11개월전 수정

REPLICATE()

REPLICATE() 함수는 지정된 횟수만큼 문자열을 반복한다.

SQL Server (starting with 2008), Azure SQL Database, Azure SQL Data Warehouse, Parallel Data Warehouse에서 작동한다.

형식
REPLICATE(string, integer)
매개변수
string
:
반복할 문자열
integer
:
문자열을 반복할 횟수
예제
문자열을 반복해보자.
SELECT REPLICATE('SQL Tutorial', 5);
기본 예시
SQL TutorialSQL TutorialSQL TutorialSQL TutorialSQL Tutorial
CustomerName의 텍스트를 두 번 반복해보자.
SELECT REPLICATE(CustomerName, 2)
FROM Customers;
기본 예시
Alfreds FutterkisteAlfreds Futterkiste
Ana Trujillo Emparedados y heladosAna Trujillo Emparedados y helados
Antonio Moreno TaqueríaAntonio Moreno Taquería
Around the HornAround the Horn
Berglunds snabbköpBerglunds snabbköp
Blauer See DelikatessenBlauer See Delikatessen
Blondel père et filsBlondel père et fils
Bólido Comidas preparadasBólido Comidas preparadas
Bon appBon app
Bottom-Dollar MarketseBottom-Dollar Marketse
Bs BeveragesBs Beverages
Cactus Comidas para llevarCactus Comidas para llevar
Centro comercial MoctezumaCentro comercial Moctezuma
Chop-suey ChineseChop-suey Chinese
Comércio MineiroComércio Mineiro
Consolidated HoldingsConsolidated Holdings
Drachenblut DelikatessendDrachenblut Delikatessend
Du monde entierDu monde entier
Eastern ConnectionEastern Connection
Ernst HandelErnst Handel
Familia ArquibaldoFamilia Arquibaldo
FISSA Fabrica Inter. Salchichas S.A.FISSA Fabrica Inter. Salchichas S.A.
Folies gourmandesFolies gourmandes
Folk och fä HBFolk och fä HB
FrankenversandFrankenversand
France restaurationFrance restauration
Franchi S.p.A.Franchi S.p.A.
Furia Bacalhau e Frutos do MarFuria Bacalhau e Frutos do Mar
Galería del gastrónomoGalería del gastrónomo
Godos Cocina TípicaGodos Cocina Típica
Gourmet LanchonetesGourmet Lanchonetes
Great Lakes Food MarketGreat Lakes Food Market
GROSELLA-RestauranteGROSELLA-Restaurante
Hanari CarnesHanari Carnes
HILARIÓN-AbastosHILARIÓN-Abastos
Hungry Coyote Import StoreHungry Coyote Import Store
Hungry Owl All-Night GrocersHungry Owl All-Night Grocers
Island TradingIsland Trading
Königlich EssenKöniglich Essen
La corne dabondanceLa corne dabondance
La maison dAsieLa maison dAsie
Laughing Bacchus Wine CellarsLaughing Bacchus Wine Cellars
Lazy K Kountry StoreLazy K Kountry Store
Lehmanns MarktstandLehmanns Marktstand
Lets Stop N ShopLets Stop N Shop
LILA-SupermercadoLILA-Supermercado
LINO-DelicatesesLINO-Delicateses
Lonesome Pine RestaurantLonesome Pine Restaurant
Magazzini Alimentari RiunitiMagazzini Alimentari Riuniti
Maison DeweyMaison Dewey
Mère PaillardeMère Paillarde
Morgenstern GesundkostMorgenstern Gesundkost
North/SouthNorth/South
Océano Atlántico Ltda.Océano Atlántico Ltda.
Old World DelicatessenOld World Delicatessen
Ottilies KäseladenOttilies Käseladen
Paris spécialitésParis spécialités
Pericles Comidas clásicasPericles Comidas clásicas
Piccolo und mehrPiccolo und mehr
Princesa Isabel VinhossPrincesa Isabel Vinhoss
Que DelíciaQue Delícia
Queen CozinhaQueen Cozinha
QUICK-StopQUICK-Stop
Rancho grandeRancho grande
Rattlesnake Canyon GroceryRattlesnake Canyon Grocery
Reggiani CaseificiReggiani Caseifici
Ricardo AdocicadosRicardo Adocicados
Richter SupermarktRichter Supermarkt
Romero y tomilloRomero y tomillo
Santé GourmetSanté Gourmet
Save-a-lot MarketsSave-a-lot Markets
Seven Seas ImportsSeven Seas Imports
Simons bistroSimons bistro
Spécialités du mondeSpécialités du monde
Split Rail Beer & AleSplit Rail Beer & Ale
Suprêmes délicesSuprêmes délices
The Big CheeseThe Big Cheese
The Cracker BoxThe Cracker Box
Toms SpezialitätenToms Spezialitäten
Tortuga RestauranteTortuga Restaurante
Tradição HipermercadosTradição Hipermercados
Trails Head Gourmet ProvisionersTrails Head Gourmet Provisioners
VaffeljernetVaffeljernet
Victuailles en stockVictuailles en stock
Vins et alcools ChevalierVins et alcools Chevalier
Die Wandernde KuhDie Wandernde Kuh
Wartian HerkkuWartian Herkku
Wellington ImportadoraWellington Importadora
White Clover MarketsWhite Clover Markets
Wilman KalaWilman Kala
WolskiWolski
참고

Mingg`s Diary
밍구
공부 목적 블로그