Viewing 15 posts - 31 through 45 (of 102 total)
i too was on the side of storing images into database. But the only reason i had to forgo that option was the response object in asp. I was unable...
May 11, 2002 at 10:25 am
Sorry Steve, but I think you are missing out somewhere. RESPONSE object is ASP can set its contenttype only once. I have not tried it by using the ADO Streams...
May 11, 2002 at 8:24 am
How do you set contenttype for one response object? It can be sent only once. If you are able to do it twice on the same page, pls let me...
May 11, 2002 at 4:51 am
I had avoided storing into DB only for 1 reason. As I cannot show the image and the related text on the same web page. This is because, in ASP...
May 10, 2002 at 1:26 pm
I had avoided storing into DB only for 1 reason. As I cannot show the image and the related text on the same web page. This is because, in ASP...
May 10, 2002 at 1:26 pm
Does anyone have a reason why MS has not allowed Intersect, Minus queries even when they are allowed by most common databases. If such queries are allowed then many of...
May 10, 2002 at 11:56 am
Storing images onto file system would be better efficient. You would find managing the files better if stored into database. But are the best person to judge what should be...
May 10, 2002 at 11:54 am
1. User Defined Functions
2. XML Support
3. New Datatypes
4. Instead Of and After Triggers
5. Multiple Instances of RDBMS Engine on same machine
Many more, this is a few that i remember.
Paras Shah
Evision...
May 6, 2002 at 10:27 am
This should work. Not too sure as I haven't tried it. But according to my knowledge, temp tables are available till they are droppped.
quote:
April 28, 2002 at 2:40 am
Isn't there any alternative to OPENROWSET bcoz in OPENROWSET we have to pass username and password as 2 parameters. So when the username/password change on the server we manually need...
April 28, 2002 at 2:27 am
Create a table called Messages and everytime insert records into messages table with the username/userlevel who should be allowed to see that message. Then in your frontend you can create...
April 28, 2002 at 2:04 am
I want this for the local database. If I use if on the master database, I will have to do so same for the database on the web. The problem...
April 27, 2002 at 8:24 am
well you can use else if you carry out your validations
if condition1
BEGIN
-- do something
END
else if condition2
BEGIN
-- do something 2
END
else if condition3
BEGIN
...
April 27, 2002 at 8:14 am
Thankx for the help. It works fine. There are some utility stored procedures that I have created which I intend to use it in every database so to be on...
April 27, 2002 at 7:50 am
Try this...
insert into table_bigone(userid, text_con)
select
table1.userid,
table1.text1 + table2.text2 + table3.text3 + table4.text4
from
table1, table2, table3, table4
where
table1.user_id = table2.user_id and
table1.user_id = table3.user_id and
table1.user_id = table4.user_id
Paras Shah
Evision...
April 27, 2002 at 7:33 am
Viewing 15 posts - 31 through 45 (of 102 total)