I have a table in which phno is one of the columns.i do have some values in tht phno column.i need to update phno column values with 0(zero) as prefix.give me a correct solution plz...
7 11830Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?
2504Please give me the SP for the below scenario. I have two tables named Table1 and Table2...I need to fetch record by record from Table1 and insert the record in to table2 where the value in the sno column of the table1 is even number.
4 7837Suppose i have one sql query that contains 2 minute to execute.After one weekly i am executing same query that is taking 5 minute.Why our same query is taking more time.what would be my approach to reduce execution time.Please help.
1 8143Post New Value Labs SQL Server Interview Questions
What is instrumentation instrumentation engineering?
What is a simple table?
What are 3 operating systems?
Why is sorting important?
What is a Silverlight.js file?
Is there any function that can skip certain number of characters present in the input stream?
Mention what is the difference between instance recovery and crash recovery?
How to create an XSLT style sheet to format Data?
Explain what are the hydrocarbons?
What is sterilization and disinfection?
What is the "500 internal server error"?
When is finally block not called?
What are formatting styles?
Enlist the various relationships of database.
What types of I/O have you designed? What were their size? Speed? Configuration? Voltage requirements?