Re: How do we implement "Did you mean" like functionality - Database Discussion Boards

getting list of parameters of a stored procedure in sql server 2005

I Never Look Behind30-Dec-07 23:48

30-Dec-07 23:48

Hi! there is a stored procedure containing 3 input parameter & 2 output parameters. now i want to write a sql query that lists parameters as well as their parameter types & data type for a particular sotred procedure. can any help me in this regards?

Re: getting list of parameters of a stored procedure in sql server 2005

N a v a n e e t h31-Dec-07 1:27

N a v a n e e t h

31-Dec-07 1:27

SELECT * FROM INFORMATION_SCHEMA.PARAMETERS

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

My Website | Ask smart questions

Re: getting list of parameters of a stored procedure in sql server 2005

I Never Look Behind31-Dec-07 2:01

I Never Look Behind

31-Dec-07 2:01

Thanks!!!

Difference between Candidate Key and Unique Key

.NET- India 30-Dec-07 19:20

.NET- India

30-Dec-07 19:20

Can anyone define Difference between Candidate Key and Unique Key

Re: Difference between Candidate Key and Unique Key

vimal_yet30-Dec-07 19:23

vimal_yet

30-Dec-07 19:23

http://en.wikipedia.org/wiki/Primary_key[^]

If U Get Errors U Will Learn
If U Don't Get Errors U Have Learnt

How do we implement "Did you mean" like functionality

www.Developerof.NET30-Dec-07 7:04

www.Developerof.NET

30-Dec-07 7:04

Hi all,

I wan`t to implement the did you mean functionality just like what google search provides

for eg when i search madona its should show "did you mean 'madonna'" how do we implement phonemes
in sql 2000???

When you fail to plan, you are planning to fail.

Re: How do we implement "Did you mean" like functionality

Colin Angus Mackay30-Dec-07 12:35

Colin Angus Mackay

30-Dec-07 12:35

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.

Upcoming FREE developer events:
* Developer Day Scotland

Recent blog posts:
* Follow up on hiring a software developer
* The Value of Smaller Methods

My website | blog

Re: How do we implement "Did you mean" like functionality

Mark Churchill30-Dec-07 16:20

Mark Churchill

30-Dec-07 16:20

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.

Mark Churchill
Director
Dunn & Churchill
Diamond Binding: Zero to Data Layer in 3 mins

Re: How do we implement "Did you mean" like functionality [modified]

GuyThiebaut31-Dec-07 0:41

GuyThiebaut

31-Dec-07 0:41

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

query

neoghy28-Dec-07 22:05

neoghy

28-Dec-07 22:05

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

Re: query

Usharva29-Dec-07 0:06

Usharva

29-Dec-07 0:06

Try this

select DateCol from TableName where DateCol between '01/01/2007' and '01/01/2008'

Primary key in SQL Server

.NET- India 28-Dec-07 18:55

.NET- India

28-Dec-07 18:55

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

Re: Primary key in SQL Server [modified]

Paul Conrad29-Dec-07 7:02

Paul Conrad

29-Dec-07 7:02

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

Re: Primary key in SQL Server

mr_lasseter29-Dec-07 18:37

mr_lasseter

29-Dec-07 18:37

Actually only one primary key per table, which can be composed of multiple columns.

Re: Primary key in SQL Server

Paul Conrad30-Dec-07 5:08

Paul Conrad

30-Dec-07 5:08

I meant to write table instead of column Blush | :O

"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

Createing column primary key and contains of 3 characters and 6 auto increment numbers (example: "DLL - 123456")

adel.atef28-Dec-07 16:37

adel.atef

28-Dec-07 16:37

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

Re: Createing column primary key and contains of 3 characters and 6 auto increment numbers (example: "DLL - 123456")

vimal_yet28-Dec-07 18:09

vimal_yet

28-Dec-07 18:09

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

Re: Createing column primary key and contains of 3 characters and 6 auto increment numbers (example: "DLL - 123456")

Marek Grzenkowicz31-Dec-07 0:39

Marek Grzenkowicz

31-Dec-07 0:39

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'

Any query??

omegazafer28-Dec-07 10:01

omegazafer

28-Dec-07 10:01

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

Re: Any query??

Chris Meech28-Dec-07 10:04

Chris Meech

28-Dec-07 10:04

select salesperson, max(sales) from salesreporttable group by salesperson

Did you use to work in sales?

Chris Meech
I am Canadian. [heard in a local bar]
Donate to help Conquer Cancer[^]

Re: Any query??

Paul Conrad28-Dec-07 10:22

Paul Conrad

28-Dec-07 10:22

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

Re: Any query??

GuyThiebaut28-Dec-07 10:27

GuyThiebaut

28-Dec-07 10:27

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 Laugh | :laugh:

).

Guy

You always pass failure on the way to success.

Re: Any query??

KANGAROO_2-Jan-08 1:03

KANGAROO_

2-Jan-08 1:03

plz dont laugh to anyone......he/she is member of our codeproject family..
Smile | :)

manoj Kumar Jha

"Learn to smile at every situation. See it as an opportunity to prove your strength and ability."

Sql2000

Aman.Jen28-Dec-07 0:08

Aman.Jen

28-Dec-07 0:08

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

Re: Sql2000

Colin Angus Mackay28-Dec-07 0:19

Colin Angus Mackay

28-Dec-07 0:19

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.

Upcoming FREE developer events:
* Developer Day Scotland

Recent blog posts:
* Follow up on hiring a software developer
* Aarrgghh!! Accidentally pressing the Caps Lock key

My website | blog

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.