Use the localization format helper

Quickstart: Localization and formatting

GitHub Copilot helps developers build globally aware applications by addressing localization

and formatting needs directly within SQL and ORM-based workflows. Whether you’re working

with multilingual content, region-specific date and number formats, or collation settings for

search and sorting, GitHub Copilot provides intelligent, context-aware assistance to make your

database and code ready for international users.

Make sure you’re connected to a database and have an active editor window open with the

MSSQL extension. When you connect, the

chat participant understands the context of

your database environment and can give accurate, context-aware suggestions. If you don’t

connect to a database, the chat participant doesn’t have the schema or data context to provide

meaningful responses.

The following examples use the

sample database, which you can

download from the

Microsoft SQL Server Samples and Community Projects

home page.

For best results, adjust table and schema names to match your own environment.

Make sure the chat includes the

prefix. For example, type

followed by your

question or prompt. This prefix ensures that the chat participant understands you’re asking for

SQL-related assistance.

GitHub Copilot can assist with localization and formatting tasks in SQL and ORM-based

workflows. It can help you design schemas that support multilingual content, format queries

for regional standards, and generate code that adheres to localization best practices.

Here are common use cases and examples of what you can ask via the chat participant:

Use GitHub Copilot to help with formatting queries for regional standards, choosing the right

collation settings, and designing schema elements to support multilingual content, like storing

product descriptions in multiple languages.

@mssql
AdventureWorksLT2022
@mssql
@mssql