Localization In SQL Server- Is There Such A Thing?

Apr 30, 2007

Hello all,
I'm working on an ASP.NET with a SQL server for database. Some of the tables, for example, contain information such as different types of Fabrics (silk, cotton, etc..) . I'd like to have this table localizable (English and French for instance). Is this possible ? Is there an equivalent of resource files in SQL server ?
Or do I have to do this manually ? (have 2 separate fields in the table for those 2 locales)

View 1 Replies


ADVERTISEMENT

Localization In SQL Server 2000

Jun 19, 2007

Hi.
I have distributed databases in different language versions, I am creating a stored procedure, and this problably in future is going to be migrated to other SQL Server database. the query that I have inside the stored procedure is this:
Insert Into Prueba Values(14,'31/07/1999') -------> format date of this query is in Hispanic version (this works fine)
But, If this query is migrated to other SQL Server and it's version would be in English, that query wouldn't work, the principal reason is the format date.
Solution that I have on mind is creating a stored procedure that receives three parameters the month,day and year. I want to identify the localization of that SQL Server database and use "IF" conditions and inside of these concatenate month,day and year obviously depending of the date format identified through "IF" conditions.
If somebody has an idea to solve this or somebody knows how to identify the locatization in an SQL Server database I would be thankful.
Thank you again and best regards.
Christian

View 2 Replies View Related

Localization Using SQL Server - DesignTimeResourceProviderFactory

Aug 17, 2006

Hi,

I am implementing a "customizable resource provider" for Globalization based  on Sql Server instead of resource files. After reading the following articules:

http://msdn2.microsoft.com/en-us/library/azx5x197.aspx 

 http://msdn2.microsoft.com/en-us/library/9b1d2yze(en-US,VS.80).aspx

I was able to produce a library that save local resources and and retrive resources from Sql Server using "GetGlobalResourceObject() and GetLocalResourceObject()", but I am having trouble to make it work with "Intelicense".

I think that the issue is related to class derived from "System.Web.UI.Design.DesignTimeResourceProviderFactory" class.

Does anyone knows where I can get more information regarding customizable resource provider and intelicense?

Note: I do not know how to attach my code.

 

Thank you,

 

Rj3

 

View 1 Replies View Related

SQL Server 2012 :: Localization Of A Table To Japanese Language?

Jul 15, 2015

I have a table called country that will store all the country related details in it. Below is the screenshot of my country table.

I want to localize this table to Japanese language. I googled out and found out that a new table needs to be created for storing the data in localized language.

If that's the case do we need to manually translate the text in the country table for each and every country?

Is there any automated process for that? Just like not translating the text manually for each and every rows..

This is because I have few more tables in which the text are not static. they will get loaded on a daily basis. So i will not be able to translate them every day..

View 5 Replies View Related

Sql Server Stored Procedures, Just One Thing After Another

Jul 2, 2007

 In a previous post, someone helped me with creating stored procedures, and I am grateful because I am transitioning from the Access World.
Anyway, I get an error at .ExecuteNonQuery in visual studio 2005 when I run the following code: 
Dim strsql As String        Dim strconn As String        strsql = "sp_Roster"        strconn = "server=xxxx; user=xxxx; pwd=xxxx; database=xxxx;"        With comm            .Connection = New SqlConnection(strconn)            .CommandText = strsql            .CommandType = CommandType.StoredProcedure            With .Parameters.Add("TeacherID", SqlDbType.Char)                .Value = "DawsMark@aol.com"            End With            With .Parameters.Add("ClassID", SqlDbType.Int)                .Value = classid            End With            With .Parameters.Add("sID", SqlDbType.Int)                .Value = ssID            End With            With .Parameters.Add("sLastName", SqlDbType.Char)                .Value = lastname            End With            With .Parameters.Add("sFirstName", SqlDbType.Char)                .Value = firstname            End With            With .Parameters.Add("sMiddleName", SqlDbType.Char)                .Value = middlename            End With            With .Parameters.Add("Student", SqlDbType.Char)                .Value = fullname            End With            With .Parameters.Add("Password", SqlDbType.Char)                .Value = password            End With            .Connection.Open()            .ExecuteNonQuery()            With comm.Connection                If .State = ConnectionState.Open Then                    .Close()                End If            End With        End With
The error was:  Error converting data type char to int.
The stored procedure in sql server was as follows 
CREATE PROCEDURE sp_Roster     -- Add the parameters for the stored procedure here@TeacherID varchar(50),@ClassID  int,@sID int,@sLastName varchar(50),@sFirstName varchar(50),@sMiddleName varchar(50),@Student varchar(50),@Password varchar(50)ASBEGIN    -- SET NOCOUNT ON added to prevent extra result sets from    -- interfering with SELECT statements.    SET NOCOUNT ON;    -- Insert statements for procedure here    INSERT INTO Roster (TeacherID, ClassID, sID, sLastName, sFirstName, sMiddleName, Student, Password) VALUES (@TeacherID, @ClassID, @sID, @sLastName, @sFirstName, @sMiddleName, @Student, @Password)ENDGO
The error also says "sqlexception was unhandled by user code.
This is strange because this code worked perfectly when connecting to Access and when I used oledb. 
So how is it the code's problem?  Is the stored procedure causing the error or the code.  Can someone please help. thanks. 
<Edited by Dinakar Nethi>
Please mask your useird/pwd info in the connection string when posting to a public forum like this
</Edit>

