Database Discussion Boards

Re: Connect to sql server

messages23-Aug-07 21:12

messages

23-Aug-07 21:12

I dont know why I cant see any servics of sql server on the services?

Re: Connect to sql server

edukulla23-Aug-07 22:05

edukulla

23-Aug-07 22:05

You can connect to your local server by using "." Just type the "." in the name field and then login using credentials either "windows" or SQL.

Hope this helps.
Thanks!

Santhosh Kumar Edukulla

Oracle learning?

Mel Padden23-Aug-07 3:48

Mel Padden

23-Aug-07 3:48

I jsut moved to a company that uses Oracle for almost all their database stuff. Having never used PL/SQL and being used to SQL server, I'm on a bit of a learning curve. Even though I'm a decent T-SQL programmer, there's a bit to pick up, and I need to be productive quickly.

I reckon I need two things ;

A step-by-step introduction book, with real-world worked examples and the like, to get me going and give me the knowledge I need to do the job as quickly as possible, and;

A small reference guide to the PL/SQL language, to have at my desk 24/7 for when I need specific, indexed information on a subject.

Has anyone had any experience with Oracle or PL/SQL literature? Any recommendations?

All the dude ever wanted... was his rug back.

Re: Oracle learning?

shivvish30-Aug-07 22:57

shivvish

30-Aug-07 22:57

hi
get any basics book and go with it dont take huge books first of all and have a glance at index and the perface of the book.

get back for any queries.

i dont say that i am an expert but i a good in oracle for me.

SELECT 1 Query Question

Programm3r23-Aug-07 1:40

Programm3r

23-Aug-07 1:40

What exaclty is the purpose of using SELECT 1 ... in a query??

Many Thanks
Regards,

The only programmers that are better that C programmers are those who code in 1's and 0's Green Alien | [Alien]

Programm3r
My Blog: ^_^

Re: SELECT 1 Query Question

Blue_Boy23-Aug-07 2:04

Blue_Boy

23-Aug-07 2:04

What do you mean by

Programm3r wrote:
SELECT 1

I Love SQL

Re: SELECT 1 Query Question

Colin Angus Mackay23-Aug-07 2:29

Colin Angus Mackay

23-Aug-07 2:29

I presume he means a query that in its entirity is SELECT 1

It is, after all, a valid query. (By that I mean that SQL Server will process it and produce a result set from it)

-- Always write code as if the maintenance programmer were an axe murderer who knows where you live.

Upcoming FREE developer events:
* Glasgow: Agile in the Enterprise Vs. ISVs, Mock Objects, SQL Server CLR Integration, Reporting Services, db4o ...
* Reading: SQL Bits

My website

Re: SELECT 1 Query Question

Blue_Boy23-Aug-07 2:59

Blue_Boy

23-Aug-07 2:59

thanks for your clearly in his question

I Love SQL

Re: SELECT 1 Query Question

Colin Angus Mackay23-Aug-07 2:30

Colin Angus Mackay

23-Aug-07 2:30

I presume you found this in a stored procedure. It is often used to return a result back to the caller. It is especially useful when the stored procedure is invoked from a .NET application with ExecuteScalar()

Check valid Date

EvanSaunders22-Aug-07 23:58

EvanSaunders

22-Aug-07 23:58

I have two date pickers that can be selected by the user. If the span of these two dates fall between a specific date in the database, then a message should appear. I don't know know how to check these dates using SQL.

I know that I can check one date to be between two dates in the database, I just don't know how to check if any part of an entire date span falls between these values.

Please help!

Evan Saunders

Re: Check valid Date

Krish - KP23-Aug-07 0:32

Krish - KP

23-Aug-07 0:32

can you please exmplain with an example

Regards
KP

Re: Check valid Date

EvanSaunders23-Aug-07 0:38

EvanSaunders

23-Aug-07 0:38

I have two date-time pickers. One is the start date of an event, and the other end date.
If I want to add another event with a start date and an end date, then I must run an SQL statement to check if the new event date does not overlap the date of a previous event.
So far, I only know how to check whether the start date or end date of an existing row in the database is between the start date and end date of the new event. I need to check the complete date against the new event date. Thanks

Re: Check valid Date

Joe23-Aug-07 1:08

Joe

23-Aug-07 1:08

I am not sure if I've got your concern at the right end, my apologies if I am wrong.

Probably you can introduce a new column in the dB indicating that the specified range of date(s) is/are already blocked for an event.

Re: Check valid Date

EvanSaunders23-Aug-07 1:14

