You work as a SQL Server 2012 database developer at ABC.com. ABC.com has a database
named SalesDB.
You are developing a stored procedure that takes a parameter named @date that uses the
varchar datatype. The @date parameter must be compared to the value in a datetime column
named OrderDate.
Which of the following WHERE clauses would be the most efficient WHERE clause to use?
A.
WHERE OrderDate = CAST(datetime,@date)
B.
WHERE OrderDate = CONVERT(datetime,@date)
C.
WHERE OrderDate =@date
D.
WHERE OrderDate = CAST(@date AS datetime)
E.
WHERE OrderDate = PARSE(@date AS Date)
Explanation:
I think C is the answer
1
0
The answer is incorrect The correct answers are B,C,D but the most efficient will be B
0
0
http://www.mssqltips.com/sqlservertip/3018/performance-comparison-of-the-sql-server-parse-cast-convert-and-tryparse-trycast-tryconvert-functions/
Looks like B is the most efficient. I would have guessed CAST, but looks like I was wrong.
0
0
D
0
0
?
0
0
Although web sites we backlink to below are considerably not associated to ours, we really feel they’re in fact really worth a go through, so have a look.
0
0
usually posts some pretty intriguing stuff like this. If you are new to this site
0
0
Every once in a when we select blogs that we read. Listed below are the most up-to-date sites that we choose
0
0
The facts talked about inside the article are several of the ideal available
0
0
here are some hyperlinks to web-sites that we link to mainly because we think they may be really worth visiting
0
0
although web-sites we backlink to below are considerably not associated to ours, we feel they’re truly worth a go through, so have a look
0
0
we came across a cool site which you might love. Take a appear in the event you want
0
0
please visit the web pages we comply with, which includes this 1, because it represents our picks in the web
0
0
Here are some of the internet sites we recommend for our visitors
0
0
Here is an excellent Blog You may Uncover Intriguing that we encourage you to visit.
0
0
Sites of interest we have a link to
0
0
The information and facts mentioned within the article are a few of the most beneficial out there
0
0
we like to honor many other internet web pages around the internet, even if they arent linked to us, by linking to them. Under are some webpages worth checking out
0
0
Every when in a whilst we pick out blogs that we read. Listed below are the most recent websites that we pick
0
0
Sites of interest we’ve a link to
0
0
one of our guests a short while ago suggested the following website
0
0
here are some links to internet sites that we link to mainly because we feel they’re really worth visiting
0
0
The data mentioned within the write-up are a number of the best offered
0
0
Every as soon as in a though we pick blogs that we read. Listed below would be the latest sites that we pick out
0
0
below youll obtain the link to some websites that we consider it is best to visit
0
0
Here is an excellent Weblog You might Uncover Exciting that we Encourage You
0
0
Wonderful story, reckoned we could combine several unrelated data, nonetheless truly really worth taking a look, whoa did a single find out about Mid East has got more problerms at the same time
0
0
check beneath, are some totally unrelated websites to ours, nevertheless, they are most trustworthy sources that we use
0
0
we like to honor lots of other online websites on the net, even when they arent linked to us, by linking to them. Below are some webpages worth checking out
0
0
one of our visitors not too long ago encouraged the following website
0
0