Solved

Current date is shown after query run

Posted on 2008-10-30
15
146 Views
Last Modified: 2011-10-19
SQL Server 2005

In management studion, current date is being shown after query is run. Previousl it used to show number of rows affected. Probably I have changed some setting. What did I change. How to resolve the issue.

0
Comment
Question by:Mehram
  • 6
  • 4
  • 3
15 Comments
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
Comment Utility
can you show what you get exactly?

I only know about this kind of output:
SQL Server Execution Times:
   CPU time = 0 ms,  elapsed time = 1 ms.
SQL Server parse and compile time: 
   CPU time = 0 ms, elapsed time = 1 ms.

Open in new window

0
 

Author Comment

by:Mehram
Comment Utility

There are two tab.

1. Result
2. Message

I am updating a table.
16 rows updated.

The query shows current date in result pane. When I click message tab, I can see 16 rows updated.

The result tab should not have been shown.
0
 

Author Comment

by:Mehram
Comment Utility
It seems that I have left

select getdate() somewhere, because the problem is removed right now.
0
 
LVL 60

Expert Comment

by:chapmandew
Comment Utility
Yeah, you probably just had a select getdate() or a print getdate() in there.
0
 

Author Comment

by:Mehram
Comment Utility
No.

I executed this

Insert count (count_code, count_name,active_tag)
values ('0875MLT','08.75/s Multi','Y')

mateen.bmp
0
 
LVL 60

Accepted Solution

by:
chapmandew earned 300 total points
Comment Utility
Is there a trigger on the Count table that does a select getdate()?
0
Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

 
LVL 142

Assisted Solution

by:Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3] earned 200 total points
Comment Utility
please check for a trigger for table your inserted into.
0
 

Author Comment

by:Mehram
Comment Utility
You are absolutely right.
0
 
LVL 60

Expert Comment

by:chapmandew
Comment Utility
thought it might be....
0
 
LVL 60

Expert Comment

by:chapmandew
Comment Utility
Hmmm...that doesn't seem right to do that.  :(
0
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
Comment Utility
unless you disagree that chapmandew posted the same information 4 minutes before me, I suggest that this question get's reopened for at least a points split

angel eyes
0
 

Author Comment

by:Mehram
Comment Utility
OK. Please re open and distribute the points 50/50.
0
 

Author Closing Comment

by:Mehram
Comment Utility
It was my mistake.
0

Featured Post

Get up to 2TB FREE CLOUD per backup license!

An exclusive Black Friday offer just for Expert Exchange audience! Buy any of our top-rated backup solutions & get up to 2TB free cloud per system! Perform local & cloud backup in the same step, and restore instantly—anytime, anywhere. Grab this deal now before it disappears!

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
get all customers 2 38
Dataset not reading table data 12 41
sql Audit table 3 46
How can I get this column in my query? 2 28
I am showing a way to read/import the excel data in table using SQL server 2005... Suppose there is an Excel file "Book1" at location "C:\temp" with column "First Name" and "Last Name". Now to import this Excel data into the table, we will use…
When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

6 Experts available now in Live!

Get 1:1 Help Now