Showing posts with label current. Show all posts
Showing posts with label current. Show all posts

Sunday, March 11, 2012

chinese localization of english software suite

Hi,
Our company is planning a project to localise our current software suite for
chinese market. As a SQL DBA, I would like to get more information of what
is involved from database admin and development perspective. I would
appreciate any help, artical links and/or materials links etc. Thanks.
I'm interested in this too. I would guess that you need Chinese locale,
collation etc. for the specific database.
Tables would be able to store Chinese characters. Developing programs may
still use English.
"flologic" <flo@.flo.net> wrote in message
news:%23bdrZYqlEHA.1244@.TK2MSFTNGP15.phx.gbl...
> Hi,
> Our company is planning a project to localise our current software suite
for
> chinese market. As a SQL DBA, I would like to get more information of what
> is involved from database admin and development perspective. I would
> appreciate any help, artical links and/or materials links etc. Thanks.
>
|||Here are some good article you can start with
http://msdn.microsoft.com/library/de...server2000.asp
http://www.microsoft.com/globaldev/g...s/wrguide.mspx
http://msdn.microsoft.com/library/de...plications.asp
Wei Xiao [MSFT]
SQL Server Storage Engine Development
This posting is provided "AS IS" with no warranties, and confers no rights.
"Richard Ding" <rding@.acadian-asset.com> wrote in message
news:u$eSew0lEHA.2380@.TK2MSFTNGP14.phx.gbl...
> I'm interested in this too. I would guess that you need Chinese locale,
> collation etc. for the specific database.
> Tables would be able to store Chinese characters. Developing programs may
> still use English.
>
> "flologic" <flo@.flo.net> wrote in message
> news:%23bdrZYqlEHA.1244@.TK2MSFTNGP15.phx.gbl...
> for
>

chinese localization of english software suite

Hi,
Our company is planning a project to localise our current software suite for
chinese market. As a SQL DBA, I would like to get more information of what
is involved from database admin and development perspective. I would
appreciate any help, artical links and/or materials links etc. Thanks.I'm interested in this too. I would guess that you need Chinese locale,
collation etc. for the specific database.
Tables would be able to store Chinese characters. Developing programs may
still use English.
"flologic" <flo@.flo.net> wrote in message
news:%23bdrZYqlEHA.1244@.TK2MSFTNGP15.phx.gbl...
> Hi,
> Our company is planning a project to localise our current software suite
for
> chinese market. As a SQL DBA, I would like to get more information of what
> is involved from database admin and development perspective. I would
> appreciate any help, artical links and/or materials links etc. Thanks.
>|||Here are some good article you can start with
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/intlfeaturesinsqlserver2000.asp
http://www.microsoft.com/globaldev/getWR/steps/wrguide.mspx
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpcondesigningglobalapplications.asp
Wei Xiao [MSFT]
SQL Server Storage Engine Development
This posting is provided "AS IS" with no warranties, and confers no rights.
"Richard Ding" <rding@.acadian-asset.com> wrote in message
news:u$eSew0lEHA.2380@.TK2MSFTNGP14.phx.gbl...
> I'm interested in this too. I would guess that you need Chinese locale,
> collation etc. for the specific database.
> Tables would be able to store Chinese characters. Developing programs may
> still use English.
>
> "flologic" <flo@.flo.net> wrote in message
> news:%23bdrZYqlEHA.1244@.TK2MSFTNGP15.phx.gbl...
>> Hi,
>> Our company is planning a project to localise our current software suite
> for
>> chinese market. As a SQL DBA, I would like to get more information of
>> what
>> is involved from database admin and development perspective. I would
>> appreciate any help, artical links and/or materials links etc. Thanks.
>>
>

Thursday, March 8, 2012

Chinese character in the field (Sql 7)

