How to use Report Builder 3.0

28. June 2016 Back-end, SQL 24
Today, I got some tips that how to use Report Builder 3.0 to generate reports. Report Builder 3.0 is a report-authoring tool that’s part of the Reporting Services suite of tools available in SQL Server 2008 R2. However, Report Builder is a free, stand-alone application that can be used by SQL Server developers and business ...

Stored Procedures & Exercise (Sources from Northwind Database)

21. June 2016 SQL 2
In a database management system (DBMS), a stored procedure is a set of Structured Query Language (SQL) statements with an assigned name that’s storedin the database in compiled form so that it can be shared by a number of programs. As below, it shows some exercise about Stored Procedures (Sources from Northwind Database): First of ...

string.Format() function and examples

15. June 2016 Back-end, C# 1
In C#, ‘string’ is a common type, and ‘.Format’ is one of its functions, the following shows that different words inside ‘.Format()’ present different purpose, and the result will be shown in different types when it is used in upper and lower case.     C     c Currency     D     d Decimal ...