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?
2113how 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 16045What 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 9365how to get rank of diffrent student in same table based on newly inserted row in sql server2008
4 6539Post New ABC SQL Server Interview Questions
Explain the pointers in Java?
Which is better ascii or unicode?
What are the update types possible? : abap data dictionary
What is the use of marketing calendar?
What is sub- prime lending?
defult setting in p220 micom motor proction relay for 11kv,640kw,f.l.a.-40a,1440rpm ht motor?
What is the Work object?
What is the left table in sql?
Explain why retained earnings have an opportunity cost associated?
What is css wikipedia?
How does the system process SQL script?
What is the difference between function and stored procedure in sql server?
18). explain testing process in your organization? 19). are you participated in test plan preparation? 20). how will you prepare test cases? 21). explain importance of the priority in test case documents? 22). explain test execution process? 23). how much time will you take to write one test case? 24). how many test cases you can execute in a day? 25). explain bug life cycle? explain difference between seveority & priority?
What is a top level class in java?
Explain 'Net' module in Node.JS?