Database

23-Aug-07 5:30

costavo wrote:
or what ever

costavo wrote:
i have to loop in a table in sql database to find a certain record and compare it or what ever,....
the question is what steps i have to do to loop in a table
using c# lang in a win app.

I presume you are talking about a DataTable rather than one in SQL Server.

foreach(DataRow row in myDataTable.Rows)
{
    // Do what you need to here.
}

-- 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

Connect to sql server

messages23-Aug-07 3:56

23-Aug-07 3:56

Hi everyone,
I was installing sql server 2005 and it installs perfect with all components without any errors now I run SQL Server Management Studio but it wants a name to server but I dont know name of server how do I solve this problem?
Thanks

WhiteGirl2323-Aug-07 4:00

WhiteGirl23

23-Aug-07 4:00

If you use Server Authentification use the name of your computer ,the user "sa" and the password that you set to sql server during the installation.

messages23-Aug-07 4:14

23-Aug-07 4:14

Im using of:
Server type: Database Engine
Server name: "I dont know what is it"
Authentication: Im trying with "Windows Authentication" and also Sql Server Authentication with sa" but I got this error:
Im trying with your answer(sa) but I got this error:
TITLE: Connect to Server
------------------------------

Cannot connect to local.

------------------------------
ADDITIONAL INFORMATION:

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 1231)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=1231&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

Colin Angus Mackay23-Aug-07 4:03

23-Aug-07 4:03

It is the name of the machine, or "(local)" for the server on the machine you are using. If you installed a named instance (something you would have to do explicitly) then you will have to add /InstanceName after the machine name.

messages23-Aug-07 4:17

23-Aug-07 4:17

Im using of:
Server type: Database Engine
Server name: "I dont know what is it" and also I checked with local
Authentication: Im trying with "Windows Authentication" and also Sql Server Authentication with sa" but I got this error:

TITLE: Connect to Server
------------------------------

Cannot connect to local.

------------------------------
ADDITIONAL INFORMATION:

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 1231)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=1231&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

Colin Angus Mackay23-Aug-07 5:35

23-Aug-07 5:35

messages wrote:
Cannot connect to local.

No, not "local". You need "(local)" with the brackets.

Colin Angus Mackay23-Aug-07 5:37

23-Aug-07 5:37

messages wrote:
this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections

Are you trying to connect to a SQL Server running on a separate machine?

If so you have to enable TCP/IP on the server. Use the SQL Server Configuration Manager

messages23-Aug-07 6:55

23-Aug-07 6:55

Im very thanksful for your time.
I try with all various local its not helpful and also I want to connect to sql server on my computer not remote
I went to services but I couldnt see any sql name on the services, then I decide to uninstall Sql server when I went for add/remove window for uninstall sql on the uninstall window I saw that it writes "No instances have been installed." on the Select an instace and on the Remove SQL Server 2005 common components it writes Workstation Components Can you help me I need to help you I searched internet but I cant find an answer
Thanks

martin_hughes23-Aug-07 13:21

martin_hughes

23-Aug-07 13:21

Depends.

If it's installed on your local machine with Windows Authentication:

Server = localhost - or if you're using Sql Server Express localhost\SqlExpress or if you named an instance during installation SqlExpress\TheNameYouChose (or just uninstall and do it again properly).

If you installed it locally, but used mixed mode authentication:

user name = sa
password = whatever you set it to be.

If you installed it on a networked machine:

I can't help you here.

"It was the day before today.... I remember it like it was yesterday."

-Moleman

messages23-Aug-07 21:12

23-Aug-07 21:12

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

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: ^_^

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

Colin Angus Mackay23-Aug-07 2:29

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)

Blue_Boy23-Aug-07 2:59

Blue_Boy

23-Aug-07 2:59

thanks for your clearly in his question

I Love SQL

Colin Angus Mackay23-Aug-07 2:30

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

Krish - KP23-Aug-07 0:32

Krish - KP

23-Aug-07 0:32

can you please exmplain with an example

Regards
KP

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

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.