|
You're right, and I know this, but there seems to be no indication in the OP of a nested transaction - hence my comments and the modified version of the code.
-- modified at 10:45 Wednesday 25th July, 2007
[Edit]Reading my original post I see that I did mention the transaction count of 1 before the commit transaction leading to a transaction count of 0 afterwards.[/Edit]
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
|
okkishore wrote: how we will recover from database was lost or scatch.
It was deleted? Corrupted? The hard drive was thrown into a vat of acid?
okkishore wrote: when there no is backrecovery
You mean you wern't keeping backups?
If you've completly lost the database and you have no backup then it's gone and your not getting it back. Maybe in future you'll do backups.
If it's not completly gone you might be able to use an undelete program or fix the corruption.
EDIT: I just checked your post below. Did you try and get rid of the duplicates without backing up and then delete the entire thing by accident? 
|
|
|
|
|
Well the wording you've used is complete nonsense.
|
|
|
|
|
What is the OP asking? I understand that it was an interview question, but how was the database lost?
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
|
|
|
|
|
okkishore wrote: how we will recover from database was lost or scatch
Huh? What kind of stupid interview question was that? Without backing up the database, losing it or having the disc being scratched is pretty much a nail in the coffin for the database, unless you have very pricey hardware to pull data bits off hard disk platters.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
|
|
|
|
|
how can we delete duplicate rows when we are not using constraints
usings query only
kishore kumar.B
|
|
|
|
|
Select all the field you are concerned about and do a group by with a having
Something like this:
Select col1, col2, col3, col4, col5 from yourTable
group by col1, col2, col3, col4, col5
having count(*) > 1
Hope that helps.
Ben
|
|
|
|
|
it can't deleting it only selecting.
for select we are also
select select DISTINCT * from tablename
i need for deleting not for selecting
kishore
|
|
|
|
|
The query I gave you is to identify the duplicates. Once you have the duplicates there are several things you can do to delete them. If you already know how to identify the duplicates then you should be able to delete them. You can not use a distinct since that removes the duplicates. Do you have any id column or key column to uniquely identify each column?
Ben
|
|
|
|
|
any one i what that means the table that can have duplicate rows or particular rows.i already mension i can't give any constraints .
|
|
|
|
|
Ok well, if you don't have any unique key you should create one. Add a new column that is an identity. Then if you really don't which record you keep you can do a delete statement like this:
delete from yourTable yt
join
(Select max(id),col1, col2, col3, col4, col5 from yourTable
group by col1, col2, col3, col4, col5
having count(*) > 1) temp on yt.id = temp.id
Ben
|
|
|
|
|
Hi all,
I am using SQLServer2000,
I am trying to insert large amount of data into column of a table but i found only part of the data getting inserted into the table.
Then i have tried the following option to set the column size
sp_tableoption 'testmail', 'text in row', '7000'
After the above line get executed its better but still i am lagging behind to store total text .please help me some one
Thanks in advance
Yuva
|
|
|
|
|
the most data you can store in a row is 8000 bytes (so thats 8000 ascii charecters or 4000 unicode). If you need to store more than that you need to chop up the text and store it in multiple rows.
|
|
|
|
|
hi originSH ,
Thanks for your reply but my requiremet is store all the date ito one column i cannot chop up teh thing because i am getting that text dynamically..The text in the form of html
Thanks in Advance
Chandra Gupta
|
|
|
|
|
Change the datatype to text (or ntext for Unicode). Text stores 2^31 characters, and NText stores 2^30 characters.
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
hi Pete O'Hanlon,
I have used text data type only but it is not allowing me store whole text(Actually the text in the form of HTml) into my Database
|
|
|
|
|
Hi There,
I need some assistance with a database problem.
I am using Microsoft SQL Server 2005, one of the tables primary key has been deleted. How can I check when the changed was made and by which user as there are multiple users with administrative rights?
All of your help is greatly appreciated.
Regards,
BassRider
|
|
|
|
|
check your transaction log - if someone is messing around with this kind of stuff get triggers or alerts set up on your database when they are modifed, that way you can find out imediately and record user, date, time to get a better iddea of what's going on!
|
|
|
|
|
Hi,
In SQl seerver 2005 we have a table with a coloum as Image. data type In the Stored procedure we are using Insert statement to add the image stream to coloum. All our image files are nearly 400 KB of size. The insert statement is doing its job.Our problem its talke nearly 18 seconds to do the insert. Is there any way we can tune up performance or any alternates for it.
Regard
|
|
|
|
|
does this have to be stored in sql server? it is not a recommended practice, a better solution would be to store them in a location and hold a simple location within your database.
|
|
|
|
|
Its a customer requirement.
Is there an way to solve it.
|
|
|
|
|
Dear All,
I am using asp.net2.0, C#, sql2005 using Visual studio 2005
I am storing imagepath in field of table whose datatype is nvarchar(250).
My problem is when I pass as argument of \\\\servername\\directory\\imagename it stores as \\servername\directory\imagename I would like to it as argument passed so that I can just fetch the url and display image
Please guide me
Thanks
imaran khan
|
|
|
|
|
Backslash doubling is an issue for literal strings in C-derived languages because the backslash character is used as an escape, to allow non-printable characters to be specified. Therefore to get an actual backslash in the output, you must double it. This is the same as using "" in a VB literal string to indicate a single " character (otherwise a " ends the string). If you output the final string to the console, you will see that any doubled backslashes in the literal have become single backslashes in the actual string.
C# also supports @-literals, where you place an @ before the first " character. In this type of string literal, the backslash character does not operate as an escape, it represents an actual backslash. The only escape sequence is "" to represent a single " character.
Therefore the following literals are equivalent:
string regular = "\\\\servername\\directory\\imagename";
string atLiteral = @"\\servername\directory\imagename";
System.Diagnostics.Debug.Assert( regular == atLiteral ); You do not need to pass - indeed, it is strictly an error to pass - doubled backslashes to the filesystem. It treats multiple backslashes as indicating no change of directory. You can make a canonical path, that is with any multiple backslashes removed and any directory change (. or ..) parts processed, by calling Path.GetFullPath. A double backslash is only significant at the beginning of a path, where it indicates that the first part of the path is a machine name for a UNC path.
|
|
|
|
|
I have three tables
Item(Item_ID, Item_Name)
1 shirt
2 hat
Color(Color_ID, Color_Name)
1 blue
2 red
3 green
Item_Color(Item_Color_ID, Item_ID, Color_ID)
1 1 1
2 1 2
3 2 1
4 2 2
5 2 3
What is the query that would give me the result:
Item_ID Item_Name Color_Name1 Color_Name2 Color_Name3
1 shirt blue red null
2 hat blue red green
I seem to continue to come up short.
I tried:
Select Item_Name, GROUP_CONCAT(DISTINCT Item_Color) FROM Item Left Join Item_Color On Item_Color.Item_Id=Item.Item_ID Left Join Color ON Item_Color.Color_ID=Color.Color_ID Group By Item_Name
but this returns the colors in a blue,red,green format, not in seperate columns.
-- modified at 20:01 Tuesday 24th July, 2007
Thanks!
Sean Murphy
"All things great and small start at the same point, the first step."
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
