Database Discussion Boards

S Douglas7-Dec-05 0:15

7-Dec-05 0:15

steve_rm wrote:
Like for e-mails, l have a username that is unique. Would I have another id as well. For e.g. Does yahoo have our usernames as our primary key fields?

Using a User name as primary key is probably a bad thing. Think about it how many Mike Smiths are there in the world? The answer is there are a lot of duplicate names in the world.

Do you think everyone of your customers are willing to give you their email address? What about the poeple in the world that don’t have email?

Seems to me your better off using the int as a primary key for the table.

Just my 2 cents...

ZeePain! wrote:
This seems like one of those programs that started small, grew incrementally, building internal pressure, and finally barfed all over its source code sneakers. Or something.

thedailywtf.com[^]

Save and retrieve picture

Mohammad Daba'an4-Dec-05 22:35

Mohammad Daba'an

4-Dec-05 22:35

hi, how can i save a real picture on the SQL DB and retrieve it. Smile | :)

Thanks alot
Hamody

Re: Save and retrieve picture

Farhan Noor Qureshi5-Dec-05 10:27

Farhan Noor Qureshi

5-Dec-05 10:27

Check out this[^]

Farhan Noor Qureshi

^{if (this == this) thow this;}

Server Explorer in NET VS.2003

cduwel4-Dec-05 4:06

cduwel

4-Dec-05 4:06

Can anyone tell me why I am not seeing any SQL Server 2K user defined functions in the server explorer in VS.2003. The documentation talks about running a udf in server explorer by right clicking a udf in the udf folder - Well I ain't got no stinking udf folders in any SQL Server databases although I know they are there. Using professional edition.
Thanks
Confused | :confused:

cduwel

Binding Database to multiple controls

Taen_Karth3-Dec-05 21:27

Taen_Karth

3-Dec-05 21:27

This was posted in the VB forum as well since I was not sure which it pertained to.

Ok, not sure exactly how to word this so here goes. I have a winform in my project that has the following:

Controls

1. DropDownList1 - Customer Name
2. TextBox1 - Customer ID
3. DropDownList2 - Site Name

DataBase Tables

1. tblCust - Fields(CustName, CustID, Status)
2. tblCustSiteAssoc - Fields(CustId, CustSiteID)
3. tblCustSite - Fields(CustSiteID, CustSiteName, ...)

What I am trying to do is this:
1. When the form open have customers names bound to the DropDownList1 control with nothing selected
2. Once I select something in the DropDownList1 control (SelectedIndexChanged) have it update the other two controls with the selected customers' data.

I assume I make a DataSet that queries all three tables and I understand how to bind the CustName to the first DropDownList box. What I don't understand is how to use the selected information to get the relevant information for the other two controls.

Thanks in advance,

Taen Karth

Thanks,

Taen Karth

Can ADO be used in C (not C++)

FFKONG3-Dec-05 12:36

FFKONG

3-Dec-05 12:36

Can ADO be used in C (not Visual C++), using Microsoft Visual Studio? Is there any sample code on this? Thanks.

Re: Can ADO be used in C (not C++)

Rob Graham3-Dec-05 15:24

Rob Graham

3-Dec-05 15:24

Since ADO is a COM server, I would doubt it.

Absolute faith corrupts as absolutely as absolute power
Eric Hoffer
All that is necessary for the triumph of evil is that good men do nothing.
Edmund Burke

Re: Can ADO be used in C (not C++)

Matt Gullett3-Dec-05 17:18

Matt Gullett

3-Dec-05 17:18

Probably not directly, but there is nothing stopping you from creating a Windows DLL that wraps the ADO class heirarchy in a set of public functions. This DLL could then be used in straight C.

Re: Can ADO be used in C (not C++)

FFKONG4-Dec-05 22:01

FFKONG

4-Dec-05 22:01

This DLL is not only be used by C, but also other client languages like Delphi, Borland C++, VB.NET etc. I am still figuring out how to wrap this ADO in the DLL so that it can be called by all client languages. Do you have any sample code or references that I may refer? Thanks.

Re: Can ADO be used in C (not C++)

Farhan Noor Qureshi5-Dec-05 10:28

Farhan Noor Qureshi

5-Dec-05 10:28

Does this[^] help?

Farhan Noor Qureshi

^{if (this == this) thow this;}

DateTime Updating Problem in sql2000?

majidbhutta3-Dec-05 0:08

majidbhutta

3-Dec-05 0:08

DateTime Updating Problem in sql?

below is the query that is a part of a sproc .All table
fields and values are ok. When the mentioned Sproc. is
called in query analyzer it executes well and update all
fields of the table used in UPDATE statement
.
UPDATE Emp_Schedule
SET IOS = 0, HoursWorked = @WorkTime, COA =getdate()
WHERE (Emp_Id = @EmpID) AND (S_Id = @ShiftId) AND (DT =@DayTime)

PROBLEM arises when i call this procedure from C# code all fields are updated Except the COA(DateTime) field.Whats the problem. SProc runs well both in debug mode and normal mode in query analyzer and do updates the values. But when i call in C# only datetime field COA is not Updated? Plz solve this.
THNX IN Advance.

Re: DateTime Updating Problem in sql2000?

Chris Meech5-Dec-05 3:41

Chris Meech

5-Dec-05 3:41

Is it possible that this is a permissions problem? The user that executes the C# code, do they have execute permissions on the function?

Chris Meech

I am Canadian. [heard in a local bar]

Remember that in Texas, Gun Control is hitting what you aim at. [Richard Stringer]

