Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Current date is shown after query run

Posted on 2008-10-30
15
Medium Priority
?
154 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 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 22839622
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
ID: 22839813

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
ID: 22839830
It seems that I have left

select getdate() somewhere, because the problem is removed right now.
0
Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

 
LVL 60

Expert Comment

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

Author Comment

by:Mehram
ID: 22840139
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 1200 total points
ID: 22840159
Is there a trigger on the Count table that does a select getdate()?
0
 
LVL 143

Assisted Solution

by:Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3] earned 800 total points
ID: 22840193
please check for a trigger for table your inserted into.
0
 

Author Comment

by:Mehram
ID: 22840330
You are absolutely right.
0
 
LVL 60

Expert Comment

by:chapmandew
ID: 22840333
thought it might be....
0
 
LVL 60

Expert Comment

by:chapmandew
ID: 22840387
Hmmm...that doesn't seem right to do that.  :(
0
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 22840418
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
ID: 22847793
OK. Please re open and distribute the points 50/50.
0
 

Author Closing Comment

by:Mehram
ID: 31511600
It was my mistake.
0

Featured Post

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

by Mark Wills PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type transformation where we need the information held as data within a column to become columns in their own right. Now, in some cases that is relatively…
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…
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
In response to a need for security and privacy, and to continue fostering an environment members can turn to for support, solutions, and education, Experts Exchange has created anonymous question capabilities. This new feature is available to our Pr…

963 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