Database Discussion Boards

Re: how to display all tables from any single database in sql server 7.0?

Rmesh12-Jan-07 22:14

Rmesh

12-Jan-07 22:14

select * from Sysdatabases where xtype='u'

Lock Types

Rahithi12-Jan-07 18:50

Rahithi

12-Jan-07 18:50

hi,
what are the lock types available with "recordsets" and How different are they from “datasets”
Thanks,
Rahi

If you look at what you do not have in life, you don't have anything,
If you look at what you have in life, you have everything... "

SQL Query help

Irshad Ahmed12-Jan-07 4:03

Irshad Ahmed

12-Jan-07 4:03

Please, help me in solving this query

I have a table some thing like this

Sens_Name T2_Value Q_Value CMI_Value
---------------------------------------------------
Sens 1 12 70 80
Sesn 2 13 71 81

I want to query the above table so that I get an output in this way

Sens_Name Stat_Value Stat_Type
--------------------------------------------------------------
Sens 1 12 T2_Value
Sens 1 70 Q_Value
Sens 1 80 CMI_Value
Sens 2 13 T2_Value
Sens 2 71 Q_Value
Sens 2 81 CMI_Value

Thanks in advance
Irsh

Re: SQL Query help

Michael Potter12-Jan-07 4:20

Michael Potter

12-Jan-07 4:20

You can use a UNION clause:

SELECT 
    Sens_Name,
    T2_value AS Stat_Value,
    'T2_Value' AS Stat_Type
FROM
    SensTable

UNION

SELECT 
    Sens_Name,
    Q_value AS Stat_Value,
    'Q_Value' AS Stat_Type
FROM
    SensTable

UNION

SELECT 
    Sens_Name,
    CMI_Value AS Stat_Value,
    'CMI_Value' AS Stat_Type
FROM
    SensTable

ORDER BY 
    Sens_Name,
    Stat_Value

Re: SQL Query help

Irshad Ahmed23-Jan-07 16:51

Irshad Ahmed

23-Jan-07 16:51

Thanks Mike

aspnet_regsql - Unable to connect

stuf9911-Jan-07 21:30

stuf99

11-Jan-07 21:30

Im trying to establish an ASPState database with the aspnet_regsql command. I receive an error informing me that the wizard was unable to connect to the sql server. I have an express server installed and have no problems connecting to it otherwise. On msdn it says that

The Aspnet_regsql tool should not be used with a local installation of SQL Server Express running in user instance mode (that is, the connection string contains User Instance=true).

Im not sure what that means?

I have also made the preparations with the T-SQL commands so I could enable the Agent XPs SQL Server option with the following commands

EXECUTE sp_configure 'show advanced options', 1<br />
RECONFIGURE WITH OVERRIDE<br />
GO<br />
<br />
EXECUTE sp_configure 'Agent XPs', 1<br />
RECONFIGURE WITH OVERRIDE<br />
GO<br />
<br />
EXECUTE sp_configure 'show advanced options', 0<br />
RECONFIGURE WITH OVERRIDE<br />
GO

Can anyone help?

How to make access to SQL 2000 from WAN only for one login?

yarns11-Jan-07 20:58

yarns

11-Jan-07 20:58

Hi,

i created user with access to read only database. Its possible to make that only this one user (rest of users from LAN only) will have access to database from WAN?

Greetings

Re: How to make access to SQL 2000 from WAN only for one login?

Mark J. Miller12-Jan-07 8:28

Mark J. Miller

12-Jan-07 8:28

If you're asking if SQL Server can control this, the answer is no. If a user can connect to SQL Server and present the correct credentials, they will be authenticated. It doesn't matter where they connect from.

Are you using SQL Server authentication or Windows Authentication? If you're using SQL Server authentication then you have no control over this - which is why Windows Authentication is the recommended best practice. If you're using Windows Authentication, then you should be able to control this by configuring which WAN accounts have access to your LAN and which of those WAN accounts which have access may also access SQL Server.

How to insert data into table from another existing table in Oracle 9i

BawaSingh11-Jan-07 20:07

BawaSingh

11-Jan-07 20:07

Kindly help me out regarding this. pls tell me the sql query for this..

D'Oh! | :doh:

Bawa

Re: How to insert data into table from another existing table in Oracle 9i

Programm3r11-Jan-07 20:27

Programm3r

11-Jan-07 20:27

See Here

OR

Here

Hope it will provide some kind of information....

Regards,

The only programmers that are better than C programmers are those who code in 1's and 0's..... Smile | :)

Programm3r

Re: How to insert data into table from another existing table in Oracle 9i

BawaSingh11-Jan-07 20:47

BawaSingh

11-Jan-07 20:47

