Do NOT rely on dumps, study, practice and give exam by legitimate means.

SQL Server 2012 Certification path: http://sqlwithmanoj.com/2013/11/06/sql-server-2012-certification-path/[/url]

Exam 70-461: http://sqlwithmanoj.com/2012/11/16/passed-70-461-exam-querying-microsoft-sql-server-2012/[/url]

Exam 70-463: http://sqlwithmanoj.com/2013/12/05/preparing-for-70-463-exam-implementing-a-data-warehouse-with-microsoft-sql-server-2012/[/url]

You've to buy the book and it's worth purchasing, and you can get it from Amazon, link.

But you can also refer to the MSDN Books-on-Line, check here you will get...

Yes, the book is worth purchasing, but you can also refer to the MSDN BoL. Check here you will get the links to the required study material to go thru.

Link:...

Sorry for replying on an old thread, and you might have taken and passed this exam.

But for newbies check this link where you will get the required study material links...

Replying on a very old thread, and you might have taken and passed this exam.

But for newbies, yes there is no need to go to any bootcamps when you can...

Microsoft SQL Server supports 2 types of commenting:

1. Single line: by using double hyphen "--", like:

-- this is a single line comment

2. Multiline: /* */, like:

/*

This

is

a

multiline

comment

*/

Please post the link to Screenshot again.

Why are you using sp_execute to execute a SP?

You can directly use:

exec DB2.dbo.TestProc @T

As you are using Dynamic SQL the table type variable @T is out of scope w.r.t...

The cumulative update on SQL 2008 should also be available in 2008 R2.

Can you please provide more information on the error you are getting?

Do you have any Linked Servers and...

To suppress the messages thrown by xp_cmdshell extended Stored Procedure use the no_output optional parameter:

exec xp_cmdshell 'DIR *.exe', no_output

No, you cannot use them in combination, they must be used separately:

USE [AdventureWorks2012]

GO

select TOP 50 [BusinessEntityID], [Title], [FirstName], [MiddleName], [LastName], [Suffix]

from Person.Person

FOR XML RAW

select TOP 50 [BusinessEntityID], [Title], [FirstName],...

@Vipin, there are spaces between the dashes, thus I've removed them.

Simple Query:

CREATE TABLE #TBL_DASHES

(

DH_ID INT IDENTITY(1,1) NOT NULL

,DH_STRING VARCHAR(200)...

Check the following article on PIVOT operator which mentions an example that matches with your scenario.

Link: http://sqlwithmanoj.com/2009/04/12/ms-sql-server-2005-new-feature-pivot-and-unpivot/[/url]

Here you will also see how to use UNPIVOT operator.

To start with TRANSACTIONs you need to understand the basic ACID rules of a Database.

Then you can check with SQL Server Transaction in MS BOL: https://msdn.microsoft.com/en-IN/library/ms174377.aspx?f=255&MSPPError=-2147217396

Other resources:

- Intro: http://www.sqlteam.com/article/introduction-to-transactions

-...

By default the SET XACT_ABORT is OFF. There ar very few cases where the T-SQL statement that raised exception are rolled back and the transaction continues processing. Depending upon the...