Guys,
I have to replace some old chinese characters (words) with some new
ones. In the database, the fields are displayed as ?.
The current chinese characters will display fine when you retrieved the
fields through the website. As soon as I cut and paste the new chinese
characters onto the field that I want to replace, the website will
display ? with the fields that I just updated.
I have installed the Chinese (Taiwan) letters and enable my language
toolbar. During the cut and paste process, I also switched to "CH".
Any idea?
Please help.
Thanks in advance,
TonyHi,
You can try to use CAST(0xABCD1234 as NVARCHAR(4)) etc. instead of copy and
paste.
Replace the 0xABCD1234 with the binary code of the Chinese characters.
Kenneth
<tractng@.gmail.com> wrote in message
news:1132790630.847208.228190@.z14g2000cwz.googlegroups.com...
> Guys,
> I have to replace some old chinese characters (words) with some new
> ones. In the database, the fields are displayed as ?.
> The current chinese characters will display fine when you retrieved the
> fields through the website. As soon as I cut and paste the new chinese
> characters onto the field that I want to replace, the website will
> display ? with the fields that I just updated.
>
> I have installed the Chinese (Taiwan) letters and enable my language
> toolbar. During the cut and paste process, I also switched to "CH".
> Any idea?
> Please help.
>
> Thanks in advance,
> Tony
>|||Kenneth,
Can you explain, how I can do this. I am a newbie.
Thanks,
Tony

Friday, February 24, 2012

Checking Out Data to Client Users

I'm trying to resolve an issue that I've run into in my current system.

I have about 10 clients accessing a SQL Server several times per minute (every 10-20 seconds). To have an individual find the next record, I follow the following process:

1. Select the value of the next record in the database to be checked out.
2. Update the record to show that it is checked out to the user.
3. Select the data in the record to display to the user.
3. Update the record to show any changes and to check the record back in after the user edits it.

My issue is that clients can execute at the same time. Right now, with just SQL statements, two clients can get the same value in step #1. That makes them select the same record for editing. Can I use T-SQL to prevent this from happening? If I use a transaction, will the SQL Server 2005 queue up the transactions, or could I still get the same problem of opening up the same record?

Thanks!
Drew

Hi,

this depends on your update clause for setting the "inUseFlag". If you code it the following way there will be no concurrency with any user:

UPDATE SOMETABLE T
SET Checkout = 'CheckOutorWhatever'
OUTPUT INSERTED.IDColumn
FROM SomeTable T
WHERE EXISTS
(
SELECT * FROM SomeTable TSub
WHere T.IDColumn = TSub.IDColumn
AND Checkout IS NULL
)

HTH, Jens K. Suessmeyer.


http://www.sqlserver2005.de|||Thanks! I didn't know about the OUTPUT statement and couldn't find anything through Google.

Sunday, February 19, 2012

checking if a particular DATE LIES IN CURRENT QUARTER

I have a table where their are columns as
Name,
Date,
Payment
Row_id (PK)
Now 1 name can has as many records and
each record for that name can be identified by the min Row_ID
I want to do the following
1. Check if the firstPayment date was within the Current Quarter where Name = "SAMAY"
2. Check if the LastPaymentdate was within the Current Quarter where Name = "SAMAY"
3. Check if the firstPayment date was in the last Quarter but
LastPayment was within the Current Quarter where Name = "SAMAY"
Please advice
Thanks
Use a calendar table.
http://www.aspfaq.com/2519
http://www.aspfaq.com/
(Reverse address to reply.)
"KritiVerma@.hotmail.com" <KritiVermahotmailcom@.discussions.microsoft.com>
wrote in message news:ACCB6395-78AA-4FC4-8C34-D6F65F3620EB@.microsoft.com...
> I have a table where their are columns as
> Name,
> Date,
> Payment
> Row_id (PK)
> Now 1 name can has as many records and
> each record for that name can be identified by the min Row_ID
> I want to do the following
> 1. Check if the firstPayment date was within the Current Quarter where
Name = "SAMAY"
> 2. Check if the LastPaymentdate was within the Current Quarter where Name
= "SAMAY"
> 3. Check if the firstPayment date was in the last Quarter but
> LastPayment was within the Current Quarter where Name = "SAMAY"
> Please advice
> Thanks
>