View 2 Replies View Related

Array (or Similar Thing ) In Sql Server

Jul 4, 2005

I would like to write a fun or stored procedure to do some operation. It require me to know that what category is currently belong to certain people(people_table: category_table1               to           Many)However, when i use the select statement in stored proc, it return a set of result, not a scalar , therefore, i cannot use the variable to hold it. In addition, there are no array in SQL server.Question:1. Is there any way to hold the collection of result(like array)?2. Also, how to determine to use fun or stored procedure?(Since a integer is need to return by them)Thx

View 4 Replies View Related

SQL Server Sluggish First Thing In The Morning

Sep 15, 2005

Every morning our sql server runs very slowly which means our log on
page times out on a simple query. If we stop and start the sql server
everything runs fine for the rest of the day until the follwing
morning. the server is not used out of business hours excpet for a few
very small and simple jobs to delete records, These all run to
completion. Any help with this would be much aprreciated! Thanks.
Rob

View 2 Replies View Related

Localization

Jun 24, 2007

Dear friends,



Is there any provision to make the SQL Server Reporting Services commands,returning from SQL query, instead of writing that directly in the report.



Best Regards,

Baburaj

View 3 Replies View Related

Localization Issue

Jul 23, 2005

Hi All,I already have a web site running with SQL Server as a backend (inenglish)For future growth, I would like to make it localized. Regardingthe database, I have come up with several approaches.1) just simply add the column in those table which needs differentlanguage.2) add additional tables to do it.3) create a new database to store different language's informationAs mentioned, my database have already been implemented, so the minimummodification is preferred. Could you guys suggest me the best way to doit?Another thing, if I alter my existing database into UTF-8 now, will itaffect the original data (ie. English).Thanks.Ice

View 7 Replies View Related

Localization And Sqlserver

Jul 20, 2005

Hi,I have a simple 'user' table and an ASP form that connects to it. Iwant users of all languages to be able to type in their registrationinfo, in their own language, store it that way, then have another pagethat displays it.Are there any specific settings I need in SQL Server to handle this?Thanks

View 4 Replies View Related

Localization Of Reports

May 15, 2007



How can i add resources to my report (*.rdl) at runtime depending upon the curren culture ie text ,date formats ,currency setting getting changed according to current culture.Is there any way i can define resource file for report?



View 1 Replies View Related

Report Localization

Aug 20, 2007



I want to make my report in both english and spenish language.
how can I set culture for reports?

View 8 Replies View Related

Localization.Brain Storming.

Mar 16, 2007

 Hello,I am working on a Blog and a Documents systems.What I need is:1. Each blog can have various language versions.2. Each document can have various language versions.I have been thinking about this and I end up with two approaches:1. Use a structure where all tables depend on a localized table:BLOGS|---- BlogsLocalized|---- BlogsPosts|---- BlogsRatings|---- BlogsComments2. Use a structure where each table has a localized versionBLOGS|---- BlogsLocalized|---- BlogsPosts|---- BlogsPostsLocalized|---- BlogsComments|---- BlogsCommentsLocalized3. Create a simpler, without localization, in SQL and in my web sites have different versions for each language.The same approach is under thinking for DocumentsTables.Could someone give me some advice?I have been looking in internet but until no I couldn't find anything really useful.Thanks,Miguel

