if we give update table_name set column_name= default.
what will happen?
Answers were Sorted based on User's Feedback
It Will update NULL to the column. In SQL, while
inserting and updating if you are assigning a column value
as DEFAULT keyword without single or doubled quote it will
take NULL automatically.
Is This Answer Correct ? | 6 Yes | 0 No |
Answer / akki julak
if you gave a default value for that column
then it takes that default value
otherwise it takes NULL
Is This Answer Correct ? | 7 Yes | 2 No |
Answer / meher
If any default value have been declare to that column when
creating the table then the defaul value will be updated.
Otherwise the column will be update by NULL.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / kolla radha sri seshu
In SQL you will get the message 'X' rows updated
In PL / SQL you will get the message pl / sql procedure
sucessfully completed
Is This Answer Correct ? | 0 Yes | 3 No |
What is partition by in sql?
i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5
What is sql scripting?
what are the difference between clustered and a non-clustered index? : Sql dba
Is sql better than access?
What is denormalization in a database?
If I have a table T with 4 rows & 2 columns A & B. A has values 1,2,3,4. and B has 10,20,30,40. Write an Update SQL query which can Swap the values of A & B for all records. (Do not use a sub-query)
What is a merge query?
what are the types of join and explain each? : Sql dba
Explain what is a view?
How many null values can be inserted in a coulmn whihc is unique constraint
From an Employee table, how will you display the record which has a maximum salary?
29 Answers Cap Gemini, Exilant, Synechron,