Sql Server Interview Questions and Answers (1758) - Page 17

Latest and authentic Interview questions. You can also post an interview question and win monthly prizes as well as gain community credit points.

1758 records found.

Post |

Interview Experiences |

Interview FAQs |

Online Interviews |

Exclusive Questions

Get 650+ Questpond's Interview videos on discount

How To know your SQL Server Version in SQL command prompt ?

SELECT @@VERSION

What is the use of xml datatype in SQL Server?

As the name indicates xnl datatype is used to store XML documents in SQL Server.

For more information please go to the following URL,
http://msdn.microsoft.com/en-us/library/ms187339.aspx

What is the maximum size of data we can store in the image type of SQL?

We can store binary data from 0 to 2^31-1 or 2,147,483,647 bytes in an image field of SQL Server. The image datatype is used to store images and files in a database.

What is the difference between .rdl and .rdlc report.

.rdl report is created using SQL Server Reporting service, But the .rdlc report is created with the help visual studio's inbuilt reporting services. in rdlc 'c' stands for client side.

Can we create DTS Package in DTS package in SQL Server 2005 or higher version?

NOTE: This is objective type question, Please click question title for correct answer.

What is SSIS

SSIS is know as SQL Server Integration service. SSIS Package are replacement of DTS Package in SQL Server 2005 or higher version.

Can we write Scripting Language like VB Script and JavaScript in SSIS Package?

Yes, We can Write VB Script and JavaScript in SSIS Packages using ActiveX Task Control.

Name of the containers in SSIS?

(1) Task Host Containers
(2) Sequence Containers
(3) ForEach Loop Containers
(4) For Loop Containers

Can we use Oracle Database as source or destination Database in SSIS?

Yes, We can Use Oracle Database and can create OLE-DB Connection to connect.

Adding months to a Date in SQL ??

Example below illustrates :

Select DATEADD(mm,1,getdate())

Adding minutes to a date ??

Example below illustrates :

Select DATEADD(minute,1,getdate())

Adding year to a date ??

Example below illustrates :

Select DATEADD(year,1,getdate())

How to get the month value/month part from the given Date?

There are three methods to get the Month part from given date:
DECLARE @GivenDate datetime
SET @GivenDate='2010-02-22 23:06:38.300'
(1) MONTH(GETDATE()) OutPut: 2
(2) SUBSTRING(CONVERT(varchar(30),GETDATE(),107),1,3) Output: Feb
(3) DatePart(M,GETDATE()) output: 2