|
|
I need to roll back a stored procedure because just altered, By mistake. I need to change the Stored procedure to older version.
I don't have back up of that SP.
Please let me know what should i do?
D.Willington
|
|
|
|
|
Restore from database backup - you do have one don't you?
Restore from your source control system?
Otherwise you are out of luck, SQL does not do versioning.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
Hi Bob
Thanks for your help.
Regards,
Willington.d
D.Willington
|
|
|
|
|
No problem, but I bet its not what you were hoping for 
Bob
Ashfield Consultants Ltd
|
|
|
|
|
There was some discussion in the Lounge yesterday qualifying for DailyWTF indicating a delete statement without a where condition.
People are so stingy to maintain db backups and repent only when disaster strikes.
Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips
A pessimist sees only the dark side of the clouds, and mopes; a philosopher sees both sides, and shrugs; an optimist doesn't see the clouds at all - he's walking on them. --Leonard Louis Levinson
|
|
|
|
|
Hi all,
i have one doubt , i want to export stored procedures data from sqlserver2000 to ms access, give me any idea .
thanks & regards
sarp
sarp
|
|
|
|
|
You will probably need to rewrite them as Access does not use the same syntax as SQL Server in many instances.
You can export stored procs from enterprise manager by scripting them as create, but I doubt it will help.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
The SQL to Access transition would relatively require a manual intervention at least with respect to Stored Procedures.
Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips
A pessimist sees only the dark side of the clouds, and mopes; a philosopher sees both sides, and shrugs; an optimist doesn't see the clouds at all - he's walking on them. --Leonard Louis Levinson
|
|
|
|
|
Hi! i have an in_tblxyz on the table tblxyz (non-clustered). i want to add, delete, or rearrange columns in this index. can any one help me?
|
|
|
|
|
You need to drop and recreate the index with the columns you require. You cannot change an index.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
Thanks. I'm using DROP_EXISTING = ON to modifying existing indexes. it first delete the existing index & then creates a new.
|
|
|
|
|
No problem, pleased I could point you in the right direction
Bob
Ashfield Consultants Ltd
|
|
|
|
|
whats the best book for sql for mysql
|
|
|
|
|
MySQL has books ? I thought it was all online help because it's all free ?
You'd do better if you used an intelligent subject, so people browsing who know the answer, have an idea to look at your question.
Christian Graus
Please read this if you don't understand the answer I've given you
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Hello. Is anybody knows that It is ok to use char data type for date and Time i SQL Server 2005? Can it be used in comparison as well as use Date and Time data type? Is it a good idea to do it?
|
|
|
|
|
You can use it, but it's not a good idea. You should always use the most appropriate type for the data you want to store.
|
|
|
|
|
|
|
Let me put this in stronger terms NO YOU SHOULD NEVER STORE DATES AS STRINGS
Storing date as varchar is going to cause you problems in the future. You will see many questions here where the root cause is a date/string conversion.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Hi
please am new linq to entities, my question does linq support oracle or mysql? If there is any other database it support please list it out.
thanks
|
|
|
|
|
Why don't you just Google for "Linq Oracle" or "Linq Mysql" to find out whether they are supported or not?
By the way, there is a Linq forum for questions about Linq
Giorgi Dalakishvili
#region signature
my articles
#endregion
|
|
|
|
|
Yes. Now do a bit of research in Google and find out what I've just answered yes to.
|
|
|
|
|
Hi all,
i am using sql server 2005.
let me explain the scenario.
i have report where i bring perticular employee totalcall and workeddays then in third field i wrote an expresion to evaluate avg call that is totalday/workeddays and all the three field i displayed in table now requirment is in footer i should get avg of avgcall calculated
please suggest some idea
thank you
regards
imran khan
|
|
|
|
|
Look into the compute keyword in BOL.
Compute avg(avg(calltime))
Caveat - this will give you 2 tables in your dataset when using dataset.fill
Never underestimate the power of human stupidity
RAH
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
