|
Hello,
I want to write a query something like the following
UPDATE INCOMETABLE SET NAME ='PETER',AGE=30 WHERE RECORDNO = 10;
In the above what should be the keyword of RECORDNO
or there is another way of writing it
THANKS
Prithaa
|
|
|
|
|
Hi,
There is not such a keyword in Sql Server.
(There is one in Oracle, but it's a bad practice to use it in such a case)
What you should do is to use a primary key in the INCOMETABLE table.
UPDATE INCOMETABLE SET NAME ='PETER',AGE=30 WHERE EMPLOYEEID = 10
Uri
|
|
|
|
|
Hello,
Thanks,I got it.
Prithaa
|
|
|
|
|
i have two tables in my database parentTbl with primary key id and childTbl with foreign key pId. i created a relationships between them is it possible to ensure that the record in the parentTbl can not be deleted if it is been used in a record in childTbl.
i want to this from a database level i know if i was using store procedure i could always put a check but i was wondering if open the database and the table directly and try to delete record if i can set up the constraints to even prevent this from occurring once there is a corresponding record in the childTbl
|
|
|
|
|
This is what a foreign key is for. Ensure that it doesn't perform a cascade delete then the database will take care of this for you automatically.
the last thing I want to see is some pasty-faced geek with skin so pale that it's almost translucent trying to bump parts with a partner - John Simmons / outlaw programmer
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
What is the best practice to get multiple output values of stored procedures from ASP.net...
I am doing as below. IS it best practice or you have some good suggestion?
1) At the end of my SP, I am doing SELECT for all output parameters.
2) In ASp.net, i am calling SP thru ExecuteReader from DAL layer.
3) Storing datareader in DATATABLE in Business Layer
4) Passing DataTable to UI layer.
Please suggest....
Amit
|
|
|
|
|
Amit Kumar G wrote: 1) At the end of my SP, I am doing SELECT for all output parameters.
Do you mean you have multiple parameters where the direction is set to output, or do you mean you just call SELECT several times.
Amit Kumar G wrote: 2) In ASp.net, i am calling SP thru ExecuteReader from DAL layer.
3) Storing datareader in DATATABLE in Business Layer
This is what a data adapter already does. You should try and avoid duplicating functionality - unless of course you have some subtle, but important, differences between what the data adapter produces and what you are producing.
Amit Kumar G wrote: 4) Passing DataTable to UI layer.
Personally, I wouldn't pass a data table to the UI unless it was an application to manipulate databases. I'd have the data transformed into business objects and pass the business objects to the UI.
|
|
|
|
|
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.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
