Jump to content


Check out our Community Blogs

shokosugi

Member Since 30 Oct 2008
Offline Last Active Dec 05 2008 10:50 PM
-----

Posts I've Made

In Topic: How to select all Foreign keys in a database

30 October 2008 - 09:37 PM

foreign keys? not sure i understand. but if you want to get all the "child" keys..you can use "IN" or "EXISTS" in your SQL.

you can also use MINUS.

In Topic: Native XML or SQL server?

30 October 2008 - 09:36 PM

SQL Server can generate XML.

SQL Server also has a way to search text field similar to Oracle Intermedia text.

In Topic: How to delete duplicate entries in a table ?

30 October 2008 - 09:35 PM

use DISTINCT

In Topic: a table convertion

30 October 2008 - 09:35 PM

you basically want to have multiple rows per language instead of multiple columns.

In Topic: new to SQL ..where do i start

30 October 2008 - 09:33 PM

get a Book or read some of the online tutorials on mysql/sql.

get SQLYog to help you administer/code.

mysql (.) org is a great start.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download