Tag Archives: Tutorials

Querying Data in SQL Server Part 3

Retrieving Record That Match a Pattern While retrieving data you might need to view selected rows that match a specific pattern. For example: You want to view the cities of the students whose name begins with ‘P’. You can do this by using LIKE keyword. This keyword is used to search a string by using [...]

Querying Data in SQL Server Part 2

Calculating column values If you want to do calculations on a column like add, subtract, multiply, modulus or division. You can use the arithmetic operators like (+, -, /, *, %). Now in our table TABLE1 we have one column STDID containing integer values & I want to add all the values by 20. The [...]