View 1 Replies View Related

Report Parameter Localization

Jul 24, 2007

Hi everybody,
I have a question does it possible to have the param prompt in the different language without doing multipe report for each language, I saw it is possible for the label, but I didn't see how to do for the prompt param.
I hope someone could help me.
Thank you.

View 2 Replies View Related

Date Formatting Or Localization

May 31, 2007

I have written this ugly expression because I didn't know any other way. What I am trying to do is convert an English date string to a French string.

example

January 2005 ---> Janvier 2005

Thank you,

Pavel


=Switch(

Month(CDate(Fields!Month.Value) ) = 1, "Janvier" & " " & Year(CDate(Fields!Month.Value)),
Month(CDate(Fields!Month.Value) ) = 2, "Fevrier" & " " & Year(CDate(Fields!Month.Value)),
Month(CDate(Fields!Month.Value) ) = 3, "Mars" & " " & Year(CDate(Fields!Month.Value)),
Month(CDate(Fields!Month.Value) ) = 4, "Avril" & " " & Year(CDate(Fields!Month.Value)),
Month(CDate(Fields!Month.Value) ) = 5, "Mai" & " " & Year(CDate(Fields!Month.Value)),
Month(CDate(Fields!Month.Value) ) = 6, "Juin" & " " & Year(CDate(Fields!Month.Value)),
Month(CDate(Fields!Month.Value) ) = 7, "Juillet" & " " & Year(CDate(Fields!Month.Value)),
Month(CDate(Fields!Month.Value) ) = 8, "Aout" & " " & Year(CDate(Fields!Month.Value)),
Month(CDate(Fields!Month.Value) ) = 9, "September" & " " & Year(CDate(Fields!Month.Value)),
Month(CDate(Fields!Month.Value) ) = 10, "Octobre" & " " & Year(CDate(Fields!Month.Value)),
Month(CDate(Fields!Month.Value) ) = 11, "November" & " " & Year(CDate(Fields!Month.Value)),
Month(CDate(Fields!Month.Value) ) = 12, "December" & " " & Year(CDate(Fields!Month.Value))

)

View 2 Replies View Related

Localization And BUILTIN Groups

Jun 28, 2006

Is there a synonym for the group BUILTINUsers which can be used for GRANT ... TO and sp_grantlogin/sp_grantdbaccess, but which will work on localized computers?

I have a number of automated unit tests I wish to run on two different computers. The process involves recreating a database if it does not exist and then granting access and privileges to the BUILTINUsers group.

The problem is that one computer is installed with a Swedish Windows XP Professional (the users group is called BUILTINAnvändare) and the other is an English WinXP MCE (the group is called BUILTINUsers) so I cannot easily script this.

An alternative is to be able to retrieve the respective name through a .NET class or the Windows API.

Is any of this possible?

Thanks,
Johan

View 8 Replies View Related

Localization/Language/Culture Parameter

Sep 17, 2007



Where can I obtain a list of the languages as used in the report language property for populating a parameter?

Currently if I put the list that is in the Language Dropdown (Ex. "French (France)") it does not work. I have to use "fr - Fr"

Thanks
BobP

View 1 Replies View Related

Localization Of Report Manager To Portuguese

Dec 19, 2006

Hello to all!

I want to translate de interface of the Report Manager to Portuguese. I'm develop a class that implements

Microsoft.Reporting.WebForms.IReportViewerMessages The class is in a file called "ReportViewerMessages.cs". The structure is like this, the project is called "PortugueseReportManager", there is a namespace named "PortugueseReportManager" and the name of the class is "ReportViewerMessages".

So far so good, but when I change de web.config file in the report manager folder I'm getting over and over this error message when I try to see a report: The type PortugueseReportManager.ReportViewerMessages, PortugueseReportManager, Version=1.612.19.1, Culture=neutral, PublicKeyToken=5cdefa29ce50bd9e does not implement IReportViewerMessages or could not be found

This is the line that I add to the config file:

<add key="ReportViewerMessages" value="PortugueseReportManager.ReportViewerMessages, PortugueseReportManager, Version=1.612.19.1, Culture=neutral, PublicKeyToken=5cdefa29ce50bd9e"/>

The version is correct and the public key token I get by strong signing the class and then run de command: "sn -T PortugueseReportManager.dll

I copy the dll file to the Bin folder of my Report Manager folder.

Please, can anyone help me in this one? I try a lot of combinations in the config file and so far I did't get any results.



Thanks in advance!

View 13 Replies View Related

Localization Web ReportViewer Control In VS2005

Jan 17, 2008

Hi everyone,I followed the steps below to localize the report viewer control accoring to http://msdn2.microsoft.com/en-us/library/ms251723(VS.80).aspx"
Deploying Localized Versions of ReportViewer ControlsThe ReportViewer control includes language packs for eight languages: Chinese-Simplified, Chinese-Traditional, French, German, Italian, Japanese, Korean, and Spanish. To use a localized version of the control, you must do the following:1. Run ReportViewer.exe.2. Navigate to the folder that contains the language pack you want to use. Language pack folders are located at <drive>:Program FilesMicrosoft Visual Studio 8SDKv2.0BootStrapperPackagesReportViewer<lang>.3. Run ReportViewerLP.exe."
But I could not find the ReportViewerLP.exe in the step 3. Could anyone please tell me why?Thanks a lot.Danny

View 1 Replies View Related

The Whole Dbo.thing....

Dec 6, 2007

As a burgeoning SQL developer I have never really understood the need for SQL Server / Enterprise Manager to show us the whole dbo.Table name thing. What is dbo, and why do we need to know deal with it?With that said, in my SQL 2005 Express database all of my project tables for my project management demo were named guard.pgUsers for example and not dbo.pgUsers.How come? Why did they get named different on their own? 

View 2 Replies View Related

I've Done A Very Silly Thing And Need Help

Mar 25, 2003

After being put in a position where I had to deal with a SQL problem without very little SQL knowledge I have screwed a clients main database up.

I backed up the transaction log and then deleted the log. The database is shown as suspect and won't let me restore.

Am I F&%ked?


Any help in sorting this out will be rewarded with much kudos and thanks

View 12 Replies View Related

Group By Thing

Mar 31, 2008

I try to do:

DECLARE
@ThisMinute DateTime,
@ThisDay DateTime

SET@ThisMinute = DATEADD(MINUTE, DATEDIFF(MINUTE, '20000101', CURRENT_TIMESTAMP), '20000101')
SET@ThisDay = DATEADD(DAY, DATEDIFF(DAY, '20000101', CURRENT_TIMESTAMP), '20000101')

SELECT
row_number() over (order by MAX(HeadlineDate)) as Number,
COUNT(ArticleID) AS [Count],
MIN(DATEADD(dd, - (DAY(HeadlineDate) - 1), HeadlineDate)) AS HeadlineDate
FROM
dbo.ZMArticle
WHERE
PortalID=0

GROUP BY
MONTH(HeadlineDate), Year(HeadlineDate)
ORDER BY
MAX(HeadlineDate) desC

Which works fine, but when I do:

DECLARE
@ThisMinute DateTime,
@ThisDay DateTime

SET@ThisMinute = DATEADD(MINUTE, DATEDIFF(MINUTE, '20000101', CURRENT_TIMESTAMP), '20000101')
SET@ThisDay = DATEADD(DAY, DATEDIFF(DAY, '20000101', CURRENT_TIMESTAMP), '20000101')

SELECT
row_number() over (order by MAX(HeadlineDate)) as Number,
COUNT(ArticleID) AS [Count],
MIN(DATEADD(dd, - (DAY(HeadlineDate) - 1), HeadlineDate)) AS HeadlineDate
FROM
dbo.ZMArticle
WHERE
PortalID=0
AND
Expiredate <> Null
GROUP BY
MONTH(HeadlineDate), Year(HeadlineDate)
ORDER BY
MAX(HeadlineDate) desC

it doesn't return anything....

How can I change that


The secret to creativity is knowing how to hide your sources. (Einstein)

