• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1179
  • Last Modified:

Syntax to sp_addlanguage

I need the full syntax to sp_addlanguage for Swedish or just a syntaxexample.
0
tsp
Asked:
tsp
  • 2
1 Solution
 
Jim_SQLCommented:
Hi,

I can't find anything on sp_addlanguage (I use MS SQL Server 6.5) ... but that doesn't mean it doesn't exist. But if you do a query in books on line for "Adding a Language" they give step by step instructions.

(Hope this helped.)
Jim
0
 
sivabalanCommented:
Hi,
The syntax for sp_addlanguage will look something like this..
sp_addlanguage
language (sysname ),
alias(sysname) ,
months (varchar(372)),
shortmons(varchar(132)) ,
days(varchar(217)) ,
datefmt(char(3)) ,
datefirst(tinyint)

where
language = Official language name (for example, français).
alias= Alternate language name (for example, french).
months= Comma-separated list of full-length month names, in order from January through December, with each name containing as many as 20 characters.
shortmons= Comma-separated list of short-month names, in order from January through December, with each name containing as many as 9 characters.
days= Comma-separated list of day names, in order from Monday through Sunday, with each name containing as many as 30 characters.
datefmt=       Date order (for example, DMY).
datefirst=       First day of the week: 1 for Monday, 2 for Tuesday, and so on through 7 for Sunday.

Hope this helps...



0
 
tspAuthor Commented:
Thanks alot for an excellent solution.
0
 
tspAuthor Commented:
Thanks alot for an excellent solution.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now