Thanks for replying... but I can't open these links my firewal does't support :(these links.

Frown | :(

Bawa

Re: How to insert data into table from another existing table in Oracle 9i

Pete O'Hanlon12-Jan-07 0:55

Pete O'Hanlon

12-Jan-07 0:55

Normally, it's along the lines of

INSERT INTO table1
SELECT values FROM table2

the last thing I want to see is some pasty-faced geek with skin so pale that it's almost translucent trying to bump parts with a partner - John Simmons / outlaw programmer

Deja View - the feeling that you've seen this post before.

Re: How to insert data into table from another existing table in Oracle 9i

BawaSingh12-Jan-07 1:32

BawaSingh

12-Jan-07 1:32

Thanks !!

Bawa

Accent Insensitive Select in DataTable

darXstar11-Jan-07 3:05

darXstar

11-Jan-07 3:05

hi, I've this problem :
we work with a sql database which operates in accent-insensitive mode,
once I've cached some data from it to my .NET application, how can I search within this data (contained in a DataTable) with an accent-insensitive query?

I mean I'd like to obtain the same result (i.e.) " André "
in any case if user is searching for:
DataTable.Select("name LIKE 'andré')
DataTable.Select("name LIKE 'andrè')
DataTable.Select("name LIKE 'andre')

thanks to anyone may answer

Darx

Re: Accent Insensitive Select in DataTable

Mark J. Miller11-Jan-07 4:55

Mark J. Miller

11-Jan-07 4:55

Not sure which CultureInfo to use but I'd recommend setting the Locale propery of the DataTable. Try Invariant culture setting - it should ignore accents.

Re: Accent Insensitive Select in DataTable

darXstar21-Jan-07 23:50

darXstar

21-Jan-07 23:50

thanks for your reply, I've tried but with no success. It seems there is no way to directly perform an accent insensitive research with Select() function in a DataTable as like as in sql environment.

could somebody suggest a workaround?

How to determine what DB is used

Programm3r11-Jan-07 1:03

Programm3r

11-Jan-07 1:03

Hi all,

Is it possible to determine what db is being used with a sql statement or something more or less the same. i.e. Be it MySQL, MSSQL, DB2 ....

Many thanx .... again.

Regards,

The only programmers that are better than C programmers are those who code in 1's and 0's..... Smile | :)

Programm3r

Re: How to determine what DB is used

Paddy Boyd11-Jan-07 2:39

Paddy Boyd

11-Jan-07 2:39

How do you mean? Surely if you are hitting the DB, then you will have access to the connection object which would have this info?

Re: How to determine what DB is used

Programm3r11-Jan-07 2:48

Programm3r

11-Jan-07 2:48

Yes you are correct ... but I have no idea how to retrieve that object ?

The only programmers that are better than C programmers are those who code in 1's and 0's..... Smile | :)

Programm3r

Re: How to determine what DB is used

Colin Angus Mackay11-Jan-07 4:39

Colin Angus Mackay

11-Jan-07 4:39

Programm3r wrote:
but I have no idea how to retrieve that object ?

In order to connect to a database you must need some sort of connection. That connection object will have a IDbConnection.ConnectionString[^] property implementation from the IDbConnection interface. (So it doesn't matter what type of Connection object you have, you can always access it through the interface)

Upcoming Scottish Developers events:
* Glasgow: Tell us what you want to see in 2007

My: Website | Blog | Photos

Re: How to determine what DB is used

jezemine11-Jan-07 6:36

jezemine

11-Jan-07 6:36

in MSSQL:

select db_name()

www.elsasoft.org

Re: How to determine what DB is used

Programm3r11-Jan-07 18:09

Programm3r

11-Jan-07 18:09

Many thanx for the response, If I run select db_name() it returns the name of the database, the thing I looking for is the actual database package name, like MSSQL or MySQL, does it make sense, is it possible?

Regards,

The only programmers that are better than C programmers are those who code in 1's and 0's..... Smile | :)

Programm3r

Don’t get any UpdateCommand generated…

anderslundsgard11-Jan-07 0:09

anderslundsgard

11-Jan-07 0:09

What can be wrong when the Configure Data Adapter Wizard doesn’t generate any UpdateCommand?

_____________________________

...and justice for all

APe

Re: Don’t get any UpdateCommand generated…

Warnat11-Jan-07 4:17

Warnat

11-Jan-07 4:17

did your adapter just miss:

adapter.MissingMappingAction = MissingMappingAction.Passthrough;<br />
adapter.MissingSchemaAction = MissingSchemaAction.AddWithKey;<br />

??

or

maybe your query does not return the primary-key-columns Confused | :confused:

if this is the case, you won't get an UpdateCommand

greetings,
Ralf

Re: Don’t get any UpdateCommand generated…

anderslundsgard11-Jan-07 5:05

anderslundsgard

11-Jan-07 5:05

Warnat wrote:
maybe your query does not return the primary-key-columns

So I have to write an update-query on my own??

_____________________________

...and justice for all

APe

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