checking if a particular DATE LIES IN CURRENT QUARTER

I have a table where their are columns as
Name,
Date,
Payment
Row_id (PK)
Now 1 name can has as many records and
each record for that name can be identified by the min Row_ID
I want to do the following
1. Check if the firstPayment date was within the Current Quarter where Name
= "SAMAY"
2. Check if the LastPaymentdate was within the Current Quarter where Name =
"SAMAY"
3. Check if the firstPayment date was in the last Quarter but
LastPayment was within the Current Quarter where Name = "SAMAY"
Please advice
ThanksUse a calendar table.
http://www.aspfaq.com/2519
http://www.aspfaq.com/
(Reverse address to reply.)
"KritiVerma@.hotmail.com" <KritiVermahotmailcom@.discussions.microsoft.com>
wrote in message news:ACCB6395-78AA-4FC4-8C34-D6F65F3620EB@.microsoft.com...
> I have a table where their are columns as
> Name,
> Date,
> Payment
> Row_id (PK)
> Now 1 name can has as many records and
> each record for that name can be identified by the min Row_ID
> I want to do the following
> 1. Check if the firstPayment date was within the Current Quarter where
Name = "SAMAY"
> 2. Check if the LastPaymentdate was within the Current Quarter where Name
= "SAMAY"
> 3. Check if the firstPayment date was in the last Quarter but
> LastPayment was within the Current Quarter where Name = "SAMAY"
> Please advice
> Thanks
>

checking if a particular DATE LIES IN CURRENT QUARTER

I have a table where their are columns as
Name,
Date,
Payment
Row_id (PK)
Now 1 name can has as many records and
each record for that name can be identified by the min Row_ID
I want to do the following
1. Check if the firstPayment date was within the Current Quarter where Name = "SAMAY"
2. Check if the LastPaymentdate was within the Current Quarter where Name = "SAMAY"
3. Check if the firstPayment date was in the last Quarter but
LastPayment was within the Current Quarter where Name = "SAMAY"
Please advice
ThanksUse a calendar table.
http://www.aspfaq.com/2519
--
http://www.aspfaq.com/
(Reverse address to reply.)
"KritiVerma@.hotmail.com" <KritiVermahotmailcom@.discussions.microsoft.com>
wrote in message news:ACCB6395-78AA-4FC4-8C34-D6F65F3620EB@.microsoft.com...
> I have a table where their are columns as
> Name,
> Date,
> Payment
> Row_id (PK)
> Now 1 name can has as many records and
> each record for that name can be identified by the min Row_ID
> I want to do the following
> 1. Check if the firstPayment date was within the Current Quarter where
Name = "SAMAY"
> 2. Check if the LastPaymentdate was within the Current Quarter where Name
= "SAMAY"
> 3. Check if the firstPayment date was in the last Quarter but
> LastPayment was within the Current Quarter where Name = "SAMAY"
> Please advice
> Thanks
>

Thursday, February 16, 2012

Checking Database Recovery Mode

Hi,
How can I find out what the current recovery mode of a database is?
I know that I can set it with ALTER DATABASE command but I don't know how to
check to see what the current mode is. Could you please someone help me?
I didn't find anything in sysdatabases table.
Thank you,
RosieTry:
SELECT DATABASEPROPERTYEX('MyDatabase', 'Recovery')
Hope this helps.
Dan Guzman
SQL Server MVP
"Rosie" <Rosie@.discussions.microsoft.com> wrote in message
news:3EB4D6F6-7813-40C0-990B-2FF8E3EEDEE1@.microsoft.com...
> Hi,
> How can I find out what the current recovery mode of a database is?
> I know that I can set it with ALTER DATABASE command but I don't know how
> to
> check to see what the current mode is. Could you please someone help me?
> I didn't find anything in sysdatabases table.
> Thank you,
> Rosie
>|||Great! Thank you for your help.
Rosie
"Dan Guzman" wrote:

