Database Discussion Boards

Stephen McGuire7-Sep-06 2:57

7-Sep-06 2:57

I always do such edits in Access. I have never tried to alter table structures dynamically from VB.

You may want to try posting your question in MDBMakers.com.
This forum has Access MVP's and many knowledgeable users who may be able to help you.

Steve

Sql statement

charbelasmar5-Sep-06 20:53

charbelasmar

5-Sep-06 20:53

hi,

i'm working on mysql database i want to select from table last 10 rows inserted where id=5

Always Thx for you help

Regards,
Charbel Asmar

Re: Sql statement

Eric Dahlvang6-Sep-06 3:54

Eric Dahlvang

6-Sep-06 3:54

SELECT * from mytable where id=5 order by orderbyfield <code>LIMIT 10</code>

--EricDV Sig---------
Some problems are so complex that you have to be highly intelligent and well informed just to be undecided about them.
- Laurence J. Peters

ODBC API Query

Kuira5-Sep-06 14:05

Kuira

5-Sep-06 14:05

I'm using VC++ 6.0, and using the ODBC API to connect to the databse.

My question is that is there a way to find the limit of the number of fields permitted per Primary Key.

Eg. For MS SQL 2000/ 2005 limit is 16 or less fields for a primary key.
For MS Access the limit is 10 or less fields for a primary key.

Re: ODBC API Query

cmk8-Sep-06 11:31

cmk

8-Sep-06 11:31

Try SQLGetInfo(SQL_MAX_COLUMNS_IN_INDEX).

...cmk

Save the whales - collect the whole set

Collation Error

HRiazi5-Sep-06 11:12

HRiazi

5-Sep-06 11:12

Hi guys;
I have this problem with sql server 2000 and asp.net 2.0

Here is the problem:
I am trying to use the Roles.AddUserToRole(string username ,string Role).
Now the problem starts when the program gets to this place where it has to execute the addusertorole method. Im getting this error:

Error 446: cannot resolve collation conflict for equal to operation

I have read alot and searched the internet but I dont quit get what am I suppose to do.
Could you please help me to resolve this problem?

Thanks a million
Hadi

Re: Collation Error

HRiazi5-Sep-06 20:05

HRiazi

5-Sep-06 20:05

Hi ;

Thanks alot for the reply from minhpc_bk was very usefull. Right on time.
Here is how i fixed the problem:

I replaced the line in aspnet_UsersInRoles_AddUsersToRoles stored procedure

DECLARE @tbNames table(Name nvarchar(256) NOT NULL PRIMARY KEY)

with

DECLARE @tbNames table(Name nvarchar(256) COLLATE Database_Default NOT NULL PRIMARY KEY)

Riazi

SQL TOP Equivalen in SQL Server Everywhere 2005!!!

Nadia Monalisa5-Sep-06 9:30

Nadia Monalisa

5-Sep-06 9:30

Hi,
In SQL Server Everywhere, there is no support for keyword "TOP" for selecting
limited number of rows. Can you give me any idea how can I perform similar task with this limitation ?
Thanks in advance

Re: SQL TOP Equivalen in SQL Server Everywhere 2005!!!

HRiazi5-Sep-06 11:16

HRiazi

5-Sep-06 11:16

Hi;
If I understood your problem your trying to select a limited number of rows of your table?

What version of SQL SERVER are you using? If your using 2000 then the TOP keyword should work fine.

SELECT TOP 7 FROM LatestNews

Im using it with out problems.

Riazi

Re: SQL TOP Equivalen in SQL Server Everywhere 2005!!!

Nadia Monalisa5-Sep-06 16:23

Nadia Monalisa

5-Sep-06 16:23

Hi Riazi,
Thanks for your support.
I am using SQL SERVER EVERYWHERE 2005, which is a latest mobile and desktop database solution from Microsoft released very recently in this year. This is actually SQL Server Mobile upgraded version. And this SQL Server Everywhere doesnot support TOP and ROWCOUNT keyword. So, I thought there might be some tehcnique to perform this similar task.

SQL SERVER EVERYWHERE 2005 : Web link[^]

Thanks and regards.

Re: SQL TOP Equivalen in SQL Server Everywhere 2005!!!

Farhan Noor Qureshi5-Sep-06 12:42

Farhan Noor Qureshi

5-Sep-06 12:42

Does this work?

Set ROWCOUNT @aNumber

Farhan Noor Qureshi

Re: SQL TOP Equivalen in SQL Server Everywhere 2005!!!

Nadia Monalisa5-Sep-06 16:22

Nadia Monalisa

5-Sep-06 16:22

Hi Farhan,
Thanks for your support.
I am using SQL SERVER EVERYWHERE 2005, which is a latest mobile and desktop database solution from Microsoft released very recently in this year. This is actually SQL Server Mobile upgraded version. And this SQL Server Everywhere doesnot support TOP and ROWCOUNT keyword. So, I thought there might be some tehcnique to perform this similar task.

Thanks and regards.

Moving a database from one server to another

KreativeKai5-Sep-06 7:20

KreativeKai

5-Sep-06 7:20

As with all computer technology there are usually many ways to perform one task.

At our shop we're new at the whole SQL database process. On our old apps with our mainframe we have test databases, we make changes and then copy the framework of the test database into production.

With SQL we have two servers. A development server and a production server. What is the best way to move a database from our development server with select tables and select stored procedures.

Does the backup / restore process lend itself to this kind of move or should we be researching into DTS?

I'm looking for suggestions from those of you who have worked with SQL databases for years and can guide newbies to the best solution you've found.

Any suggestions are welcome Smile | :)

Lost in the vast sea of .NET

Re: Moving a database from one server to another

Paul Conrad5-Sep-06 7:34

