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

Top 5 Contributors of the Month
david stephan
Gaurav Pal

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

What keyword does an SQL SELECT statement use for a string search?

Posted By :Narayanan     Posted Date :September 28, 2011    Points :40   Category :Sql Server 
The LIKE keyword allows for string searches. The % sign is used as a wildcard.

You can also find related Interview Question to What keyword does an SQL SELECT statement use for a string search?  below: 

Difference between Set and Select keyword in sql server?


1.Set is a ANSI standard for variable assignment.
2.We can assign only one variable at a time
3.When assigning from a query that returns more than one value, SET will fail with an error.


1.Select is a Non-ANSI standard when assigning variables.
2.We can assign multiple variable at a time
3.When assigning from a query that returns more than one value, SELECT will assign the last value returned by the query and hide the fact that the query returned (More...)

Consider the following code:

public class Example extends Thread
public void run()
System.out.println ("Hello");

public static void main (String args[])
new Example();

Select the correct option regarding the preceding code ?

1, The code will not compile.
2, The code will compile but will not execute.
3, The code will compile, execute, and display Hello as the output.
4, The code will compile, execute, but will not display anything.

Answer : 4 (More...)

Select the correct statement that sets the priority of a thread among a group of threads to maximum.

1, threadObj.getPriority(THREAD.MAX_PRIORITY);
2, threadObj.setPriority(MAX_PRIORITY);
3, threadObj.setPriority(THREAD.PRIORITY);
4, threadObj.setPriority(THREAD.MAX_PRIORITY);

Answer : 4 (More...)

Consider the following two classes:

public class Example1
public static int num;

public class Example2
public static void main(String[] args)

Select the correct option regarding the preceding classes.?

1, The Example2 class will execute without any output.
2, The Example2 class will execute with the following output:5

3, The Example2 class will not compile as it does not calls the constructor of the Example 1 class.
4, The Example2 class will not execute as it does not calls the constructor of the Example 1 class.

Answer : 2 (More...)

What will be the result of the following statement?

SELECT STR(938.56, 6, 1)

A. 938.56
B. 938.5
C. 938.6
D. 0938.5
E. 0938.6
F. 00938.5
G. 00938.6

Correct Answer : C
The STR function returns character data converted from numeric data. The second parameter of the STR function is for the total length of the output, including the decimal point, sign, digits and spaces. The output is rounded to the number of decimal places specified in the third parameter.

To create a string literal exclude escape sequence

@string. With adding @ at the beginning you can escape literal (More...)

String is an...........

String is an Object Type. where other data types are reference type in .NET (More...)

Where do you store connection string?

Database connection string can be stored in the web config file.
The connection string can be stored in the WEB.Config file under
element. (More...)

What does connection string consist of?

The connection string consists of the following parts:
In general:

Server: Whether local or remote.

Uid: User Id (sa-in sql server)

Password: The required password to be filled-in here

Database: The database name. (More...)

Difference between String.Empty and ""

The main difference is lies on memory management.

String.Empty will not create any object of string where as "" (Double Quote or Empty Quote) will create a new object in the memory for the checking the objects. (More...)

Yield keyword in C Sharp

C Sharp and yield keyword


One of the cool and yet most unknown feature of the C# is the yield keyword. The yield keyword is used in an iterator block to provide a value to the enumerator object or to signal the end of the iteration. When used the expression is evaluated and returned as a value to the enumerator object. Note the expression has to be implicitebly convertible to yield type of the iterator. Here is an example

public static IEnumerable GetIntCollectionFromString(string SomeString){ string[] val = SomeString.Split(' '); int intToAdd; foreach (string token in val) { if (int.TryParse(token, out intVal)) { yield return intVal; } else { yield break; } }}

Here since we are using the yield keyword the function will return the collection of intVal instead of the value of intVal. The statement will only return when the iteration of the loop is complete.

There are some limitation with the yield keywords.

Unsafe blocks are not allowed
Parameters to the method, operator, or accessor cannot be ref or out. (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