View 3 Replies View Related

Is There Such A Thing As Too Many Relationship?

Jul 20, 2005

Hi,I have a corporate database with about 60 different tables that spansmanufacturing, accounting, marketing, etc.It is possible, but unwieldy, to establish a relationship for eachtable in the entire database through critical fields like customer_idor product_id.But should I do that?My question is: Is there such a thing as too many relationships? CanI establish referential integrity via relationships with criticaltables like Accounting, but leave the rest unconnected and simply useJOINS in my business code?Thanks,HC

View 4 Replies View Related

Is There Such A Thing As Table Name Wildcards?

Jan 8, 2007

Hey all,I have a datagrid with populated by this query: SELECT TABLE_NAME, TABLE_TYPE FROM INFORMATION_SCHEMA.TABLES WHERE (TABLE_TYPE = 'BASE TABLE')I have paging, sorting and selection enabled.Now I am looking for a way to use a wild card as a placeholder for the table name in my select statements so I can use the valued selected from the datagrid.Example : SELECT * FROM %TABLENAME%TIAWOOHOO! my first post. 

View 2 Replies View Related

This Thing Gives Me Scaler Error

May 23, 2008

i got this stored procedure.
i tried to modify it and now its giving me this scaler error.
 
Msg 137, Level 15, State 2, Procedure insertuser, Line 4
Must declare the scalar variable "@seller_id".
 
 USE [DBCars]
