Monthly Archives: August 2012

A Contained Database is a database which contains all the necessary settings and metadata, making database easily portable to another server. This database will contain all the necessary details and will not have to depend on any server where it is installed for anything. You can take this database and move it to another server … Continue reading →

DBA or Developers both are habitual of using multiple SQL server remotely from one server. But the normal issue of running commands on wrong servers due to less of attention on server name displaying in SSMS query windows pane. We can give different color codes to different server to make them more identifiable in single … Continue reading →

Microsoft SQL Server 2012 introduces 14 new built-in functions. 2 Out 14 explained below. String functions · CONCAT : CONCAT takes a variable number of string arguments and concatenates them into a single string. It requires a minimum of two input values; otherwise, an error is raised. All arguments are implicitly converted to string types … Continue reading →

Microsoft SQL Server 2012 introduces 14 new built-in functions. 2 Out 14 explained below. Logical functions · CHOOSE : CHOOSE acts like an index into an array, where the array is composed of the arguments that follow the index argument. The index argument determines which of the following values will be returned. CHOOSE ( index, … Continue reading →

Microsoft SQL Server 2012 introduces 14 new built-in functions. 7 Out 14 explained below. Date and time functions · DATEFROMPARTS : DATEFROMPARTS returns a date value with the date portion set to the specified year, month and day, and the time portion set to the default. If the arguments are not valid, then an error … Continue reading →