Refer to link http://technet.microsoft.com/en-us/library/gg471594.aspx

The dangerous side of MERGE talks about how MERGE statement with wrong usage can wipe out data: http://www.sqlservercentral.com/articles/MERGE/97867/#.Um5Zwk6LY0Q.twitter

This post talks about this: http://stackoverflow.com/questions/14366913/strange-issue-in-ssis-with-with-results-set-returning-wrong-number-of-columns.

HTH,

Venkataraman

[font="Verdana"]I have used ERWin data modeler to reverse engineer SQL Server databases earlier. from googling, I understand that they support SQL Server 2012 also. [/font]

You can disable trigger using "Disable" FROM Context menu of a trigger in SSMS object explorer. But, you cannot script "DISABLE TRIGGER" from SSMS. You will be able to Script...

In SQL Server 2012, there is a new package deployment model called, Project deployment model, where we can deploy into SQL Server. In SSDT, we can deploy the project to...

Same Userdefined Function, tried with PATINDEX.

CREATE FUNCTION [CapitalCase]

(

@Input varchar(255)

)

RETURNS varchar(255)

AS ...

Can you please tell clearly, what do u mean by Schema is different? is just the schema name is different or the schema objects definition is different ?

Hi ColdCoffee,

If you want to assign set number, based on the list of values, then every time the list of values can change, as we are not having ORDER BY...

You can try the below query to get list of tables with partitions. Here, every table will have atleast one partition. So, partition number is 1-based partition number within the...

Thanks Ashish for the pointer. We can also use SQL Server Client Network utility for doing the same. Both approaches are detailed in the article http://www.mssqltips.com/tip.asp?tip=1620

Hi Grasshopper,

Please refer to this link http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/core/r0002019.htm

You can either query system catalog Syscat.Columns or use DESCRIBE command as given in the link.

Regards,

Venkat

Try the below query. It is using a table variable to populate the minute, Hour table and using the same for populating the result set.

DECLARE @MinuteTable Table(minuteofDay SMALLINT, hourofDay...

Schema is container of database objects aka Securables like Entity,View, Stored procedure etc. It is similar to namespace in programming languages. It can also be correlated with a bank locker,...