|
No,Temporary table is not compulsory.It can be deleted without craeting temporary table by using ROW....
|
|
|
|
SQL Job is set of specified operations set on server to be performed sequentially and automatically.....
|
|
|
|
Yes, it is possible to create a Primary ke and unique key on computed columns. In case of Unique key....
|
|
|
|
Serialization is the highest level of isolation. When Serialization is implemented then there will b....
|
|
|
|
select Pname
from sales
group by PID
having sum(sale)=130
|
|