how to update a null value field in sql server
eg
a table contains 3 fields id,name,salary
and 3 records
salary of 1 record is null
i want update the nullfield
111 arun 300
112 ddd 200
113 ttt null
i want to update table with add 100 to every record include null
after updation
the recrds should be
111 arun 400
112 ddd 300
113 ttt 100
I have a frame that contains headings. This frame is
enclosed in side a repeating frame. However the headings
are not displayed on all pages it is displayed only on the
last page. Please let me know why is this happening.
print object on = All pages
base printing on = enclosing object
i have a repeating frame that prints on every page for a
product code.
But when on page ends the info associated with that product
code is truncated and not overflowed to the next page.On
the next page data with the new product code is displayed.
I want the data for one product code to be continued on the
next page if it does not fit on a single page.
The values are as:
repeating frame
vertical = variable
horizontal = variable
page protect = 0
print object on = first page
base printing on = enclosing object
for the outermost frame which encloses the repeating frame:
print object on = last page
base printing on = anchoring object
end of layout section = yes
rest all the values are same as the repeating frame
when u import an excel file into sql if suppose one column
has got a date field with system time attached to it what
data type u will use in sql to import it in a table?
Note: a condition is the excel file has no primary key
defined to a column...also u r importing bulk data into sql
hi, how can i check all backups are exist to restore? I.e.
i forget to take backup on one day. But now i want to check
that all backups are there to restore now. I know the
answer of through timestamps we know how to check. But i
need any other way?
In what script is "snap$" created? In what script is the
"scott/tiger" schema created?
9
1. Using the XML Document below, with the URI “recipe.xml”
define
the following queries in XQuery:
a.) Give the names of all breakfast in the menu.
b.) Select breakfasts that have price lower than $7.00?
<?xml version="1.0"?>
<breakfast_menu>
<food>
<name>Belgian Waffles</name>
<price>$5.95</price>
<description>
two of our famous Belgian Waffles with plenty of real
maple syrup
</description>
<calories>650</calories>
</food>
<food>
<name>Strawberry Belgian Waffles</name>
<price>$7.95</price>
<description>
light Belgian waffles covered with strawberries and
whipped cream
</description>
<calories>900</calories>
</food>
<food>
<name>Berry-Berry Belgian Waffles</name>
<price>$8.95</price>
<description>
light Belgian waffles covered with an assortment of
fresh berries and whipped cream
</description>
<calories>900</calories>
</food>
<food>
<name>French Toast</name>
<price>$4.50</price>
<description>
thick slices made from our homemade sourdough bread
</description>
<calories>600</calories>
</food>
<food>
<name>Homestyle Breakfast</name>
<price>$6.95</price>
<description>
two eggs, bacon or sausage, toast, and our
ever-popular hash browns
</description>
<calories>950</calories>
</food>
</breakfast_menu>
188
By using Macromedia Director How to fetch the data from
Microsoft Excel?
158
I am Bsc Computer Science Graduate, I have good knowledge
in SQL 7.0, Can I go for Oracle APPS course please suggest
me the answer
168
What is the difference between referencing and joining?
198
how to pass 2 variables from one form to other form
67
Q1:code to connect to sql server(database) through jdbc
application.
Q2:code to connect to Mysql(database) through jdbc application.
Q3:code to connect to oracle(database) through jdbc application.
141
i have table as source table and flat file as target
i need yo perform some logic in loading the data.
is it posible?
and one more thing the no of fields in source is 200+
and for target is 30+
how i can map them.........
47
while creating requisitions i am unable to see the list of
organisation can anyone help me out ?
127
Write about Transaction Management in Oracle 9i?
199
How much memory that we are using in Logshipping Concept?
34
what is the scenario where you take the database to
NoArchivelog mode?
111
What do the 9i dbms_standard.sql_txt() and
dbms_standard.sql_text() procedures do?
5
where can i free download sqlserver2008..i can install
sqlserver2008 without visual studio 2008 and work on it
129
What is DB Development software?
165
> 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?
62
CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?
94
how the indexes are stored in the Oracle Database?
Assuming today is Monday, how would you use the DBMS_JOB
package to schedule the execution of a given procedure owned
by SCOTT to start Wednesday at 9AM and to run subsequently
every other day at 2AM.
Site Map
