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

Identity column in SQL Server

Image
This is only for identity coloum Create Table tblPerson ( PersonId int Identity(1,1) Primary Key, Name nvarchar(20) ) Insert into tblPerson values ('Sam') Insert into tblPerson values ('Sara') Insert into tblPerson values ('Todd') where personid=2 select * from tblperson Insert into tblPerson(PersonId, Name) values(2, 'John') delete tblPerson where personid=2 SET Identity_Insert tblPerson ON --suppose we have deleted any in between the table and we try to insert the row but it can be inserted by this querry we inserted the row SET Identity_Insert tblPerson OFF --after modification we need to again resert the identity insert.. DBCC CHECKIDENT(tblPerson, RESEED, 0)-- if we want to completely delete our table and start is agiin from the person id =1 the we should use this querry
Read more

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

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