Showing posts with label type. Show all posts
Showing posts with label type. Show all posts

Monday, March 26, 2012

fill up spaces with dots in a column

Hi,

I currently have a column in a table with data type char and length 500. However, not every column fills up the entire 500 length, and I would like to fill up the rest of the spaces with dots. Is there a setting in SQL to do this? I do not want to use varchar since I want a fixed length with dots at the end. Any ideas?

Thanks,
Alan

I can't really imagine why you would have that requirement, it is kinda backwards.

If your goal is to display the data padded with dots up to a total length of 500, then I'd suggest that you do use a varchar for storage of your data (without dots).
When you want to retrieve it, then you pad it. Something like this;

create table #x (mystring varchar(50) not null)
insert #x
select 'abc' union all
select 'defgh'

select mystring + replicate('.', 50 - len(mystring))
from #x

drop table #x
go


abc...............................................
defgh.............................................

Would that work as an idea for you?

/Kenneth

Wednesday, March 21, 2012

Files PDF into sql table.

I have 5 millions of file PDF (acrobat) to save into a sql table.
Wich type of field can i use into a table ?
Thank you, Checco.
You can use an IMAGE column. Why do you want to do this though?
Wouldn't it be easier just to store the file name? I don't think a PDF
could be very useful in a database.
This issue is discussed here:
http://www.aspfaq.com/show.asp?id=2149
David Portas
SQL Server MVP
|||There is a transform in DTS which will load the files into the database (
Search for Textcopy I think it is).
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Checco" <CheccoTogliLaForka@.Box.it> wrote in message
news:392pnnF5tn0h9U1@.individual.net...
>I have 5 millions of file PDF (acrobat) to save into a sql table.
> Wich type of field can i use into a table ?
> Thank you, Checco.
>
|||"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> ha scritto nel
messaggio news:1110195059.693757.152650@.g14g2000cwa.googlegr oups.com...
> You can use an IMAGE column. Why do you want to do this though?
> Wouldn't it be easier just to store the file name? I don't think a PDF
> could be very useful in a database.
>
I can save the files PDF in a file server... and access it by an URL like:
\\FileServer\Location\FileName but
i think that the access to a sqlserver is more fast than an access to a file
system, so, the files that i need is very much...
or not ?
Checco.
|||No. Keep your files in a filesystem instead, and save the path to them in a
table. Access to a filesystem is much faster. You might want to create
subfolders following some criteria, since keeping 5 million files in one
folder would be a little costly performance wise. You might want to create a
hash function for the subfolder name. That discussion is outside of the
scope of this group.
-Argenis
"Checco" <CheccoTogliLaForka@.Box.it> wrote in message
news:393299F5tg5j0U1@.individual.net...
> "David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> ha scritto nel
> messaggio news:1110195059.693757.152650@.g14g2000cwa.googlegr oups.com...
> I can save the files PDF in a file server... and access it by an URL
like:
> \\FileServer\Location\FileName but
> i think that the access to a sqlserver is more fast than an access to a
file
> system, so, the files that i need is very much...
> or not ?
> Checco.
>
|||Thank you.
Checco.
"Argenis Fernandez" <argenis@.spam.sucks.gmail.com> ha scritto nel messaggio
news:eZMNvqyIFHA.1860@.TK2MSFTNGP15.phx.gbl...
> No. Keep your files in a filesystem instead, and save the path to them in
> a
> table. Access to a filesystem is much faster. You might want to create
> subfolders following some criteria, since keeping 5 million files in one
> folder would be a little costly performance wise. You might want to create
> a
> hash function for the subfolder name. That discussion is outside of the
> scope of this group.
> -Argenis
> "Checco" <CheccoTogliLaForka@.Box.it> wrote in message
> news:393299F5tg5j0U1@.individual.net...
> like:
> file
>

Files PDF into sql table.

