SQL 101

[darkwing]

---

unsay d sql?

[test_user]

naa ba association sa d sql? kanang ang usa ka column sa usa ka table associated sa usa ka column sa laing table. naa? nya nsaon na cya?

Use JOIN in your SQL statement.

Example:
Table1
Fields: sample_field1,samplefield2..

Table2
Fields: sample_field1,fieldX,fieldY

declare sample_field1 of table1 as primarykey
sample_field1 of table2 is Foreign key

Sample Query:
Select * from table1 inner join table2 on table1.samplefield1 = table2.samplefiled2

more about JOIN: http://www.w3schools.com/sql/sql_join.asp

[dodie]

sheeshhhhh................................



set serveroutput on
set verify off
DECLARE
CURSOR emp_cursor is
SELECT *
FROM emp;
emp_record emp_cursor%ROWTYPE;
BEGIN
OPEN emp_cursor;
LOOP
FETCH emp_cursor INTO emp_record;
DBMS_OUTPUT.PUT_LINE(emp_record.empno||' '||emp_record.ename||' '||emp_record.hiredate||' '||emp_record.sal);
EXIT WHEN emp_cursor%ROWCOUNT >=14;
END LOOP;
CLOSE emp_cursor;
END;
/
--------------------------------------------------
set serveroutput on
set verify off
accept p_ask prompt 'Tag-ana kinsa ko: '
DECLARE
v_ask varchar2(10) := '&p_ask';
v_name varchar2(10):= 'DODIE';
BEGIN
if v_ask = v_name THEN
DBMS_OUTPUT.PUT_LINE(' CORRECT !!!!!!') ;
else
DBMS_OUTPUT.PUT_LINE(' SAYOP KA!!!!');
END IF;
END;
/

[mason]

guys, maka download bata aning mssql?

[jamesk]

favorite SQL statement:

> select * from IT_bosses where IQ>50;

Empty set (0.00 sec)


Jok-jok lang ha... bato bato sa langit...

[biggie9385]

dili ka kadownload og mssql but ang msde (desktop edition) pwede. i think ang msde wala lang enterprise manager og query analyzer

[simoncpu]

guys, maka download bata aning mssql?

You can, however, download PostgreSQL at http://www.postgresql.org/, and MySQL at http://www.mysql.com.

[ simon.cpu ]

[digitalsuperman]

guys, maka download bata aning mssql?

yep i guess you can.MS SQL Server 2005 Express Edition is downloadable.

[dacky]

sheeshhhhh................................



set serveroutput on
set verify off
DECLARE
CURSOR emp_cursor is
SELECT *
FROM emp;
emp_record emp_cursor%ROWTYPE;
BEGIN
OPEN emp_cursor;
LOOP
FETCH emp_cursor INTO emp_record;
DBMS_OUTPUT.PUT_LINE(emp_record.empno||' '||emp_record.ename||' '||emp_record.hiredate||' '||emp_record.sal);
EXIT WHEN emp_cursor%ROWCOUNT >=14;
END LOOP;
CLOSE emp_cursor;
END;
/
--------------------------------------------------
set serveroutput on
set verify off
accept p_ask prompt 'Tag-ana kinsa ko: '
DECLARE
v_ask varchar2(10) := '&p_ask';
v_name varchar2(10):= 'DODIE';
BEGIN
if v_ask = v_name THEN
DBMS_OUTPUT.PUT_LINE(' CORRECT !!!!!!') ;
else
DBMS_OUTPUT.PUT_LINE(' SAYOP KA!!!!');
END IF;
END;
/

dude kabaw ka migrate data from AS400 to MSSQL SERVER 2000? or anyone here?? tnx

[bisdakgyud]

Why not just copy your data to a text file with delimiters then copy it to your other database. This was how we did it with a legacy system and moving it to a sybase server using bcp command.