> Try:
> SELECT DATABASEPROPERTYEX('MyDatabase', 'Recovery')
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Rosie" <Rosie@.discussions.microsoft.com> wrote in message
> news:3EB4D6F6-7813-40C0-990B-2FF8E3EEDEE1@.microsoft.com...
>
>|||I'm glad I was able to help.
Dan Guzman
SQL Server MVP
"Rosie" <Rosie@.discussions.microsoft.com> wrote in message
news:685AF33B-8EBC-4BE5-9D15-556A1712A1CD@.microsoft.com...[vbcol=seagreen]
> Great! Thank you for your help.
> Rosie
> "Dan Guzman" wrote:
>

Checking Database Recovery Mode

Hi,
How can I find out what the current recovery mode of a database is?
I know that I can set it with ALTER DATABASE command but I don't know how to
check to see what the current mode is. Could you please someone help me?
I didn't find anything in sysdatabases table.
Thank you,
RosieTry:
SELECT DATABASEPROPERTYEX('MyDatabase', 'Recovery')
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Rosie" <Rosie@.discussions.microsoft.com> wrote in message
news:3EB4D6F6-7813-40C0-990B-2FF8E3EEDEE1@.microsoft.com...
> Hi,
> How can I find out what the current recovery mode of a database is?
> I know that I can set it with ALTER DATABASE command but I don't know how
> to
> check to see what the current mode is. Could you please someone help me?
> I didn't find anything in sysdatabases table.
> Thank you,
> Rosie
>|||Great! Thank you for your help.
Rosie
"Dan Guzman" wrote:
> Try:
> SELECT DATABASEPROPERTYEX('MyDatabase', 'Recovery')
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Rosie" <Rosie@.discussions.microsoft.com> wrote in message
> news:3EB4D6F6-7813-40C0-990B-2FF8E3EEDEE1@.microsoft.com...
> > Hi,
> >
> > How can I find out what the current recovery mode of a database is?
> >
> > I know that I can set it with ALTER DATABASE command but I don't know how
> > to
> > check to see what the current mode is. Could you please someone help me?
> >
> > I didn't find anything in sysdatabases table.
> >
> > Thank you,
> > Rosie
> >
>
>|||I'm glad I was able to help.
--
Dan Guzman
SQL Server MVP
"Rosie" <Rosie@.discussions.microsoft.com> wrote in message
news:685AF33B-8EBC-4BE5-9D15-556A1712A1CD@.microsoft.com...
> Great! Thank you for your help.
> Rosie
> "Dan Guzman" wrote:
>> Try:
>> SELECT DATABASEPROPERTYEX('MyDatabase', 'Recovery')
>> --
>> Hope this helps.
>> Dan Guzman
>> SQL Server MVP
>> "Rosie" <Rosie@.discussions.microsoft.com> wrote in message
>> news:3EB4D6F6-7813-40C0-990B-2FF8E3EEDEE1@.microsoft.com...
>> > Hi,
>> >
>> > How can I find out what the current recovery mode of a database is?
>> >
>> > I know that I can set it with ALTER DATABASE command but I don't know
>> > how
>> > to
>> > check to see what the current mode is. Could you please someone help
>> > me?
>> >
>> > I didn't find anything in sysdatabases table.
>> >
>> > Thank you,
>> > Rosie
>> >
>>

checking bandwidth of network