Paul Conrad

5-Sep-06 7:34

KreativeKai wrote:
What is the best way to move a database from our development server with select tables and select stored procedures.

One way would be to have sql scripts that create new tables / stored procedures and update altered tables / stored procedures. Run these scripts on the production server after you've tested on the development server.

I am sure there are other ways, but this is the first to come to my mind Smile | :)

That's no moon, it's a space station. - Obi-wan Kenobi

Re: Moving a database from one server to another

Not Active5-Sep-06 7:46

Not Active

5-Sep-06 7:46

Using the enterprise manager you could choose the copy database item from the context menu. This could be used to copy the database and create a script to be run for later updates.

only two letters away from being an asset

Re: Moving a database from one server to another

KreativeKai5-Sep-06 8:11

KreativeKai

5-Sep-06 8:11

Cool!!

That seems way to simple, but I tested it and it works great!!

Are there any drawbacks? Is it accurate creating the scripts or are there disadvantages to this method??

Thanks for your idea!!

Lost in the vast sea of .NET

Re: Moving a database from one server to another

Paul Conrad5-Sep-06 8:41

Paul Conrad

5-Sep-06 8:41

KreativeKai wrote:
Is it accurate creating the scripts or are there disadvantages to this method??

Use scripts unless you want to update any changes by hand.

That's no moon, it's a space station. - Obi-wan Kenobi

Re: Moving a database from one server to another

KreativeKai5-Sep-06 8:47

KreativeKai

5-Sep-06 8:47

I would rather use scripts than doing the work by hand. I just don't always trust Microsoft, so it always helps to ask if there are any drawbacks to using the scripts that you copy. Maybe I should be more trusting, but with Microsoft sometimes it is hard. Suspicious | :suss:

Lost in the vast sea of .NET

Re: Moving a database from one server to another

Paul Conrad5-Sep-06 8:59

Paul Conrad

5-Sep-06 8:59

KreativeKai wrote:
Maybe I should be more trusting, but with Microsoft sometimes it is hard.

I know that feeling.

KreativeKai wrote:
I would rather use scripts than doing the work by hand.

I think we all would rather do the scripts Smile | :)

When Enterprise Manager or SQL Server Management Studio Express generates the scripts, you can place comments into the script and this can serve as an audit point in the life cycle of the project. Always make a backup of the live data before running the scripts. I haven't had any serious trouble with running scripts whenever something is added/changed.

Paul

That's no moon, it's a space station. - Obi-wan Kenobi

Re: Moving a database from one server to another

KreativeKai5-Sep-06 9:05

KreativeKai

5-Sep-06 9:05

Thanks for your help!! Big Grin | :-D

Lost in the vast sea of .NET

Re: Moving a database from one server to another

Not Active5-Sep-06 8:47

Not Active

5-Sep-06 8:47

As long as you are just refreshing data from dev to prod this will work. As Paul says though if you change the schema you will either need to rerun the copy or modify the generated scripts.

only two letters away from being an asset

Re: Moving a database from one server to another

KreativeKai5-Sep-06 9:05

KreativeKai

5-Sep-06 9:05

Thanks for your help!! Big Grin | :-D

Lost in the vast sea of .NET

Cannot import Japanese text

VaibhavJ5-Sep-06 5:42

VaibhavJ

5-Sep-06 5:42

Hi all,

Currently I am working on importing data from SQL 2000 database to SQL
2005
database. The original SQL 2000 database contains Japanese as well as
English text. For importing data from SQL 2000 to SQL 2005 I have followed
following steps.

1. I have created SQL script for generating table structure in SQL 2005.
Which I executed and it created table structure in SQL 2005.
2. I have created SQL script for generating stored procedures in SQL 2005.
This was also successful.
3. Same way, I have created user defined functions in SQL 2005.
4. But the problem comes while importing data to SQL 2005.
For this I have done following things.

- Exported the data from SQL 2000 database to an excel sheet.and
- Import to SQL 2005 database which is causing problems. Frown | :(

There is no problem with importing data which is in English to SQL 2005.
But as we have to import Japanese text alongwith English, it is causing
problems.

* * * Error is * * *
"The character-string data type of the Unicode
form and the character-string data types of the form other than Unicode
cannot be converted by the row "Description".

So, I guess the problem is related to the importing of combination of
UNICODE and Non-Unicode data to SQL 2005.

So, please let me know if we can use some other alternatives for importing
of Japanese text to SQL 2005.

Any suggestion/solution from you on this issue is greatly appreciated.

Thanks in advance.

Thanks & regards,
Vaibhav

Re: Cannot import Japanese text

Member 965-Sep-06 6:49

Member 96

5-Sep-06 6:49

Hmmm..I have no idea if this is at all relevant, but it almost sounds as if you are using a form to do the import? Shouldn't you just be doing something akin to BCP or bulk copy or directly in code without involving a UI part at all?

Re: Cannot import Japanese text

VaibhavJ5-Sep-06 19:47

VaibhavJ

5-Sep-06 19:47

Hi John,

Thanks for your prompt reply. As per your suggestion I executed bcp command in the command prompt.

URL referred :
http://www.databasejournal.com/features/mssql/article.php/3391761

First I used following command to export data from source table in SQL 2000 database table to a .bcp file

[DatabaseName].dbo.[tablename] out c:\file1.bcp -n -S[servername] -U[username] -P[password]

Next I used following command to import data to the target table on SQL 2005
database

[DatabaseName].dbo.[tablename] out c:\file1.bcp -n -S[servername] -U[username] -P[password]

But it looks to me as if I need to write as many statements to export/import data for as many tables.

Anyway, thanks again for your valuable suggestions as it gave me right direction. Smile | :)

Thanks & regards,
Vaibhav

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.