GO
/****** Object: StoredProcedure [dbo].[insertuser] Script Date: 05/23/2008 20:44:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER procedure [dbo].[insertuser]
(@Make nchar(10),@Model nchar(10),@City nchar(10),@SellerID varchar(50),@MileAge nchar(10),@Year_Model int)
as
insert into tbcar values(@make,@model,@city,@seller_id,@mileage,@year_model);

View 4 Replies View Related

Are There Such A Thing As Arrays In TSQL?

Feb 10, 2004

I'm have a stored procedure that iterates through a list of numbers and adds an item for each number (user id) some of these ids are duplicates which is fine even necessary for the first part of my query but for the last I need to ensure that no duplicates id's are passed to the stored procedure, in this case called 'spInsertForBackupNote'. My thoughts here was to do something like this:

SET @Note_Buffer = @UserID -- @Note_Buffer being some kind of array?

IF @Note_Buffer = @UserID -- If its been added to the buffer we dont execute sp
BEGIN
Do Nothing here
END

ELSE

BEGIN
EXECUTE spInsertForBackupNote @FK_UserID, @FK_NoteID
END

I know this would never work because it would always be false since I just added the same userid to the buffer that I want to add. But I think you see my problem. I know it should be an easy one but my TSQL is limited. I've posted the whole sp. Hope someone can help.

CREATE PROCEDURE spInsertAssignedNotesByList
@FK_UserIDList NVARCHAR(4000) = NULL,
@FK_NoteIDList NVARCHAR(4000) = NULL,
@By_Who INT,
@UserID INT

AS
SET NOCOUNT ON

DECLARE @Length INT
DECLARE @Note_Length INT
DECLARE @Note_Buffer INT

DECLARE @FirstUserIDWord NVARCHAR(4000)
DECLARE @FirstNoteIDWord NVARCHAR(4000)

DECLARE @FK_UserID INT
DECLARE @FK_NoteID INT

SELECT @Length = DATALENGTH(@FK_UserIDList )
SELECT @Note_Length = DATALENGTH(@FK_NoteIDList )

DECLARE @TempFK_NoteIDList NVARCHAR(4000) --= NULL
DECLARE @Temp_NoteLength INT

SET @TempFK_NoteIDList = @FK_NoteIDList
SET @Temp_NoteLength = DATALENGTH(@FK_NoteIDList )


-- IF @Length > @Note_Length -- If we have more users than notes

BEGIN

WHILE @Length > 0
BEGIN

IF @Length > 0

EXECUTE @Length = PopFirstWord @FK_UserIDList OUTPUT, @FirstUserIDWord OUTPUT
SELECT @FK_UserID = CONVERT(INT, @FirstUserIDWord)

IF @Length > 0
BEGIN

SET @FK_NoteIDList = @TempFK_NoteIDList
SET @Note_Length = @Temp_NoteLength

WHILE @Note_Length > 0
BEGIN
EXECUTE @Note_Length = PopFirstWord @FK_NoteIDList OUTPUT, @FirstNoteIDWord OUTPUT
SELECT @FK_NoteID = CONVERT(INT, @FirstNoteIDWord)

IF @Note_Length > 0
EXECUTE spInsertAssignedNoteDetail @FK_UserID, @FK_NoteID


SET @Note_Buffer = @UserID
EXECUTE spInsertForBackupNote @FK_UserID, @FK_NoteID, @By_Who, @UserID -- NEW HERE
END
END

END
END



--------------------------------------------------
GO

View 6 Replies View Related

Is There Such A Thing As A Variable SUBSTRING?

Nov 27, 2001

I have this field in a table.

NAME
--------------------
Johnson, Bill P.


I need to cut it up into this in another table:


LAST_NAME FIRST_NAME MID_INIT
-----------------------------------------------------
Johnson Bill P


I can't use SUBSTRING command because the length of this field will change with every row.

Is there a way I can tell it to truncate past or prior to the comma or spaces?

Thanks!

Lance

View 2 Replies View Related

This Should Be The Easist Thing To Do... Have A Counter...

Apr 25, 2007

This should be so easy.

All I want to do is have a cumalative counter that counts from 1 to whatever.



any ideas how i can do this?

View 6 Replies View Related

DTExec Can This Thing Run In The Background?

Sep 24, 2007



I have a DTS Package that I am running from a command line via .bat file. Does anyone know if there is a command to have the command window minimized or running in the background? I used the /Rep N command but that still leaves the window open until the package has executed.

Thanks!

View 3 Replies View Related

One Surprise Thing When Use VarDecimal

Aug 3, 2007

Hi ALl,

When I open the VarDecimal option in our SAP R3P system, I found the space used is increased.

Before turn on the option:
Total space:528315.31MB
Fee Sapce:0.00MB

After trun on the option:
Total Space:733815.31MB
Free Space:119006.31MB

it is very interestion, anyone has this experience?

thanks.

View 4 Replies View Related

How To Do The Same Thing In Mssql As Mysql?

Apr 13, 2006

in MySql:

SELECT * FROM table LIMIT 5,10

How to do this in MicroSoftSql?

View 9 Replies View Related

How Can I Select One Only To Display If There's Same Thing More Then One In Table.

Aug 20, 2003

Hi ..
i am SqL beginner. i having trouble output what i want from table.
table contain 3 columns
________________________________
|(names)|(item)|(location)|
1.| Jimmy | pizza| TX |
2.| Joe | ball | CA |
3.| Joe | ball | WA |
4.| Jim | shoes| AZ |
________________________________

i try to select all records out from this table. but column 2 and 3 contain same information in names and item only different is location. how can distinct one of them?? and display like the below, please advise.

|(names)|(item)|
1.| Jimmy | pizza|
2.| Joe | ball |
3.| Jim | shoes|
________________________________

View 3 Replies View Related

JOINing... But Not With The Multiple Rows Thing.

Jul 19, 2006

My thread titles need work, I know. :o

Ok, lets say I've got:

tblDocuments
id INT PK
documentName VARCHAR

tblUsers
id INT PK
userName VARCHAR

tblDocumentApprovals
userID INT
documentID INT
approvalDate DATETIME


If I want to get a list of documents, and the users who've signed them off (if any), I'd do something like:

SELECT [tblDocuments].[documentName], [tblUsers].[userName ], [tblDocumentApprovals].[approvalDate ]
FROM [tblDocuments]
LEFT JOIN [tblDocumentApprovals] ON [tblDocumentApprovals].[documentID] = [tblDocuments.id]
INNER JOIN [tblUsers] ON [tblUsers].[id] = [tblDocumentApprovals].[userID]

...which is lovely. Except - I don't want a row returned for each user that's signed it off. I want one row for each document, with a field containing a list of the people who've signed it off.

I know that it's bad design. I was reading an article only yesterday on how they're putting this kind of thing into the latest version of Access, and how it's a bit of a kludge. But it'd really, really help me.

How do you do it?

View 8 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved