Solved

Syntax to sp_addlanguage

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

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

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…
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…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

757 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

19 Experts available now in Live!

Get 1:1 Help Now