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 12060Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?
2552Please 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 7979Suppose 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 8289Post New Value Labs SQL Server Interview Questions
What are the components of powerpoint?
how many ways can you deploy applications in websphere?
How we can create index in mysql?
How can the contents of a file inside jar be read without extracting in a shell script?
Define mutex in C#?
What are the differences between echo and print?
What is the basic difference between pledge, hypothication and mortgage????
What is the pay scale structure?
What is a wrapper div?
What is mvcc in postgresql?
What is the advantage of doing scrum?
Which f key to restore windows 7?
What procedure import workflow in maximo 7.1
List out different types of splunk licenses?
What is the task of the pre-processor?