Database

Re: How to insert data saved in Excel file on Clientside into database on Serverside

28-Dec-07 3:46

You could create a DTS package to read the excel file into a table.

The package could then be run from a job or stored procedure each time data from the spreadsheet needed to be imported.

Eric.W wrote:
B/S arch

Can you explain to me what this is please?

Regards

Guy

You always pass failure on the way to success.

Eric.W28-Dec-07 4:33

Eric.W

28-Dec-07 4:33

thank you again ,you are very nice.
its meaning is browser/server architecture.

How to get the text of create table sql when I know the table name

richardye27-Dec-07 20:51

richardye

27-Dec-07 20:51

How can I get the text of create table sql when I know the table name?
Is there any view I can query for?
for example
I create a table T in oracle database.
Can I get the text of its create table sql through oracle view?
"create table T (sno number(3,0) primary key);"
Many thanks.

Re: How to get the text of create table sql when I know the table name

GuyThiebaut28-Dec-07 0:12

Re: How to get the text of create table sql when I know the table name

28-Dec-07 0:12

Open query analyzer.

Press F8 if the object browser is not present.
Select your database and then right click on the appropriate table.
Cursor over Script Object To New Window As then select Create.

Regards

Guy

You always pass failure on the way to success.

richardye28-Dec-07 13:32

richardye

28-Dec-07 13:32

My apologize. My meaning is to get it by command line,not by the ORACLE console.
Do you have any way in resolving it?

Without using order by

vimal_yet27-Dec-07 18:09

27-Dec-07 18:09

Hi,

i have a table of employee details where i have empno, name, salary.

i need to select the salary from the table in the descending order. the condition here is that I should not use order by clause.

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

Krish - KP27-Dec-07 19:24

Krish - KP

27-Dec-07 19:24

Are you trying to do this in an inline query.

what is your actual requirement.

Regards
KP

vimal_yet27-Dec-07 21:56

27-Dec-07 21:56

u can use inline query . but my constraint is not to use order by clause

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

GuyThiebaut27-Dec-07 23:30

Re: Without using order by [modified]

27-Dec-07 23:30

I could never see any reason for ever not using an order by clause to sort the output of a query.

The only other alternative I can think of is by setting the salary to be the primary key on a clustered index and see if that works.

This would of course be very bad design methodology as the empno field would make better sense as the primary key.

I would be more than happy to be proved wrong and am interested in what solution you come to.

Regards

Guy

You always pass failure on the way to success.

GuyThiebaut28-Dec-07 0:02

28-Dec-07 0:02

Try something like this:

<br />
CREATE TABLE #MyTempTable (salary decimal(28,12))<br />
INSERT INTO #MyTempTable  <br />
SELECT salary FROM employeedetails<br />
GROUP BY salary <br />
<br />
CREATE INDEX salary <br />
ON #MyTempTable (salary DESC)<br />
<br />
SELECT * FROM #MyTempTable<br />

Regards

Guy

You always pass failure on the way to success.

modified on Friday, December 28, 2007 6:15:09 AM

vimal_yet28-Dec-07 0:54

28-Dec-07 0:54

Thanks Guy....

It sounds good.and this was the one i guessed....

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

Insert text to sql server 2000, single quotation appears occationally

Pete O'Hanlon28-Dec-07 0:34

Pete O'Hanlon

28-Dec-07 0:34

This sounds very suspiciously like homework to me. We don't actually do your homework for you, so you'd better let us know what you've tried beforehand.

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

My blog | My articles

followait27-Dec-07 1:56

followait

27-Dec-07 1:56

for (...) {
  s.Format("%s",toInsert);
  pConn.Execute(...);
}

Sometimes toInsert contains single quotation mark(s), how to do deal with it efficiently?

Thanks very much.

Re: Insert text to sql server 2000, single quotation appears occationally

N a v a n e e t h27-Dec-07 1:58

N a v a n e e t h

27-Dec-07 1:58

followait wrote:
Sometimes toInsert contains single quotation mark(s), how to do deal with it efficiently?

Use parameterized query

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

My Website | Ask smart questions

Re: Insert text to sql server 2000, single quotation appears occationally [modified]

followait27-Dec-07 2:10

followait

27-Dec-07 2:10

Could give me some more guide?

pCmd->CommandText=_bstr_t(L"INSERT INTO tmp(id,a,b,c) "
			L"VALUES(?,?,?,?)");

Like this, how to go on?
Thanks.

modified on Thursday, December 27, 2007 8:22:18 AM

Re: Insert text to sql server 2000, single quotation appears occationally

N a v a n e e t h27-Dec-07 20:32

N a v a n e e t h

27-Dec-07 20:32

followait wrote:
pCmd->CommandText=_bstr_t(L"INSERT INTO tmp(id,a,b,c) "
L"VALUES(?,?,?,?)");

In VC I don't know. C# it could be

INSERT INTO tmp(id,a,b,c) VALUES(@id,@a,@b,@c)
CommandObject.Parameters.Add(@id,value);
CommandObject.Parameters.Add(@a,value);
CommandObject.Parameters.Add(@b,value);
CommandObject.Parameters.Add(@c,value);

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

My Website | Ask smart questions

Nested Select query

Poonam Gandash26-Dec-07 20:50

Poonam Gandash

26-Dec-07 20:50

"select * from (select username,designation, count(*) as points from (select username,designation from messages union all select username,designation from replies) group by username,designation) order by points desc"

this query works fine with MS Access but not with SQL Server.

Through this query I am listing most active members of forum by counting no. of message and replies. Members are 2 types- Students & Professionals

PLZ.... Help..

Krish - KP26-Dec-07 23:30

Krish - KP

26-Dec-07 23:30

hope you are getting error message at group by clause
if so, try this

select * <br />
from (select username,designation, count(*) as points <br />
      from (select username,designation <br />
	    from messages <br />
	   union all <br />
	    select username,designation <br />
	    from replies<br />
	   )t1 <br />
      group by username,designation<br />
     )t2<br />
order by points desc

Regards
KP

Poonam Gandash27-Dec-07 0:44

Poonam Gandash

27-Dec-07 0:44

Thanks a lot it worked for me..

I rated u 5

This is 4 u Rose | [Rose]

andyharman26-Dec-07 23:33

andyharman

26-Dec-07 23:33

Try:

select * from (
  select username, designation, count(*) as points
  from (
    select username, designation from messages
    union all
    select username, designation from replies
  ) as A
  group by username, designation
) as B
order by points desc

You need to provide table aliases. I'm not sure where menber-types fit into this.

Regards
Andy

vimal_yet27-Dec-07 0:13

Re: Database Design Issue

27-Dec-07 0:13

What is the exact purpose of this Query ???

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

Database Design Issue

Mostafa Siraj26-Dec-07 19:57

Mostafa Siraj

26-Dec-07 19:57

I'm building a web application which has lots of users, each with lots of security rules. what is better???
1- to make a table for users and another table for permissions. and insure by coding(in ASP.NET for example) the security
2- to create for each user in the system new user in the DBMS itself and assign the security from the database.

Thanks in Advance

vimal_yet27-Dec-07 0:18