Office Document APIs for .NET
ITIL Career Advice
PMP Career Advice
Android Intel XDK
Welcome Guest !
What will happen,if we run below query?
Select Round(employee_name,0) from employee_master;
Here,column_name 'employee_name' is a Varchar(50) datatype in employee_master table.
on 11/29/2013 | Category:
Sql Server Interview questions
| Views: 2440 |
Select from following answers:
Command(s) completed successfully.
It will give output.
It will throw an error
None of this.
It will throw an error saying that:-
Msg 8114, Level 16, State 5, Line 2
Error converting data type varchar to float.
Because employee_name is Varchar data type and Round function takes only Decimal,that's why it will throw an error.For working with this,take any Decimal column-name in 1st expression.
Show Correct Answer
Many Interviews |
< Previous :
What will be the output of below query? Select ...
Next > :
How to execute below stored procedure? create p ...
Comments or Responses
Login to post response
More Interview Questions by vishalneeraj-24503
How to execute below stored procedure? create procedure load_employ ...
What will be the output of below query? Select Top 50 * From Employ ...
What will be the output of below query? Select Top 50 Percent * Fro ...
What will be the output of below query? select * from employee_mast ...
What will be the output of below query? select try_parse('111 ...
What is the difference between Finalize and Dispose method in Dot Net?
How to create Table without using Create Statement?
What will happen,when we compile below C# function? private void ch ...
Latest Interview Questions
Which processes implemented sandbox solution?
Which of the following files/programs are not removed by the uninstall ...
What is compatibility level of SQL server 2012?
DBCC SHRINKDATABASE (UserDB, 10); What is the unit of second paramet ...
We can configure individuals to be alerted about sql server agent jobs ...
Which of the following built in tool allows you to changes services ac ...
Which of the following is FALSE regarding the tempdb database?
We can RECOMPILE a stored procedure in SQL server. Which of the follow ...