Solved

Syntax to sp_addlanguage

Posted on 1998-02-20
4
1,141 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

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
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.

813 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

11 Experts available now in Live!

Get 1:1 Help Now