SQL - SELECT statement

Question

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Ray M SSC-Insane Points: 21093 More actions · Answer 1

Well,

If you execute this code alone, how many records are returned?

select substring(name,1,30) as Banco,

CAST( ( FILEPROPERTY( name, 'SpaceUsed' ) * ) / 1024 AS numeric( 10, 2) )

FROM sysfiles

More than 1.

So which one do you want to use to set the variable to?

sswords SSCrazy Eights Points: 8207 More actions · Answer 2

IANAD, (I am not a developer) but see if this helps:

My hovercraft is full of eels.

David A. Long SSCrazy Eights Points: 8421 More actions · Answer 3

Try:

declare @tamanho varchar(10)

select @tamanho=substring(name,1,10),

--CAST((FILEPROPERTY(name, 'SpaceUsed')* 8)/1024 AS numeric(10,2))

FROM sysfiles

SELECT @tamanho

or:

declare @tamanho varchar(10)

select @tamanho=

--substring(name,1,30) as Banco,

CONVERT(varchar(10),CAST((FILEPROPERTY(name, 'SpaceUsed')* 8)/1024 AS numeric(10,2)))

FROM sysfiles

SELECT @tamanho

or:

declare @tamanho numeric(10,2), @banco varchar(30)

select @banco=substring(name,1,30),

@tamanho=CAST((FILEPROPERTY(name, 'SpaceUsed')* 8)/1024 AS numeric(10,2))

FROM sysfiles

SELECT @banco, @tamanho

Andy

bledu SSChampion Points: 12335 More actions · Answer 4

i think the question we should be asking Flavio is 'What do you want to do?' before we suggest any solution

Everything you can imagine is real.

Flavio Bendl SSC Rookie Points: 37 More actions · Answer 5

Dear All,

I need to make a monthly control on disk space on SQL 2000 Server. I have 3 servers.

I thought to create a table and to insert the SELECT result in table.

I don’t know very well SQL 2000 and DBA procedures.

If somebody knows some procedure to make it, please help me.

*****Replay to David A. Long

Your select is returning only one record (Log file) . I would like seeing all records this table, but, it´s very good.

Thank you

sswords SSCrazy Eights Points: 8207 More actions · Answer 6

See if this article helps.

My hovercraft is full of eels.