.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan

Home >> Interview Question >> Sql Server >> Post New Question Subscribe to Interview Questions

What are the Text and Image Functions?

Posted By :nishithraj     Posted Date :December 24, 2009    Points :10   Category :Sql Server 
PATINDEX,TEXTPTR,TEXTVALID are the Text and Image Functions

You can also find related Interview Question to What are the Text and Image Functions?  below: 

Does VS.NET support line numbering in its text editor?

  
Yes, from the standard toolbar select Tools | Options.This will open the Options dialog; select the Text Editor folder, pick the language, and click on the check box for line numbering under the display section. (More...)

Is there a way to set the tab size in the text editor?

  
Yes, from the standard tool bar select Tools | Options.This will open the Options dialog; select the Text Editor folder, choose a language folder, select Tabs, and set them to your desired setting. (More...)

Where is image data loaded into ImageList controls actually stored in the project?

  
Each form has an associated resource file (with a .resx extension) where image data and localized strings are stored.You can see this by clicking the Show All Files icon in the Solution Explorer. (More...)

I have an image and want to nine more exact images, How can I get copied images from this image?

  
In straight way you can't create a subimage from an existing image. Here you just clip an image, Clipping is just different from Cropping. In clipping, first you have to dictate which part of the images to draw and later you have to remove all but the desired part of the image. Silverlight does not support cropping. (More...)

What's the advantage of using System.Text.StringBuilder over System.String?

  
StringBuilder is more efficient in the cases, where a lot of manipulation is done to the text. Strings are immutable, so each time it's being operated on, a new instance is created. (More...)

Which of the following is a fixed length DataType?
1)CHAR
2)VARCHAR
3)TEXT

  
1)CHAR
CHAR Data type is used when the column lenght is known (More...)

How many ways you can display text using Silverlight?

  
Silverlight supports displaying static pre formatted text that is comprised out of glyph elements and also dynamic text that uses TextBlock. With glyphs, one needs to position the characters individually while TextBlock supports simple layout. (More...)

I was trying to use an "out int" parameter in one of my functions. How should I declare the variable that I am passing to it?

  
You should declare the variable as an int, but when you pass it in you must specify it as 'out', like the following: int i; foo(out i); where foo is declared as follows: [return-type] foo(out int o) { } (More...)

Explain about the Boolean functions present in Javascript?

  
Three Boolean operators are present in Javascript they are
1) &&
2) II
3) /
All the operators are regarded as true unless the Javascript regards them as false. You can define these operators to make as statement false number0, null, undefined, or a string of length 0, etc. Boolean function performs these conversions explicitly. (More...)

Tell me some String Functions?

  
SUBSTRING, SOUNDEX, DIFFERENCE (More...)

Tell me some Aggregate Functions?

  
BINARY_CHECKSUM
CHECKSUM
Count
Sum
AVG (More...)

What is the maximum size of data we can store in the image type of SQL?

  
We can store binary data from 0 to 2^31-1 (2,147,483,647) bytes in an image field of SQL Server. (More...)

Which function is used to perform a full text search on a column?

  
FREETEXT function can perform a full text search on the specified column.

FREETEXT({column/*}, search-string)


It will return the rows with columns that match the search-string. It matches the meaning only not the exact value of the search-string. (More...)

Quick Links For Interview Questions Categories:
ASP.Net Windows Application   .NET Framework   C#   VB.Net   ADO.Net  
Sql Server   SharePoint   Silverlight   OOPs   JQuery   JavaScript/VBScript
Biztalk Patten/Practices .IIS WCF WPF WWF
Networking Aptitude Others   All      

Find questions, FAQ's and their answers related to .NET, C#, Vb.Net, Sql Server and many more.

 
Now you can find lots of .NET, C#, Vb.Net, SQL Server,Windows, ASP.Net related Questions and their Answers here at www.dotnetspark.com. Our aim is to help you pass your certification Exams (MCP, MCSD, MCAD etc.,) with flying scores and get good name in your company.

So, Start looking our Interview Question section daily and improve your .NET Skills. You can also help others by posting Interview Questions and their Answers in this section.


Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend