?
SolvedPrivate

SQL Server 2008 query syntax meaning in SSIS  SQL Task

Posted on 2014-04-03
7
Medium Priority
?
35 Views
Last Modified: 2016-02-10
Hi,

I have a  SQL Task in an SSIS job   that fires
DELETE FROM HISTORY WHERE RecordDate = ?

Open in new window

RecordDate is  of data type Date and is a Primary Key.
What exactly does this do?
Delete values that have a ? value?
any guidance appreciated, thanks
0
Comment
Question by:blossompark
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
7 Comments
 

Accepted Solution

by:
blossompark earned 0 total points
ID: 39974431
just found out, its a placeholder for a parameter
0
 

Author Comment

by:blossompark
ID: 39974689
How do I close this question?
I have answered it myself and I want to keep it in my history
0
 
LVL 52

Expert Comment

by:Carl Tawn
ID: 39975221
You could post a "Request for attention" asking to close the question accepting your own comment as the solution - with zero points obviously :)
0
Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

 

Author Comment

by:blossompark
ID: 39977791
thanks Carl, will do that :-)
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 39977970
0
 

Author Comment

by:blossompark
ID: 39982468
Thanks Anthony
0
 

Author Closing Comment

by:blossompark
ID: 39993643
found the answer , its a placeholder for a parameter
0

Featured Post

Learn how to optimize MySQL for your business need

With the increasing importance of apps & networks in both business & personal interconnections, perfor. has become one of the key metrics of successful communication. This ebook is a hands-on business-case-driven guide to understanding MySQL query parameter tuning & database perf

Question has a verified solution.

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

My client sends a request to me that they want me to load data, which will be returned by Web Service APIs, and do some transformation before importing to database. In this article, I will provide an approach to load data with Web Service Task and X…
This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…

770 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