Like,freetext and contains operator in sql server 2008r2

How to create freetext in sqlserver 2008r2

1.
















Chose any one of them as per your requirement :)

Comments

Post a Comment

Popular posts from this blog

shortcuts key in visual studio

Image
Default Keyboard Shortcuts in Visual Studio Please refer http://msdn.microsoft.com/en-us/library/da5kh0wa.aspx (For more information) Visual Studio 2013 Other Versions 18 out of 29 rated this helpful  -  Rate this topic You can more easily access a variety of commands and windows in Visual Studio by choosing the appropriate keyboard shortcut. This topics lists the default shortcuts for the General Development profile, which you might have chosen when you installed Visual Studio. No matter which profile you chose, you can identify the shortcut for a command by opening the  Options  dialog box, expanding the  Environment  node, and then choosing  Keyboard . You can also customize your shortcuts by assigning a different shortcut to any given command. For a list of common keyboard shortcuts and other productivity information, see  Tips and Tricks for Visual Studio  and  Productivity Tips for Visual S...
Read more

SQL interview question

Image
1. How to find nth highest salary in SQL Server using a Sub-Query 2. How to find nth highest salary in SQL Server using a CTE 3. How to find the 2nd, 3rd or 15th highest salary To find 2nd highest salary we can use any of the above queries. Simple replace N with 2.  Similarly, to find 3rd highest salary, simple replace N with 3. 
Read more

Prime Number Program in C#

Prime number is a number that is greater than 1 and divided by 1 or itself. In other words, prime numbers can't be divided by other numbers than itself or 1. For example 2, 3, 5, 7, 11, 13, 17, 19, 23.... are the prime numbers. using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; namespace ConsoleApplication1 {     class Program     {         static void Main(string[] args)         {             int number, i, m = 0, flag = 0;             Console.WriteLine("PLEASE ENTER THE NUMBER TO CHECK PRIME NUMBER");             number = int.Parse(Console.ReadLine());             m = number / 2;             for(i=2;i<=m;i++)             {           ...
Read more