|
www.Developerof.NET wrote: for eg when i search madona its should show "did you mean 'madonna'" how do we implement phonemes
in sql 2000???
Create a table of synonyms? If you put in a known bad spelling then it can suggest the correct spelling. I would imagine that Google built up its "Didn you mean?" functionality over time by monitoring what people were searching for then seeing that the subsequent search had a search term changed by only a few characters indicating that there was a typo in the previous version.
|
|
|
|
|
SQL has a SOUNDSLIKE function to perform this type of matching. Theres also another function, who's name I can't rememeber which lets your control the 'fuzzyness'. Both these functions turn a word into a code - where Mikael and Michael would return the same code.
You could use this against a wordlist to make suggestions if the number of results is low. If the number of results for a search is high then you can add that to the wordlist. When suggesting you pick the highest & closest match. This will then evolve over time to your unique dataset.
|
|
|
|
|
Have a play around with the SOUNDEX keyword:
SELECT SOUNDEX ('guy'), SOUNDEX ('gi')
I think whoever coded the phonetics was a Spanish speaker as both the following return equal results:
SELECT SOUNDEX ('guy'), SOUNDEX ('gay')<br />
SELECT SOUNDEX ('sh*t'), SOUNDEX ('sheet')
(Can't use swear words on this forum so replace the * with ???)
You can also use the DIFFERENCE keyword as in:
SELECT DIFFERENCE('guy', 'gi')
The result is a number from 0 to 4; 4 being the best match.
Regards
Guy
You always pass failure on the way to success.
modified on Monday, December 31, 2007 8:08:52 AM
|
|
|
|
|
Hi actually i wanted to write a query which will show all the details from a particular time duration to another duration , Like all details between the year 2006 and 2007 and even if the year is same how to select data based on the months. Please help
skd
|
|
|
|
|
Try this
select DateCol from TableName where DateCol between '01/01/2007' and '01/01/2008'
|
|
|
|
|
How many primary key(s) can be set in SQL Server.
Actually i set primary key in 16 columns. Am i right if not please explain
Are Unquie keys and Candidate keys same. And how many Candidated keys we can have in a table
modified on Saturday, December 29, 2007 2:17:10 AM
|
|
|
|
|
Only one primary key per table. You can have as many foreign keys as you want.
Last modified: 22hrs 5mins after originally posted --
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
Actually only one primary key per table, which can be composed of multiple columns.
|
|
|
|
|
I meant to write table instead of column
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
i would like to create a column primary key and it's first three character id dll for example and 6 auto increment number so please help me
my email address is : adel.atef@gmail.com
thanks u in advance for that matter
|
|
|
|
|
there is no Aphalnumeric Primarykey with auto increment upto my knowledge.
u can manually do like as follows
SELECT MAX(CAST(SUBSTRING(id,CHARINDEX('-',id)+1,50) AS INT)) + 1 FROM TBL_Table WHERE ID LIKE 'DEF%' [this can be like ..."id like 'ABC%' to get highest value in ABC Sequence]
If U Get Errors U Will Learn
If U Don't Get Errors U Have Learnt
|
|
|
|
|
How about using a computed column?
CREATE TABLE dbo.FOOBAR<br />
( FOOBAR_ID bigint NOT NULL IDENTITY (100000, 1)<br />
, AN_FOOBAR_ID AS 'DLL' + CAST(FOOBAR_ID AS varchar(97))<br />
, FNAME varchar(100) NOT NULL<br />
, LNAME varchar(100) NOT NULL )<br />
GO<br />
<br />
INSERT INTO dbo.FOOBAR(FNAME, LNAME) VALUES('John', 'Doe')<br />
INSERT INTO dbo.FOOBAR(FNAME, LNAME) VALUES('Jane', 'Doe')<br />
GO<br />
<br />
SELECT * FROM dbo.FOOBAR<br />
SELECT * FROM dbo.FOOBAR WHERE AN_FOOBAR_ID = 'DLL100001'
|
|
|
|
|
Hi friends,
I have below salesreport table, how can I get results of max sales of sales persons in one query?
salesperson sales orderId
Michele 120 120121
Guido 230 120122
Michele 300 120123
Michele 250 120124
Franco 100 120125
Guido 500 120126
Franco 400 120127
the query result must be;
salesperson sales
Michele 300
Guido 500
Franco 400
|
|
|
|
|
select salesperson, max(sales) from salesreporttable group by salesperson
Did you use to work in sales?
|
|
|
|
|
Chris Meech wrote: Did you use to work in sales?
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
Please do not post on multiple forums.
I also answered your question on the C# forum.
If I had looked at this forum first I would not have posted on the C# forum - so you wasted about 30 minutes of my time(well it was a pretty tough question ).
Guy
You always pass failure on the way to success.
|
|
|
|
|
|
Hi All,
Can we create Database of Music Files using SQL Server 2000.
If yes please give an example, Or else what is the other option.
Thnx
Nitin Jenwal
|
|
|
|
|
Nitin.Jen wrote: Can we create Database of Music Files using SQL Server 2000.
Yes.
Nitin.Jen wrote: If yes please give an example
It depends what you ultimately want to do with the music files.
At its most basic:
CREATE TABLE MusicFiles
(
MusicFileId int IDENTITY(1,1) PRIMARY KEY,
FileName nvarchar(1024)
)
However, I suspect you want more than that. If you would like to give more details we can help you more.
|
|
|
|
|
Yes..U R right Sir..I want to create Asp.Net Page which plays music..just like raaga.com or dishant.com.
I want to make DB of Mp3 file.If you could give me the example of how the table will be and how to pass query to select and play that file in front end of Asp.Net page
Thnx
Nitin Jenwal
|
|
|
|
|
It depends on whether or not you want to store the file in the database itself, or use a path to the file. Without knowing this, there's not a lot anybody else can do for you, but I would suggest that at least part of your table should be a friendly name for the file that will be played. If you store the file on disk, then you should really consider storing it with a unique name (such as a GUID) so that it doesn't conflict with another file of the same name.
|
|
|
|
|
Wat is meaning of IDENTITY(1,1)....??
Nitin Jenwal
|
|
|
|
|
Nitin.Jen wrote: Wat is meaning of IDENTITY(1,1)....??
Seriously?
I put "IDENTITY(1,1)" into google and I got back this as my first hit![^]
|
|
|
|
|
U can insert any extension in the DB .you need to use the data type as image
If U Get Errors U Will Learn
If U Don't Get Errors U Have Learnt
|
|
|
|
|
Nitin.Jen wrote: Can we create Database of Music Files using SQL Server 2000.
Yes. It is pretty easy.
Nitin.Jen wrote: please give an example
Nope.
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|