I have table name'temp' in that I wanted to add some partial da

Advertise your Business Here

Refer this Site

Login | Sign Up


	Ask Questions on ANYTHING, that arise in your Daily Life at FORUM9.COM

Categories >> ERRORS >> Database Errors >> SQLServer Errors

Oracle Errors Interview Questions

SQLServer Errors Interview Questions

MySQL Errors Interview Questions

Question

I have table name'temp' 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 
like'R-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?

Question Submitted By :: Indu

I also faced this Question!!

Rank

Answer Posted By

Re: I have table name'temp' 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 like'R-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?

Answer
# 1

I this you are referring to excel.
You may use "concatanate" function for 
Combining two coloumns in to a new coloumn
Pl try and tell.

Is This Answer Correct ?

0 Yes

2 No

Sreeindia111
[Mirc Electronics Limited]

Question	Asked @	Answers
Other SQLServer Errors Interview Questions


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?		4
I am experiencing an error failed to retrieve data from data base. it is an oracle table. Is there a limit on the number of fields that can be a report. My table has 321 fields and I do not have all of them in the report yet.		1
what is meant by write off and write on in sap?	Wipro	4
WHAT IS HTTP 500 Internal Server Error? CAN I SOLVE THIS?		4
I have table name'temp' 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 like'R-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?	Syncfusion	1

For more SQLServer Errors Interview Questions Click Here


Copyright Policy \| Terms of Service \| Help \| Site Map 1 \| Articles \| Site Map \| Site Map \| Contact Us \|

Copyright © 2007 ALLInterview.com. All Rights Reserved.

ALLInterview.com :: Forum9.com :: KalAajKal.com