Database Discussion Boards

First Prev Next

Sqlserver -gui ?

kaiowa5114-Jan-05 8:39

kaiowa51

14-Jan-05 8:39

Hi,anyone know if there exists a sql-server database gui for linux?

I have searched but nothing free found.

DataTable with nested Child Tables??

work_to_live13-Jan-05 8:09

work_to_live

13-Jan-05 8:09

Let's assume I have three tables, where Table1 is the topmost table, Table2 is a child relation to Table1 and Table3 is a child relation to Table2. I'd like to get all rows in Table1 where a column in Table3 is a particular value. This is fairly straight forward with an SQL query, but I can't figure out how to do it with DataTables/DataSets. Any suggestions?

The only solution I've been able to come up with involves getting every row in Table1, and then GetChildRows twice to get to Table3, and testing the column of interest in Table3...

foreach (DataRow row in Table1.Rows)
{
if (row.GetChildRows("Table1-Table2")[0].GetChildRows("Table2-Table3")[0]["ColumnOfInterest"] == something)
{
This is one of the desired rows, do something with it
}
}

Seems very cumbersomb. You'd think there'd be a way to execute a single "query" that would return the desired set of rows...

Re: DataTable with nested Child Tables??

Rob Graham13-Jan-05 16:09

Rob Graham

13-Jan-05 16:09

How about reversing the process, and preselecting just the columns of interest

DataRow[] interestingRows = Table3.Select("columnOfInterest = something");
foreach(DataRow r1 in interestingRows)
{
DataRow r2 = r1.GetParentRow("Tabel2-Table3").GetParentRow("Table1-Table2");
// do something with this if not null
}

Anger is the most impotent of passions. It effects nothing it goes about, and hurts the one who is possessed by it more than the one against whom it is directed.
Carl Sandburg

Re: DataTable with nested Child Tables??

work_to_live14-Jan-05 4:56

work_to_live

14-Jan-05 4:56

Thanks... That would definitely do the trick, and I'll play around with it, but to my question, is there some way to perform this operation with a single Select "like" call? Maybe there isn't a way to do this, and that's fine, I'll continue working with nested foreach constructs, but I keep thinking the disconnected DataSet should be able to perform operations that are possible with SQL. As I'm sure you're aware, the SQL equilalent of what I'm trying to do with the DataSet is as follows...

SELECT * FROM TABLE1,TABLE2,TABLE3 WHERE TABLE1.Table2Link=TABLE2.Table1Link AND TABLE2.Table3Link=TABLE3.Table2Link AND TABLE3.ColumnOfInterest=something

Database schema

webhay13-Jan-05 1:15

webhay

13-Jan-05 1:15

Hello all,

I made a database in my server but when i generat a script for this database and run it in another server the Digram dosnt apper in the second server.How can if i change relation in the first digarm make this changes in the second database

note: the database filled with some data

hay

Re: Database schema

Colin Angus Mackay13-Jan-05 11:46

Colin Angus Mackay

13-Jan-05 11:46

webhay wrote:
I made a database in my server but when i generat a script for this database and run it in another server the Digram dosnt apper in the second server

The diagrams are not scripted as they will change dynamically with the data model in the database. The diagrams are just a graphical representation of the tables in the database and their relationships.

webhay wrote:
How can if i change relation in the first digarm make this changes in the second database

Script the change. Don't use Enterprise manager - learn how to make these changes in script so you can test the changes on a development server, make sure that they work without breaking the database, then apply the script (after fixing any bugs) to the live system.

Generally it is a good idea to take a backup of the live system and restore the backup on a development box to test your change-script on so that the development environment is as close to the live system as possible.

Does this help?

Do you want to know more?
WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and Forums

Upcoming talk:
SELECT UserName, Password FROM Users
-- Getting unauthorised access to a SQL Server, and how to prevent it.

i couldn't see Databases in SQL server

BSRK13-Jan-05 0:17

BSRK

13-Jan-05 0:17

I am working on Windows 2000 professional. I have installed MSDE 2000 and also SQL server 2000 (Client components only).

But when i go through the Enterprise Manager of SQL Server, it is not identifying any server. It is displaying something like:
Server is not found or Access denied. Connection Open

