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 9654Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?
2080Please 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 6407Suppose 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 7271Post New Value Labs SQL Server Interview Questions
What are the types of remoting?
Explain the fundamental difference between xpath and css selector.
Explain the function done by data manager?
Explain Routed events in WPF?
What do you mean by implicit parameters?
List the advantages that web services have over com (component object model)and dcom (distributed component object model)?
Why you go so less percentage in X and XII in comparison to your B.Tech degree?
What is the command used to check locks in microsoft sql server?
what is the bond code in materialized view?
what is the meaning of ssrange and nossrange?
Define Composition.
How to expose aggregate property?
what are the common Problems with printing, preview and paper size in Quick Reports?
What is difference between lookup and vlookup?
This entry was posted in General. Bookmark the permalink. Post a comment or leave