Buy Questpond's video subscriptions on
huge discount
.
Online: 1898
Home
Articles
Interviews
Forums
For Beginners
Popular Questions
ITIL Career Advice
PMP Career Advice
Career Advices
Codes
Videos
ASP.NET
ASP.NET MVC
Android Intel XDK
Sql Server
AngularJS
Bootstrap
Backbone.JS
MongoDB
LESS (CSS)
jQuery
WPF
WWF
SSIS
LightSwitch
Tutorials
News
ASP.NET MVC
|
Be Interview Ready
|
Top Performers
|
DNF MVP
|
Top Posts
|
Winners
|
Subscribe
|
Catalogs
Welcome Guest !
Register
Login
Home
>
Interviews
>
Sql Server
>
Loading ...
what is the output of this SQL ?
SELECT LEN(CAST(LEFT('030-020', 3) AS INT))
Posted by
Bandi
on 6/26/2015 | Category:
Sql Server Interview questions
| Views: 3624 |
Points: 40
Post
|
Interview FAQs
|
Exclusive Questions
|
Interview Home
Select from following answers:
2
3
Error
10
All Above
LEFT('030-020', 3) returns
030
Coverting
030
to integer returns
30
The lenght of integer
30
is
2
Show Correct Answer
Asked In:
Many Interviews |
Alert Moderator
Bookmark It
< Previous :
You need to ensure that if a row in a parent table ...
Next > :
what is the output of below query? DECLARE @Tod ...
Comments or Responses
Login to post response
More Interview Questions by Bandi
what is the output of below query? DECLARE @Today VARCHAR(10) SE ...
Which of the following is FALSE against the setupadmin fixed server ro ...
Which of the following is FALSE statement against the securityadmin fi ...
SQL Server 2000 - Which part of the code line generates error in the b ...
Which of the following isolation level allows nonrepeatable reads but ...
Which transaction isolation level is the most restrictive causing the ...
SQL Server 2012 - Which of the following statement restars the numeric ...
SQL Server 2012 - what is the data type of output of below SQL ? SE ...
Latest Interview Questions
What are HttpHandlers and HttpModules in ASP.NET?
Which one of the following is used to obtain performance information a ...
Which of the following is the fastest way to concat strings in ASP.NET ...
____________ is the Microsoft IIS server running , handling ASP.NET re ...
Which of the following object encapsulates the state of client and the ...
Which one of the following is the type of assembly that contains local ...
When does garbage collector runs ?
__________ is the first method that is fired during the page load ?
More ...