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?
2536how 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 17685What 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 11068how to get rank of diffrent student in same table based on newly inserted row in sql server2008
4 8021Post New ABC SQL Server Interview Questions
What is the difference between is null & is not null?
On what basis a to will get generated?
how can I verify that a custom injection filter is working?
Does the WIC support QoS?
How frequent the STP information will be exchanged
What are the potential shortcomings of marketing analysis? How do you overcome them?
How will you design or modify schema in hbase programmatically?
How do I enable the taskbar?
one time reffer ur books/(if ur technical students)
What is ngzone service in angular?
what happens if null values are involved in expressions? : Sql dba
What is your edge among others who are applying here?
Write a note on encapsulation?
Tell me one scenario, the complex functionality you have automated in your project?
Explain the different types of backups available in sql server? : sql server database administration