I have 5 millions of file PDF (acrobat) to save into a sql table.
Wich type of field can i use into a table ?
Thank you, Checco.You can use an IMAGE column. Why do you want to do this though?
Wouldn't it be easier just to store the file name? I don't think a PDF
could be very useful in a database.
This issue is discussed here:
http://www.aspfaq.com/show.asp?id=2149
--
David Portas
SQL Server MVP
--|||There is a transform in DTS which will load the files into the database (
Search for Textcopy I think it is).
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Checco" <CheccoTogliLaForka@.Box.it> wrote in message
news:392pnnF5tn0h9U1@.individual.net...
>I have 5 millions of file PDF (acrobat) to save into a sql table.
> Wich type of field can i use into a table ?
> Thank you, Checco.
>|||"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> ha scritto nel
messaggio news:1110195059.693757.152650@.g14g2000cwa.googlegroups.com...
> You can use an IMAGE column. Why do you want to do this though?
> Wouldn't it be easier just to store the file name? I don't think a PDF
> could be very useful in a database.
>
I can save the files PDF in a file server... and access it by an URL like:
\\FileServer\Location\FileName but
i think that the access to a sqlserver is more fast than an access to a file
system, so, the files that i need is very much...
or not ?
Checco.|||No. Keep your files in a filesystem instead, and save the path to them in a
table. Access to a filesystem is much faster. You might want to create
subfolders following some criteria, since keeping 5 million files in one
folder would be a little costly performance wise. You might want to create a
hash function for the subfolder name. That discussion is outside of the
scope of this group.
-Argenis
"Checco" <CheccoTogliLaForka@.Box.it> wrote in message
news:393299F5tg5j0U1@.individual.net...
> "David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> ha scritto nel
> messaggio news:1110195059.693757.152650@.g14g2000cwa.googlegroups.com...
> > You can use an IMAGE column. Why do you want to do this though?
> > Wouldn't it be easier just to store the file name? I don't think a PDF
> > could be very useful in a database.
> >
> I can save the files PDF in a file server... and access it by an URL
like:
> \\FileServer\Location\FileName but
> i think that the access to a sqlserver is more fast than an access to a
file
> system, so, the files that i need is very much...
> or not ?
> Checco.
>|||Thank you.
Checco.
"Argenis Fernandez" <argenis@.spam.sucks.gmail.com> ha scritto nel messaggio
news:eZMNvqyIFHA.1860@.TK2MSFTNGP15.phx.gbl...
> No. Keep your files in a filesystem instead, and save the path to them in
> a
> table. Access to a filesystem is much faster. You might want to create
> subfolders following some criteria, since keeping 5 million files in one
> folder would be a little costly performance wise. You might want to create
> a
> hash function for the subfolder name. That discussion is outside of the
> scope of this group.
> -Argenis
> "Checco" <CheccoTogliLaForka@.Box.it> wrote in message
> news:393299F5tg5j0U1@.individual.net...
>> "David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> ha scritto nel
>> messaggio news:1110195059.693757.152650@.g14g2000cwa.googlegroups.com...
>> > You can use an IMAGE column. Why do you want to do this though?
>> > Wouldn't it be easier just to store the file name? I don't think a PDF
>> > could be very useful in a database.
>> >
>> I can save the files PDF in a file server... and access it by an URL
> like:
>> \\FileServer\Location\FileName but
>> i think that the access to a sqlserver is more fast than an access to a
> file
>> system, so, the files that i need is very much...
>> or not ?
>> Checco.
>>
>

Files PDF into sql table.

I have 5 millions of file PDF (acrobat) to save into a sql table.
Wich type of field can i use into a table ?
Thank you, Checco.You can use an IMAGE column. Why do you want to do this though?
Wouldn't it be easier just to store the file name? I don't think a PDF
could be very useful in a database.
This issue is discussed here:
http://www.aspfaq.com/show.asp?id=2149
David Portas
SQL Server MVP
--|||There is a transform in DTS which will load the files into the database (
Search for Textcopy I think it is).
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Checco" <CheccoTogliLaForka@.Box.it> wrote in message
news:392pnnF5tn0h9U1@.individual.net...
>I have 5 millions of file PDF (acrobat) to save into a sql table.
> Wich type of field can i use into a table ?
> Thank you, Checco.
>|||"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> ha scritto nel
messaggio news:1110195059.693757.152650@.g14g2000cwa.googlegroups.com...
> You can use an IMAGE column. Why do you want to do this though?
> Wouldn't it be easier just to store the file name? I don't think a PDF
> could be very useful in a database.
>
I can save the files PDF in a file server... and access it by an URL like:
\\FileServer\Location\FileName but
i think that the access to a sqlserver is more fast than an access to a file
system, so, the files that i need is very much...
or not ?
Checco.|||No. Keep your files in a filesystem instead, and save the path to them in a
table. Access to a filesystem is much faster. You might want to create
subfolders following some criteria, since keeping 5 million files in one
folder would be a little costly performance wise. You might want to create a
hash function for the subfolder name. That discussion is outside of the
scope of this group.
-Argenis
"Checco" <CheccoTogliLaForka@.Box.it> wrote in message
news:393299F5tg5j0U1@.individual.net...
> "David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> ha scritto nel
> messaggio news:1110195059.693757.152650@.g14g2000cwa.googlegroups.com...
> I can save the files PDF in a file server... and access it by an URL
like:
> \\FileServer\Location\FileName but
> i think that the access to a sqlserver is more fast than an access to a
file
> system, so, the files that i need is very much...
> or not ?
> Checco.
>|||Thank you.
Checco.
"Argenis Fernandez" <argenis@.spam.sucks.gmail.com> ha scritto nel messaggio
news:eZMNvqyIFHA.1860@.TK2MSFTNGP15.phx.gbl...
> No. Keep your files in a filesystem instead, and save the path to them in
> a
> table. Access to a filesystem is much faster. You might want to create
> subfolders following some criteria, since keeping 5 million files in one
> folder would be a little costly performance wise. You might want to create
> a
> hash function for the subfolder name. That discussion is outside of the
> scope of this group.
> -Argenis
> "Checco" <CheccoTogliLaForka@.Box.it> wrote in message
> news:393299F5tg5j0U1@.individual.net...
> like:
> file
>