Solved

Syntax to sp_addlanguage

Posted on 1998-02-20
4
1,138 Views
Last Modified: 2008-02-01
I need the full syntax to sp_addlanguage for Swedish or just a syntaxexample.
0
Comment
Question by:tsp
  • 2
4 Comments
 
LVL 2

Expert Comment

by:Jim_SQL
ID: 1090333
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
 
LVL 1

Accepted Solution

by:
sivabalan earned 20 total points
ID: 1090334
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
 

Author Comment

by:tsp
ID: 1090335
Thanks alot for an excellent solution.
0
 

Author Comment

by:tsp
ID: 1090336
Thanks alot for an excellent solution.
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now