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 |
참고
W3C School - SQL REPLICATE() Function
W3C School - SQL Tutorial
공부 목적 블로그