when i tried to run in command prompt also (C:/>osql ....) it is saying connection open error.

can anyone please help?
thank you

Re: i couldn't see Databases in SQL server

Colin Angus Mackay13-Jan-05 1:02

Colin Angus Mackay

13-Jan-05 1:02

BSRK wrote:
Server is not found or Access denied

A couple of things to check:

Is the SQL Server service running?

Are you connecting with the correct user namd and password?

Do you want to know more?
WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and Forums

Upcoming talk:
SELECT UserName, Password FROM Users
-- Getting unauthorised access to a SQL Server, and how to prevent it.

Re: i couldn't see Databases in SQL server

BSRK13-Jan-05 1:28

BSRK

13-Jan-05 1:28

I have checked from Administrative Tools -> Services, that sQL server service is running.
still i have this problem.

Can you tell me whether i need to install service pack SP3a in addition with MSDE 2000?

Re: i couldn't see Databases in SQL server

Colin Angus Mackay13-Jan-05 2:07

Colin Angus Mackay

13-Jan-05 2:07

BSRK wrote:
Can you tell me whether i need to install service pack SP3a in addition with MSDE 2000?

Installing Service Pack 3a is generally a good idea anyway because, IIRC, it contains the security fix for the Slammer worm.

BSRK wrote:
I have checked from Administrative Tools -> Services, that sQL server service is running.

So, are you attempting to log in using the correct credentials? Have you typed the user name and password correctly? Did you set it to use Windows Authentication? and if yes, are you trying to connect using the same account that it was installed with (or with an account that has been granted access)?

Do you want to know more?
WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and Forums

Upcoming talk:
SELECT UserName, Password FROM Users
-- Getting unauthorised access to a SQL Server, and how to prevent it.

we cannot use MSDE & Enterprise Manager

BSRK13-Jan-05 2:39

BSRK

13-Jan-05 2:39

I think we cannot use MSDE & Enterprise Manager in conjunction. i got similar info from the below link.

http://communities2.microsoft.com/communities/newsgroups/en-us/default.aspx?&query=FAQ&lang=en&cr=US&guid=&sloc=en-us&dg=microsoft.public.sqlserver.msde&p=1&tid=2b4fe8b6-3d8d-4353-8f91-31c0f60bba14[^]

Re: we cannot use MSDE & Enterprise Manager

Colin Angus Mackay13-Jan-05 2:48

Colin Angus Mackay

13-Jan-05 2:48

BSRK wrote:
I think we cannot use MSDE & Enterprise Manager in conjunction

Curious - I've never had a problem combining using Enterprise Manager with an MSDE database.

Do you want to know more?
WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and Forums

Upcoming talk:
SELECT UserName, Password FROM Users
-- Getting unauthorised access to a SQL Server, and how to prevent it.

Re: we cannot use MSDE & Enterprise Manager

Michael P Butler13-Jan-05 8:42

Michael P Butler

13-Jan-05 8:42

MSDE and Enterprise manager work fine together. There is a grey area when it comes to the licencing of the software. But there is no technical reason why Enterprise Manager can't see your MSDE database.

Michael

CP Blog [^] Development Blog [^]

Re: i couldn't see Databases in SQL server

Mike Dimmick14-Jan-05 0:42

Mike Dimmick

14-Jan-05 0:42

A new installation of MSDE is configured in Windows Authentication mode. You must use a trusted connection (e.g. osql -E) to connect to it. If you want to be able to supply a username and password you will need to reconfigure for mixed mode.

If you downloaded MSDE recently, you will have MSDE Release A. If you accept the default install parameters, this version of MSDE disables all networking protocols. You can only access it from the machine it's installed on, using the Shared Memory protocol. Follow the instructions in KB 814130[^] to re-enable network access.

Stability. What an interesting concept. -- Chris Maunder

How To connect to MySql database from JAva

Aakash Jain12-Jan-05 18:28

Aakash Jain

12-Jan-05 18:28

Please tell me how to connect to a MySql Database and also explain the classpath requisites.

Re: How To connect to MySql database from JAva

David Salter13-Jan-05 22:26

David Salter

