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 11485Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?
2442Please 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 7647Suppose 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 7976Post New Value Labs SQL Server Interview Questions
What is ajaxcontrol toolkit?
What are the four basic parameters of a mapper?
Is it possible to create multiple VM's (more than 15) per day. How can you handle it
What does [::-1} do?
What are the governing principles under "reasonable accommodation"?
How do I password protect an entire wordpress site?
What is DECR And for wt it is used?
Consider multiple inheritances here. Suppose class c inherits from classes a and b as class c(a,b). Classes a and b both have their own versions of method func(). If we call func() from an object of class c, which version gets invoked?
What is a single point of failure in Hadoop 1 and how is it resolved in Hadoop 2?
What is payroll process in sap?
tell me the setting database configuration.
what is meant by tranformer impedance?
How to add the partition in existing table without the partition table?
How do I use void main?
What is a currency factoring technique?