Nice sig! [Tim Deveaux on Matt Newman's sig with a quote from me]

SQL Server 2005 Report Builder

su772-Dec-05 12:40

su77

2-Dec-05 12:40

I want to brings all the published reports from the server and allow user to view them using SQL Server 2005 Report Builder. Can anyone provide me with a sample code or any website which may be of help.

Remove duplicates from result set

jszpila2-Dec-05 4:48

jszpila

2-Dec-05 4:48

Hey everybody,
I know this a pretty silly question but I totally blanked. I'm looking to remove duplicate results from the results set (NOT the table).

Say I have a query like so:
SELECT SomeNumber FROM MyTable ORDER BY SomeNumber ASC
returns the following set:
1
1
1
2
2
3
4

But I want it to return:
1
2
3
4

What extra criteria would I add to the query?

Thanks in advance for your help.

-------------------
abort, retry, fail?

Re: Remove duplicates from result set

sreejith ss nair2-Dec-05 6:10

sreejith ss nair

2-Dec-05 6:10

SELECT distinct(SomeNumber) FROM MyTable ORDER BY SomeNumber ASC

Re: Remove duplicates from result set

jszpila2-Dec-05 6:22

jszpila

2-Dec-05 6:22

thank you much, sir. just what i was looking for.

-------------------
abort, retry, fail?

Re: Remove duplicates from result set

sreejith ss nair2-Dec-05 6:24

sreejith ss nair

2-Dec-05 6:24

Did that solution served your purpose ? Big Grin | :-D

Re: Remove duplicates from result set

jszpila2-Dec-05 6:27

jszpila

2-Dec-05 6:27

yes it did. thanks again!

-------------------
abort, retry, fail?

Help Me plz abt this dateTime UDF_Function?

majidbhutta1-Dec-05 15:32

majidbhutta

1-Dec-05 15:32

below is the function that compares only time .there are 3 datetime variables.
@StartTime datetime
@EndTime datetime
@DayTime datetime

@StartTime is always less than @EndTime regardless of its
dates.and @DayTime may be any time. We have to calculate
whether @DayTime lies between @StartTime and @EndTime or
not. And on its behalf we return a value.
if @DayTime lies between @StartTime and @EndTime return 1
else return 0.But tested with these values result is not ok.
set @StartTime='12/1/2005 12:30:49 PM'
set @EndTime='12/2/2005 4:30:49 AM'
set @DayTime='2005-12-02 00:56:02.730'
select dbo.udf_IsShiftValid(@StartTime,@EndTime,@DayTime )

it returns 0 where i think it should return 1. plz correct
me where m i wrong.

Actually i have to use this function on CheckInShfit event of the Employee. @StartTime and @EndTime are the time of the shifts that have already been defined in the database very ago. Now whenever Employee ChecksIn we have to confirm wheather he is entering Between his shift timing that have been Defined already in the database, if his CheckInTime (only time not date) @DayTime lies between his @StartTime and @EndTime then he is allowed to enter (i.e 1) else Not(0).
Now keeing in view the baove Scenario, plz guide me
plz modify this function so as it returns 1 if the @DayTime

Lies Between @StartTime And @EndTime else one( BUt keep in

Mind i m required to compare only time not the dates and

@startTime value is always less than @EndTime value)

CREATE FUNCTION dbo.udf_IsShiftValid(@StartTime datetime,

@EndTime datetime,@DayTime datetime)
RETURNS int AS
BEGIN
DECLARE @RtValue AS int

IF
convert(varchar,@DayTime,114)>=
convertvarchar,@StartTime,114) AND

convert(varchar,@DayTime,114)<
(convert(varchar,@EndTime,114)
BEGIN
SET @RtValue=1
END
ELSE
BEGIN
SET @RtValue=0
END

RETURN @RtValue
END

-- modified at 21:40 Thursday 1st December, 2005

Re: Help Me plz abt this dateTime UDF_Function?

sreejith ss nair2-Dec-05 6:47

sreejith ss nair

2-Dec-05 6:47

Eg :

CREATE FUNCTION dbo.udf_IsShiftValid(@StartTime datetime, @EndTime datetime,@DayTime datetime) <br />
<br />
RETURNS INT AS <br />
BEGIN <br />
DECLARE @RET AS INT<br />
<br />
IF<br />
            (convert(varchar,@EndTime,114) < convert(varchar,@DayTime,114)  ) AND  (convert(varchar,@DayTime,114) > convert(varchar,@StartTime,114) )<br />
 SET @RET=1<br />
<br />
ELSE<br />
<br />
SET @RET=0<br />
<br />
<br />
RETURN @RET<br />
END

Please have a look at this URL also.
http://www.databasejournal.com/features/mssql/article.php/3348181[^]

-- modified at 12:47 Friday 2nd December, 2005

OLEDB data source issue

Joshua Lunsford1-Dec-05 13:06

Joshua Lunsford

1-Dec-05 13:06

the following connection string throws an error... how can I have the data source be a network share like so?

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\server\share$;Extended Properties='text;HDR=no;FMT=Delimited(;)';

Database sample

sasan561-Dec-05 9:44

sasan56

1-Dec-05 9:44

Hi, I want to see a complete sample code for a database with C#.NET & SQL server at Windows Base.where i can find it? can anyone send it to me?

-- modified at 17:08 Thursday 1st December, 2005

Re: Database sample

Raj Lal1-Dec-05 10:56

Raj Lal

1-Dec-05 10:56

check this[^]

"Not everything that counts can be counted..."
-Albert Einstein

Re: Database sample

sasan561-Dec-05 10:59

sasan56

1-Dec-05 10:59

Thanks.you gave me a great help!!!!!!!!!!!

Re: Database sample

Raj Lal1-Dec-05 11:16

Raj Lal

1-Dec-05 11:16

don't forget to vote if you like it Smile | :)

"Not everything that counts can be counted..."
-Albert Einstein

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