13-Jan-05 22:26

http://dev.mysql.com/doc/connector/j/en/index.html[^]

Store your favourite bookmarks online: my-faves.co.uk

select

webhay12-Jan-05 10:11

webhay

12-Jan-05 10:11

Hello all,

I have 4 tables the first table contain IDs from the other 3 tables. I need to Select the names from the other tables by the IDs in the first table

1- tbl
1|2|4

2- tbl
1|manager

3-tbl
2|Desgined

4-tble
4|Computer

please help

Thanks
hay

Re: select

Colin Angus Mackay12-Jan-05 22:58

Colin Angus Mackay

12-Jan-05 22:58

SELECT table2.name, table3.name, table4.name
FROM table1
INNER JOIN table2 ON table1.id2=table2.id
INNER JOIN table3 ON table1.id3=table3.id 
INNER JOIN table4 ON table1.id4=table4.id

As you have not provided table and column names I have named the tables after their number as in your example. In table1 the columns id2, id3 and id4 represent foreign keys to table2, table3 and table4 respectively.

Does this help?

Do you want to know more?
WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and Forums

Upcoming talk:
SELECT UserName, Password FROM Users
-- Getting unauthorised access to a SQL Server, and how to prevent it.

Re: select

webhay12-Jan-05 23:40

webhay

12-Jan-05 23:40

Thanks Colin ,

It is working but it give me duplicate recorder is there is a way to avoid duplicate.

Thanks for your time.

hay

Re: select

Colin Angus Mackay12-Jan-05 23:48

Colin Angus Mackay

12-Jan-05 23:48

SELECT DISTINCT....

Do you want to know more?
WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and Forums

Upcoming talk:
SELECT UserName, Password FROM Users
-- Getting unauthorised access to a SQL Server, and how to prevent it.

SQL ToTitleCase Script

Jason Weibel12-Jan-05 7:50

Jason Weibel

12-Jan-05 7:50

I need to update a field so the values change from all upper case to title case. Can anyone please point me to a sql script example of how to do this. Thanks,

Jason W.

Re: SQL ToTitleCase Script

Ritesh123413-Jan-05 3:53

Ritesh1234

13-Jan-05 3:53

Hi,

U can use...............

UPDATE Customer
SET
C_Name = LOWER(C_Name)

I hope this will help u..........:->

Regards,
Ritesh

Re: SQL ToTitleCase Script

Jason Weibel13-Jan-05 4:18

Jason Weibel

13-Jan-05 4:18

Thanks for the try, but that won't work. Lower gives the following results:

Select lower('TEST')<br />
---- <br />
test

The following would work if there was only one word:

Select upper(left('TEST',1)) + lower(substring('TEST', 2, len('TEST')))<br />
----- <br />
Test

Problem is when you have more then one word such as:

DECLARE @TEST as varchar(50)<br />
SET @TEST = 'TEST TEST TEST'<br />
Select upper(left(@TEST,1)) + lower(substring(@TEST, 2, len(@TEST)))<br />
--------------------------------------------------- <br />
Test test test

The results I want are
---------------------------------------------------
Test Test Test

Any idea on how to output this format?
Thanks again.

Jason W.

Re: SQL ToTitleCase Script

Ritesh123413-Jan-05 22:40

Ritesh1234

13-Jan-05 22:40

Hi,
In that case u have to write ur own logic...........
Here is my idea.............

1>Loop through ur string and separate our the substring till u get Space.
2>Then apply ur logic which u shown for this word and append it with @Result.
3>COntinue with ur loop till u get Next substring(word) use step 2 and append it to the @Result with Space
4>Continue till the length of Entire String......................

u might be having better logic...................:->

Regards,
Ritesh

Exporting DataGrid to Excel

janigorse11-Jan-05 20:49

janigorse

11-Jan-05 20:49

Hello!

Is it posible to export DataGrid (not DataSet!) to Excel? If it is, how?
I can't find any exapamle on net...

Last Visit: 31-Dec-99 18:00 Last Update: 29-Apr-24 8:59

Refresh

ᐊ Prev 1...2158 2159 2160 216121622163 2164 2165 2166 2167 Next ᐅ

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