EvanSaunders

23-Aug-07 1:14

Its not really what I am looking for, but I am willing to try. Unfortunately, I don't know how to implement this. Thanks

Re: Check valid Date

Michael Potter23-Aug-07 4:16

Michael Potter

23-Aug-07 4:16

Range comparisons are not that horrible if you break them down. In order for a range to overlap, the first requirement would be that the New.StartDate is less than (or equal too) the Stored.EndDate. If not, then they don't clash. If it is true, then see if the New.EndDate is greater than (or equal too) the Stored.StartDate. If this is also true, then you have an overlapping range.

In a stored proceedure it would look something like this:

IF EXISTS(SELECT *
          FROM [MyTable]
          WHERE 
               @StartDate <= [EndDate] AND
               @EndDate >= [StartDate])
BEGIN
   /* Throw error on overlapp */
END
ELSE
BEGIN
  /* Append new row */
END

fetching field names from a table in MS Access

Karismatic22-Aug-07 23:26

Karismatic

22-Aug-07 23:26

Hey,

I m trying to fetch field names from a table in an access database.

can anybody tell me how to do it
is there any table that contain all the field names or any other way to get

i m using VC++ 6.0

thank you

Regards,
Pankaj Sachdeva

"There is no future lies in any job"
"but"
"future lies in the person who holds the job"

Re: fetching field names from a table in MS Access

PIEBALDconsult23-Aug-07 5:47

PIEBALDconsult

23-Aug-07 5:47

What I do, with all the types of database I've yet encountered, is to use the DataReader's GetSchemaTable method.

(I use C#)

Open the connection -- con.Open() ;
Set the command -- cmd.CommandText = "SELECT * FROM table" ;
Use ExecuteReader -- reader = cmd.ExecuteReader() ;
Call GetSchemaTable -- table = reader.GetSchemaTable() ;
Cancel the Command -- cmd.Cancel ; (Not all databases support this.)
Close the DataReader -- reader.Close() ;
Close the connection -- con.Close() ;

how to deploy report in re from another machine

salmonraju22-Aug-07 23:24

salmonraju

22-Aug-07 23:24

--------------------------------------------------------------------------------

Hi,
We are creating a small apllication ,and we want to deploy all the reports in the single server ,how to configure this server,
so that others can acces the reports in this server and also deploy their reports

fetch listbox with values vb .net

RaveRare22-Aug-07 22:06

RaveRare

22-Aug-07 22:06

Dear everyone.

hope you all will be fine and good in health.

i have a problem that i want to fetch a listbox with names. please help me that what code i have to write.

PICTURE IS HERE;

i have a table STUDENT with attributes (ID, Name, Age)
i have inserted 100 students record into STUDENT tabl
i have a listbox control named lstStdents on my form

now i want that when my form is opened, it should auotmatically fill the listbox with NAME of students

i want to know that how to fill that box using datareader?

thanks

Re: fetch listbox with values vb .net

Panchal Hardik23-Aug-07 1:12

Panchal Hardik

23-Aug-07 1:12

While (dr.Read)
lstStdents .Items.Add(dr.Item("Name"))
End While

Panchal Hardik

Fectch listbox with student name vb. net

RaveRare22-Aug-07 21:58

RaveRare

22-Aug-07 21:58

sql server 2000

Sonia Gupta22-Aug-07 20:50

Sonia Gupta

22-Aug-07 20:50

like in ms-access , we link the two tables by connecting their id's , in the relationship form, there i select the tables and connect them by creating the primary and foreign relationships betweeb the id's.
Now my question is , is there any way to link the id's so that when i open the table , i can see the + sign , and after clicking the + sign , i get the information - correspondig to that id in sql server 2000

Sonia Gupta
Soniagupta1@yahoo.co.in
Yahoo messengerId-soniagupta1
Love is Friendship and Friendship is Love....

Re: sql server 2000

John-ph22-Aug-07 21:01

John-ph

22-Aug-07 21:01

No you can't. You have to query against the table with the id to get the information.

Regards
John

Re: sql server 2000

Sonia Gupta23-Aug-07 0:31

Sonia Gupta

23-Aug-07 0:31

Does this facility available in sql server 2005

Sonia Gupta
Soniagupta1@yahoo.co.in
Yahoo messengerId-soniagupta1
Love is Friendship and Friendship is Love....

Re: sql server 2000

Krish - KP22-Aug-07 21:16

Krish - KP

22-Aug-07 21:16

This is not possible becasue tables in SQL Server are not physically linked.

Regards
KP

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