Suppose I have table nametemp in that I wanted to add some partial data for a particular column name policyno where data is existing in that column. Ex.Policyno like R-KT-SK-EA-134526 like 100 records. In that 100 records some policynos are just like 134527 I mean with out prefix likeR-KT-SK-EA- now I wanted add this prefix as R-KT-SK-EA-134527 for some 50 records. How can I add partial data?
Submitted by: AdministratorUPDATE temp SET = REPLACE(Policyno,'134527','R-KT-SK-EA-134527') WHERE Policyno = '134527'
UPDATE temp SET = 'R-KT-SK-EA'+ Policyno WHERE Policyno = '134527'
UPDATE temp SET = 'R-KT-SK-EA'+ Policyno WHERE policyno not like 'R-KT-SK-EA-%'
Submitted by: Administrator
UPDATE temp SET = 'R-KT-SK-EA'+ Policyno WHERE Policyno = '134527'
UPDATE temp SET = 'R-KT-SK-EA'+ Policyno WHERE policyno not like 'R-KT-SK-EA-%'
Submitted by: Administrator
Read Online SQL Server Errors Job Interview Questions And Answers
Top SQL Server Errors Questions
☺ | What is sqlcode -922 & -923? |
☺ | What will be the program output if it tries to access 11th item in an array of 10 and it is coded with NOSSRANGE? |
☺ | In one table there is 10 records without id num, without primary key and it is not sorted then how to extract last 6 record from table? |
☺ | How to solve "The SQL Server service failed to start. For more information, see the SQL Server Books Online topics" error? |
☺ | What is meant by write off and write on in sap? |
Top Exception Handling Categories
☺ | ERRORS Interview Questions. |
☺ | Scripts Errors Interview Questions. |
☺ | Oracle Errors Interview Questions. |
☺ | C C++ Errors Interview Questions. |
☺ | DotNet Errors Interview Questions. |