Hi ,
how can i check if the current bandwidth that i am having is enough for
the operation ? can i use the performance monitor or the profiler(which item
to choose) ?
tks & rdgs
what operation do you have in mind? performance monitor can show you network
bandwidth consumption. Even the task manager can do it.
Wei Xiao [MSFT]
SQL Server Storage Engine Development
http://weblogs.asp.net/weix
This posting is provided "AS IS" with no warranties, and confers no rights.
"maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
news:FCEFEFEB-F6E0-4FB3-AB78-80C8E3DC6076@.microsoft.com...
> Hi ,
> how can i check if the current bandwidth that i am having is enough for
> the operation ? can i use the performance monitor or the profiler(which
> item
> to choose) ?
> tks & rdgs
|||Hi ,
i am thinking of monitoring the SQL SERVER status from a client PC and the
operations i meant earlier are just some normal updates , select queries thru
a client interface
tks & rdgs
"wei xiao" wrote:

> what operation do you have in mind? performance monitor can show you network
> bandwidth consumption. Even the task manager can do it.
> --
> Wei Xiao [MSFT]
> SQL Server Storage Engine Development
> http://weblogs.asp.net/weix
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
> news:FCEFEFEB-F6E0-4FB3-AB78-80C8E3DC6076@.microsoft.com...
>
>

Tuesday, February 14, 2012

checking bandwidth of network

Hi ,
how can i check if the current bandwidth that i am having is enough for
the operation ? can i use the performance monitor or the profiler(which item
to choose) ?
tks & rdgswhat operation do you have in mind? performance monitor can show you network
bandwidth consumption. Even the task manager can do it.
--
Wei Xiao [MSFT]
SQL Server Storage Engine Development
http://weblogs.asp.net/weix
This posting is provided "AS IS" with no warranties, and confers no rights.
"maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
news:FCEFEFEB-F6E0-4FB3-AB78-80C8E3DC6076@.microsoft.com...
> Hi ,
> how can i check if the current bandwidth that i am having is enough for
> the operation ? can i use the performance monitor or the profiler(which
> item
> to choose) ?
> tks & rdgs|||Hi ,
i am thinking of monitoring the SQL SERVER status from a client PC and the
operations i meant earlier are just some normal updates , select queries thru
a client interface
tks & rdgs
"wei xiao" wrote:
> what operation do you have in mind? performance monitor can show you network
> bandwidth consumption. Even the task manager can do it.
> --
> Wei Xiao [MSFT]
> SQL Server Storage Engine Development
> http://weblogs.asp.net/weix
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
> news:FCEFEFEB-F6E0-4FB3-AB78-80C8E3DC6076@.microsoft.com...
> > Hi ,
> >
> > how can i check if the current bandwidth that i am having is enough for
> > the operation ? can i use the performance monitor or the profiler(which
> > item
> > to choose) ?
> >
> > tks & rdgs
>
>

checking bandwidth of network

Hi ,
how can i check if the current bandwidth that i am having is enough for
the operation ? can i use the performance monitor or the profiler(which item
to choose) ?
tks & rdgswhat operation do you have in mind? performance monitor can show you network
bandwidth consumption. Even the task manager can do it.
Wei Xiao [MSFT]
SQL Server Storage Engine Development
http://weblogs.asp.net/weix
This posting is provided "AS IS" with no warranties, and confers no rights.
"maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
news:FCEFEFEB-F6E0-4FB3-AB78-80C8E3DC6076@.microsoft.com...
> Hi ,
> how can i check if the current bandwidth that i am having is enough for
> the operation ? can i use the performance monitor or the profiler(which
> item
> to choose) ?
> tks & rdgs|||Hi ,
i am thinking of monitoring the SQL SERVER status from a client PC and the
operations i meant earlier are just some normal updates , select queries thr
u
a client interface
tks & rdgs
"wei xiao" wrote:

> what operation do you have in mind? performance monitor can show you netwo
rk
> bandwidth consumption. Even the task manager can do it.
> --
> Wei Xiao [MSFT]
> SQL Server Storage Engine Development
> http://weblogs.asp.net/weix
> This posting is provided "AS IS" with no warranties, and confers no rights
.
> "maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
> news:FCEFEFEB-F6E0-4FB3-AB78-80C8E3DC6076@.microsoft.com...
>
>

