How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?
1312how 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
6 13017What is the difference between in and exists. Ex: select * from emp where empno in(....) and select * from emp where empno exists(....) What is the difference between a Join and Union and Union and UnionAll.
5 6754how to get rank of diffrent student in same table based on newly inserted row in sql server2008
4 4604Post New ABC SQL Server Interview Questions
how to determine the correctness of proportion used in cement mortor and various IS codes to determine the same?
why u have choosen finance has a specialisation
acb(AIR CIRCUIT BREAKER)NOT CHARGING AUTO
Hi, i run scripts in one machine those r passed.when i run the scripts in client side those r failed.Give me such a scenario when ever u faced?
How to Save and load metafiles in a BLOB field without using DBImage ?
how to calculate
What are the causes of positive and negative propeller slip?
How to properly prepare glycyrrhizic acid solution ?
what is differred tax liability? explain in detail with some example.
If the emphasis in PeopleSoft 8 is the internet, why do we still need windows client?
Gave a cantilever beam with 3 legs.Told to draw the bending moment diagrams, axial force diagrams and shear force diagrams.From BMD he asked to show how the reinforcement will be provided on the tension side.
.In languages testing, what is the fixed part and changing part?
How to generate combined challan of pf?
what is payment method?How many payment method we can assign to company code.
Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)