CoolInterview.com - World's Largest Collection of Interview Questions
Send Free SMS
 Interview Questions  
 Our Services  


INTERVIEW QUESTIONS DATABASE SQL SERVER DETAILS
Question :
What is the difference between "translate" and "replace"?
Category SQL Server Interview Questions
Rating (0.0) By 0 users
Added on 4/3/2008
Views 611
Rate it!
Answers:

Replace replace every instence of character with character sting by the given charator of string. this work for entire word and pattern,.

Translate replace the one charecte at a time.Translating the nth character match with the nth character with the replacemnt string .





If you have the better answer, then send it to us. We will display your answer after the approval.
Name :*
Email Id :*
Answer :*
Verification Code Code Image - Please contact webmaster if you have problems seeing this image code Not readable? Load New Code
Process Verification  Enter the above shown code:*
Inform me about updated answers to this question

   
Related Questions
View Answer
How functional dependency is related to database table design?
View Answer
What is DYNAMIC SQL method ?
View Answer
What is the query used to display all tables names in SQL Server (Query analyzer)?
View Answer
What is the query used to display all tables names in SQL Server (Query analyzer)?
View Answer
What is a dirty page and dirty report?
View Answer
What are the new enhancements in SQL server 2005?
View Answer
Difference between a "where" clause and a "having" clause?
View Answer
Write sql query for retrieving employee names from employee table who are having salary greater than 5000 without using where clause?
View Answer
Explain real time situation where you would use clustered and Non-clustered Indexes?
View Answer
What is the pivot operator in MS SQL Server2005? What is the use of it and how do we use it
View Answer

Please Note: We keep on updating better answers to this site. Subscribe to our newsletter to get notified when better answer is posted.

Notify me when better answer is posted!
Email:

View ALL SQL Server Interview Questions

User Options
Sponsored Links


Copyright ©2003-2010 CoolInterview.com, All Rights Reserved.
Privacy Policy | Terms and Conditions
Page URL: http://www.coolinterview.com/interview/14966/default.asp?cachecommand=bypass


Download Yahoo Messenger | Placement Papers| FREE SMS | ASP .Net Tutorial | Web Hosting | Free SMS | Dedicated Servers | Joke of the Day

0.88