Explain the role of replication server in sybase.

930

Where the sql logs gets stored? : sql server database administration

1023

> CREATE OR REPLACE FUNCTION FACTORIAL_1(factstr varchar2 ) 2 RETURN NUMBER AS 3 new_str VARCHAR2(4000) := factstr||'*' ; 4 fact number := 1 ; 5 BEGIN 6 7 WHILE new_str IS NOT NULL 8 LOOP 9 fact := fact * TO_NUMBER(SUBSTR(new_str,1,INSTR(new_str,'*')-1)); 10 new_str := substr( new_str,INSTR(new_str,'*')+1); 11 END LOOP; 12 13 RETURN fact; 14 15 END; explanation Above program?

2103

How to delete duplicate rows in sql server?

1159

What is the difference between NOROW and LOCKROW?

2912

Why we use join in sql?

1035

Explain the select statement in sql?

1198

What do you understand by unique key?

1035

What is a trace frag? Where do we use it?

1160

What if we write return in procedure?

1530

How to get a list of columns using the "sys.columns" view in ms sql server?

1016

How do I connect to pgadmin server?

995

What is Normalization and its different forms?

1105

What happens if null values are involved in comparison operations?

1051

What is a mysql model?

1009