Friday, February 10, 2012

check sql licence

Hi, May I know how to check what is my current sql licence installed? I've
learnt that in control panel, there is a SQL Licence setup icon which I can
check. But some of my MSSQL server don't have this icon. Can you help?
Thanks
andrewTry to run this:
select serverproperty('LicenseType')
, serverproperty('NumLicenses')
"andrew" wrote:

> Hi, May I know how to check what is my current sql licence installed? I'v
e
> learnt that in control panel, there is a SQL Licence setup icon which I ca
n
> check. But some of my MSSQL server don't have this icon. Can you help?
> Thanks
> andrew|||Hi,
The result is:
disabled, null
May I know how can I change the values?
"Andre Vigneau" wrote:
[vbcol=seagreen]
> Try to run this:
> select serverproperty('LicenseType')
> , serverproperty('NumLicenses')
>
> "andrew" wrote:
>|||andrew wrote:
> Hi,
> The result is:
> disabled, null
> May I know how can I change the values?
>
LicenceType is not "implemented" in a reliable way. There was post about
this same problem a couple weeks ago. Trying giving the ng a search on
Google.
David Gugick
Imceda Software
www.imceda.com

check sql licence

Hi, May I know how to check what is my current sql licence installed? I've
learnt that in control panel, there is a SQL Licence setup icon which I can
check. But some of my MSSQL server don't have this icon. Can you help?
Thanks
andrew
Try to run this:
select serverproperty('LicenseType')
, serverproperty('NumLicenses')
"andrew" wrote:

> Hi, May I know how to check what is my current sql licence installed? I've
> learnt that in control panel, there is a SQL Licence setup icon which I can
> check. But some of my MSSQL server don't have this icon. Can you help?
> Thanks
> andrew
|||Hi,
The result is:
disabled, null
May I know how can I change the values?
"Andre Vigneau" wrote:
[vbcol=seagreen]
> Try to run this:
> select serverproperty('LicenseType')
> , serverproperty('NumLicenses')
>
> "andrew" wrote:
|||andrew wrote:
> Hi,
> The result is:
> disabled, null
> May I know how can I change the values?
>
LicenceType is not "implemented" in a reliable way. There was post about
this same problem a couple weeks ago. Trying giving the ng a search on
Google.
David Gugick
Imceda Software
www.imceda.com

check sql licence

Hi, May I know how to check what is my current sql licence installed? I've
learnt that in control panel, there is a SQL Licence setup icon which I can
check. But some of my MSSQL server don't have this icon. Can you help?
Thanks
andrewTry to run this:
select serverproperty('LicenseType')
, serverproperty('NumLicenses')
"andrew" wrote:
> Hi, May I know how to check what is my current sql licence installed? I've
> learnt that in control panel, there is a SQL Licence setup icon which I can
> check. But some of my MSSQL server don't have this icon. Can you help?
> Thanks
> andrew|||Hi,
The result is:
disabled, null
May I know how can I change the values?
"Andre Vigneau" wrote:
> Try to run this:
> select serverproperty('LicenseType')
> , serverproperty('NumLicenses')
>
> "andrew" wrote:
> > Hi, May I know how to check what is my current sql licence installed? I've
> > learnt that in control panel, there is a SQL Licence setup icon which I can
> > check. But some of my MSSQL server don't have this icon. Can you help?
> >
> > Thanks
> > andrew|||andrew wrote:
> Hi,
> The result is:
> disabled, null
> May I know how can I change the values?
>
LicenceType is not "implemented" in a reliable way. There was post about
this same problem a couple weeks ago. Trying giving the ng a search on
Google.
--
David Gugick
Imceda Software
www.imceda.com