|
Colin Angus Mackay Wrote:
Do you mean you have multiple parameters where the direction is set to output, or do you mean you just call SELECT several times
Reply : Multiple paramters set as Output
Amit
|
|
|
|
|
Hi friends
I know that System.Transaction works with SQL Server 2005, but .... Does it work with SQL Server 2000, or Oracle ?
Thanks in advance
PD: happy 2k7
|
|
|
|
|
how consistancy is maintained when a number opf different user tries to update arecord at the same time
|
|
|
|
|
Kumar Nilesh wrote: how consistancy is maintained when a number opf different user tries to update arecord at the same time
The database locks the rows when updates are happening.
|
|
|
|
|
Hello Im a beginner one in programming. My first problem is, How can i view a image file from the database(sql 2005) as "image" to visual basic 2005.
for example:
a text viewed in the textbox from database.
the code is.
textbox1.text=rs.fields("text").value
My problem is how can i view the image from database if the image DATA TYPE IS "image".
Please help me. Thank you very much and God bless.
|
|
|
|
|
naglayas wrote: rs.fields("text").value
What is rs ? I don't recognise any class that has a fields method on it.
naglayas wrote: My problem is how can i view the image from database if the image DATA TYPE IS "image".
The value in an image column will arrive as a byte array. What you do with that byte array really depends on what it actually represents.
|
|
|
|
|
Colin Angus Mackay wrote: What is rs?
|
|
|
|
|
Paul Conrad wrote: Colin Angus Mackay wrote:
What is rs?
Well, yes, those were exactly my thoughts. The OP has some code with an object called rs and he expects us to know what it is. I've no idea what it is, so it makes it very difficult to help.
|
|
|
|
|
Colin Angus Mackay wrote: object called rs and he expects us to know what it is. I've no idea what it is
My ultra wild guess is some kind of record set...
|
|
|
|
|
Paul Conrad wrote: My ultra wild guess is some kind of record set...
But there are no RecordSets in Visual Basic 2005 - so it still leaves me confused.
|
|
|
|
|
Colin Angus Mackay wrote: RecordSets in Visual Basic 2005
True. I am thinking of the old days with MS Access + VBA and rs was commonly RecordSet. Maybe the OP has the two mixed up. I noticed the OP refers to SQL 2005 so I am really confused about the whole thread
|
|
|
|
|
|
gnadeem wrote: i suppose this will be helpfull.
It looks like it could. I found it very interesting
|
|
|
|
|
Again I got bit by the default CommandTimeout being too dang short.
|
|
|
|
|
PIEBALDconsult wrote: Again I got bit by the default CommandTimeout being too dang short
30 seconds is too short?! I presume this isn't a very interactive piece of software that you are writing.
|
|
|
|
|
Colin Angus Mackay wrote: 30 seconds is too short?
I would almost say that is too long of a time
|
|
|
|
|
I usually write backend, batch, service kinds of things, so I usually set CommandTimeout to 0 (unlimited).
In this case, it is interactive so I left it set at the default. But... it's a simple messaging system; I'm using a RichTextBox, and putting the "message" into an NVARCHAR(MAX) (Sql Server 2005). It turns out I can drag and drop more than just text in the RichTextBox (graphics, sound, video, etc.) which is very cool (glad I don't have to impliment it myself). It works fine on my desktop which also holds the database, but my cow-worker across town kept getting timeouts when trying to retrieve "messages" of 5MB or more (in one case an msi file of 400MB).
I should clarify that the message pull is performed by a worker thread in the client, so the interface is not hindered by the long-duration query.
Ah, well,
|
|
|
|
|
Hi - Where would information on the indexes created for tables be stored?
Like we can get a whole lot of information on table, stored proc, function by selecting from sysobjects.
Thanks.
|
|
|
|
|
Never mind - found it.
select * from sys.indexes
|
|
|
|
|
Hi,
I need to store large amounts of text (upwards of 20,000 words). I was wondering what is the best type to use, or is this not possible. Will I need to store them as files with links in the DB?
Thanks in advance
|
|
|
|
|
You can use an ntext column type to store upto 2Gb of text.
|
|
|
|
|
When I try to connect to SQLServer..It gives me an error saying "Connection Failed.Check with Registration Properties"..
My SqlServer Service Manager doesnt start. I hope its expiry date is on..Is there a way that i can run it as it was before..Please help me..
|
|
|
|
|
lehya wrote: I hope its expiry date is on..
What expiry date?
|
|
|
|
|
Hi All,
I want to debug a stored procedure in Sql Server 2005. But no option is available for this. I read somewhere that Business Intellegence Development Studio is required. So i tried to install it. But the setup application gave a message that the studio is already installed. Then i read somewhere that VS.Net 2005 is the BIDS. I already have VS.Net 2005 installed on my machine along with SQL Server 2005. But the "Step into Stored Procedure" option is not available under vs.net 2005.
Hope i am clear enough. I just want to enable debugging in Sql Server 2005, if possible without depending on VS.Net 2005.
Thanks !
"A good programmer is someone who looks both ways before crossing a one-way street." -- Doug Linder
coolestCoder
|
|
|
|
|
Hi - You do need the SQL Server Business Intelligence Development Studio to debug stored procs - which is a part of SQL Server 2005.
I have used this feature and it is very, very helpful in debugging stored proc by stepping into them.
Vani
|
|
|
|