|
UPDATE TableName
SET overtime = 40
WHERE emp_id = 5
or
UPDATE TableName
SET overtime = overtime - 10
WHERE emp_id = 5
I don't speak Idiot - please talk slowly and clearly
I don't know what all the fuss is about with America getting it's first black president. Zimbabwe's had one for years and he's sh*t. - Percy Drake , Shrewsbury
Driven to the arms of Heineken by the wife
|
|
|
|
|
Thanks I have done
UPDATE TableName
SET overtime = overtime-10
WHERE emp_id = 5
|
|
|
|
|
hi
how i can backup my entire database using pl/sql developer Tool
ver 7.1 ?
(i work with oracle 10g)
thank's in advance
|
|
|
|
|
i want to know how can I install sql express 2005 from commandline and include all features and components except the management studio and also speceficy instance TICSSQL not SQLEXPRESS?
|
|
|
|
|
Here is the full guide how to do that.
Life is a stage and we are all actors!
|
|
|
|
|
How does one add an .rdl report created in SQL Server Business Intelligence Studio to a Visual Studio project and view it in a reportviewer?
I've tried to rename the file from .rdl to .rdlc and then added it to my project. I've also recreated the dataset that the report uses in my project, but in the 'ReportViewer Tasks smart tags panel', in 'Choose Data Sources', there is no datasets to choose from to connect to my report. I don't know how to hook my report up to the dataset.
Any help would be appreciated.
|
|
|
|
|
Hi all,
How to insert values to a temptable by executing a storedprocedure...
Ex :-
INSERT INTO TempYearEndBal exec BLYearEndLeaveTcktBalRep;
Getting error while trying to insert the values to "TempYearEndBal" by executing the SP "BLYearEndLeaveTcktBalRep"...
can anybody help me to come out from this issue...
Thanks in Advance...
|
|
|
|
|
Not sure about Oracle but you cannot do this in SQL Server (and I would be surprised if Oracle supports this).
In SQL Server I would change your temptable to a global temp table and do the insert in the BLYearEndLeaveTcktBalRep proc.
|
|
|
|
|
U can do this in SQL server....
Inside the SP itself create the temp table and try to insert like :
INSERT INTO #TempYearEndBal exec BLYearEndLeaveTcktBalRep
this will work....
But in Oracle,what is the equlent way to do this?...
|
|
|
|
|
rs1.Open "SELECT Count(1)FROM (SELECT DISTINCT mt1.TestCaseName, mt1.TestScriptName, " & _
"mt1.FinalStatus FROM (Metrics_TestCases " & _
"AS mt1 INNER JOIN MaxScriptQuery as mt2 ON( mt1.TestCaseName = mt2.TestCaseName And " & _
mt1.TestScriptName = mt2.TestScriptName And mt1.ReleaseVersion = mt2.ReleaseVersion and " & _
"mt1.TestScriptID = mt2.maxTestScriptID) ) INNER JOIN Release_chart as tr ON mt1.ReleaseVersion = tr.ReleaseVersion) " & _
" ", oConnection, adOpenStatic, adLockReadOnly
This is the query i used to get some data from access table.
MaxScriptQuery is a inner query i used to join .
MaxScriptQuery - SELECT DISTINCT TestCaseName, TestScriptName, ReleaseVersion, MAX(TestScriptID) AS MaxTestScriptID
FROM Metrics_TestCases GROUP BY TestCaseName, TestScriptName, ReleaseVersion;
This query worked fine some week before. But to my surprise now the same query with same set of data is taking too much time. I dont know why the query is suddenly slowed up. CPU usage is also very high while running this query
|
|
|
|
|
Access is a dog - I would compress & repair the database and see if it improves the response. Look into adding any required indexes.
|
|
|
|
|
Thanks for your reply Holmes.
But dont know how to compact and repair without exiting the application in VBA.
Normally the compact and repair is used while exiting the application . How to apply it for a running code?
|
|
|
|
|
Hi,
Don't use Distinct key word its will reduce the performance. Without distinct also given the same result because you are using group by class. So no need distinct key word. Just remove and check it.
|
|
|
|
|
Well, I posted an entry explaining this yesterday but it seems to have disappeared. Not sure what happened there. I was having a few problems accessing the site yesterday.
I can't be bothered writing it all again, but basically you cannot compact a database while it is open. If you want to run the compact from code, you must run it from a different database. Then you can use DBEngine.CompactDatabase, making sure that the data file is closed and is not in use before you do the compact.
|
|
|
|
|
need help to solve this error. this error occours while i m sending mails to the other server..for local serevr its working fine.
|
|
|
|
|
Gentleman,
I have been using MSSQL 2000 for 6 years with no issues, but now am being required to use version 2005. I installed a new factory version on a new server using Win 2003 Server and am receiving the following error:
"The SQL Server Client cannot connect to the server. This error could occur because the firewall on the sever has refused the connection."
Now....this is a connection on the local host of the machine used with just Windows Authentication. The MSFT guide suggests that firewall on the server instance needs to be configured to accept connections. Since this is all on the same machine, I do not understand this, nor can I find where this can be done in the server windows. I have looked in the Configuration Manager and the Management Studio. Where do I go from here? Many Thanks in advance, Pat
|
|
|
|
|
Win Server 2003 is not letting you to connect to the Sql Server , just add an exception in Firewall for Sql Server to add exception goto Start,Run,write FIREWALL.cpl and in Exceptions tab add an exception
and some times Antivirus software also blocks so check that also if abv solution does not work
Best Of Regards,
SOFTDEV
If you have knowledge, let others light their candles at it
|
|
|
|
|
Good Morning Softdev,
Thank you for the insight. Well, I went to add the code as you suggested only to find out that I never turned the firewall on to start with since the machine is not yet online. And since this was intended to be a training machine for me rather than a network server, I have not yet installed any anti virus. As I stated earlier, this machine is absolutely clean and has never had anything on it, so that seems to eliminate these solutions. It has been upgraded to Service Pack 2 though, if that makes a difference. Although I do intend to network it eventually so that I can simulate connections from a remote computer (my next project), for now, all I want to do is learn the new administration qualities of 2005, and it does not need to be online for me to do that. The many times I installed SQL 2000 it always worked immediately upon installation. I appreciate your time....so what's next? Thanks Much...Pat
|
|
|
|
|
Good Morning ,
Can you check this
goto
Sql Server Configuration tools --> SQL Server Configuration Manager
-- Check Sql Server Browser is Running
-- Click on your Network Configuration, Select Server and check
Protocols are enabled or not
Sql Server Configuration tools --> SQL Server Surface Area Configuration
-- Surface Area Config. For Services and Connections
Click on Database Engine >>Remote Connections and CHECK its Configured for
Local and Remote Both Connections
-- Make Sure that Service is Running
Make Sure that Service Is Running
Make sure also you are Providing the Correcting Name
Check the Slash Wrong(/) Correct (\)
Also if you created Named Instance then it will be your System Name then your
Instance Name ; like Machine\Instance in this use try Machine\.
Best Of Regards,
SOFTDEV
If you have knowledge, let others light their candles at it
|
|
|
|
|
Well Softdev,
Now I am really confused! When I open up the SQL 2005 Services, there are only two heading in there....Integration and Reporting which are both running. There is no item called browser. In protocols under Native Client Config, VIA is not enabled, the other three (Memory, TCP/IP, Named Pipes) are enabled. When I open up the management studio, under database engine, it does not show the local machine. However, the network setting does see the other computer on the system. I seem to have lost the Local Database engine, yet I have not done anything except to let the system install by itself. Where do I go from here? I have been tempted to uninstall the whole thing and to just install VS 2008 and let it install the 2005 Lite version....but it seems like such a waste since I have the Enterprise copy already here. I would rather fix this one. Next??..Thanks, Pat
|
|
|
|
|
I send you one image . please check , do your "SQL Server Surface Area Configuration" look like this or not if not then i think so you have not installed SQL Server Database Engine.
Best Of Regards,
SOFTDEV
If you have knowledge, let others light their candles at it
|
|
|
|
|
S0FTDEV wrote: i think so you have not installed SQL Server Database Engine
Yes...you got it! It just goes to show you...things that are NOT INSTALLED will not work. I do not understand how this entire installation can be done without the basic database, but that's Microsoft for you. I reinstalled the application and am now able to see the master database. It seems more complex to use (to me) than the original 2000 was, but at least it is there. Now, I just have to figure out the administration works so I can use it. Many many thanks. Your help is really appreciated.
Best Regards, Pat
|
|
|
|
|
u r welcomed
Best Of Regards,
SOFTDEV
If you have knowledge, let others light their candles at it
|
|
|
|
|
Dear All,
I am in doubt with Simple Recovery Mode in SQL 2005.
My Case follow bellow.
I have two server located in different location which uses merge replication.
Server A which is publisher uses Simple Recovery Mode.
My question is If transaction in SERVER A is succesfull and yet data is not replicated to SERVER B or the transaction fails to occur in SERVER B which is a subscription.
what happens with that log? does it occurs in SERVER B or its ommited from log? this is where i doubt in simple recover mode.
As I said that I am using Simple Recovery Mode in SERVER A which is publisher.
Abdul Rahaman Hamidy
Database Developer
Kabul, Afghanistan
|
|
|
|
|
hi
i want to have an stored procedure that retrieve the file path of the Specific database as a parameter
i used to use sp_helpDB and fetch the data as in table but i can not return its file path as a parameter
simply i want to check the path of the "Logic_database_name" and return it as in nvarchar parameter
what can i do?
thanks in advance
|
|
|
|