Welcome :Guest

Congratulations!!!

Top 5 Contributors of the Month
Sandeep Singh
stevemarkayden
Mayuri
kumarfurima
Preethi

 Home >> Interview Question >> Sql Server >> Post New Question Subscribe to Interview Questions
You can also find related Interview Question to Which function performs the opposite function of CEILING function in SQL Server?  below:

### What is the use of COALESCE function in SQL Server ?

Returns the first not null expression among its arguments.
COALESCE(X,Y,Z)

If X is Null then It'll check for Y,
If Y is Null It'll Check for Z.

Let X is NULL, Y='5' and Z='9'
Here Output is : Y (More...)

### Which function is used to know the database property in SQL Server.

DATABASEPROPERTYEX(dtabase,property)

It will return the specified property of the specified database.
Example:-

SELECT DATABASEPROPERTYEX(Student,Version)

-->365

You can use this function to know other properties of your database. (More...)

### What is the use of CEILING function?

The CEILING function does the opposite of FLOOR function. It returns the smallest integer greater than the value you specify.

Syntax:-
CEILING(expression)[/CODE

Example:-
SELECT CEILING(400.45) FROM dual

It will output 401.

NOTE:- It rounds up the non-integer number to the next highest value. If you enter negative value, it will return the lower absolute value.

Example:-
SELECT CEILING(-400.45) FROM dual

It will output 400. (More...)

### Difference between Len and DataLength function in Sql Server?

LEN() function will not count the trailing spaces.

DATALENGTH() function will count the trailing function

example:

DECLARE @MyString VARCHAR(50)
SET @MyString = 'alwyn '
SELECT LEN(@MyString) AS LenFunction
SELECT DATALENGTH(@MyString) AS DataLength

LenFunction:
5

DataLength:
8 (More...)

### Write a query to get the second maximum salary using Sql Server 2005 function?

SELECT Salary
FROM (
SELECT Salary, RANK() OVER (ORDER BY Salary DESC) AS MaxSalary
FROM dbo.Employee
) a
WHERE MaxSalary = 2
(More...)

### What is the Use of ISNull function in SQL Server?

Find the not null value in the list of value. (More...)

### What does the CEILING() function do?

Returns the smallest integer greater than or equal to the value passed in.
CEILING() returns the smallest integer that is great than or equal to the value passed in. (More...)

### What is Method Overriding? How to override a function in C#?

Use the override modifier to modify a method, a property, an indexer, or an event. An override method provides a new implementation of a member inherited from a base class. The method overridden by an override declaration is known as the overridden base method. The overridden base method must have the same signature as the override method.
You cannot override a non-virtual or static method. The overridden base method must be virtual, abstract, or override. (More...)

### Define precondition and post-condition to a member function.

Precondition:
A precondition is a condition that must be true on entry to a member function. A class is used correctly if preconditions are never false. An operation is not responsible for doing anything sensible if its precondition fails to hold.
For example, the interface invariants of stack class say nothing about pushing yet another element on a stack that is already full. We say that isful() is a precondition of the push operation.

Post-condition:
A post-condition is a condition that must be true on exit from a member function if the precondition was valid on entry to that function. A class is implemented correctly if post-conditions are never false.
For example, after pushing an element on the stack, we know that isempty() must necessarily hold. This is a post-condition of the push operation. (More...)

### Difference between a sub and a function.

A Sub Procedure is a method will not return a value
-A sub procedure will be defined with a "Sub" keyword
Sub ShowName(ByVal myName As String)
Console.WriteLine("My name is: " & myName)
End Sub
-A function is a method that will return value(s).
-A function will be defined with a "Function" keyword
Function FindSum(ByVal num1 As Integer, ByVal num2 As Integer) As Integer
Dim sum As Integer = num1 + num2
Return sum
End Function (More...)

### Explain Virtual Function in C#.

Virtual functions implement the concept of polymorphism are the same as in C#, except that you use the override keyword with the virtual function implementaion in the child class.

The parent class uses the same virtual keyword. Every class that overrides the virtual method will use the override keyword.

class Shape{
public virtual void Draw()
{ Console.WriteLine("Shape.Draw") ; }
}
class Rectangle : Shape{
public override void Draw()
{ Console.WriteLine("Rectangle.Draw"); }
} (More...)

### Can I call a Win32 API function from a C# program?

Yes, you can.The .NET Framework provides a set of services called Platform Invoke, also known as PInvoke. Refer to the .NET Framework documentation for examples of using PInvoke services. (More...)

Quick Links For Interview Questions Categories:
 ASP.Net Windows Application .NET Framework C# VB.Net ADO.Net Sql Server SharePoint Silverlight OOPs JQuery JavaScript/VBScript Biztalk Patten/Practices .IIS WCF WPF WWF Networking Aptitude Others All

### Find questions, FAQ's and their answers related to .NET, C#, Vb.Net, Sql Server and many more.

Now you can find lots of .NET, C#, Vb.Net, SQL Server,Windows, ASP.Net related Questions and their Answers here at www.dotnetspark.com. Our aim is to help you pass your certification Exams (MCP, MCSD, MCAD etc.,) with flying scores and get good name in your company.

So, Start looking our Interview Question section daily and improve your .NET Skills. You can also help others by posting Interview Questions and their Answers in this section.