Articles - Database (SQL Server)

0

Like

In this post, we will understand how to return the inserted rows. For example, we are inserting records in a table from Stored Procedure, then we want to return the resulting inserted values to the calling application. ...Read more
0

Like

Aggregate functions perform a calculation on a set of values and return a single value, frequently used with the GROUP BY clause of the SELECT statement. ...Read more
0

Like

A window function is one that can be applied to a set of rows, The word ‘window’ is used to refer to the set of rows that the function works on. It provides a way to work with data grouped into logical windows.

The OVER clause used to define a window or set of rows within a query result set. Then we use a window function to computes a value for each row in the subset. OVER clause can be used to compute aggregated values such as average, sum, min, max, or a top N per group results. ...Read more
0

Like

In this post we will see three ways to iterate through table rows in a loop using T-SQL. I am using Microsoft SQL SERVER 2008 R2. ...Read more
0

Like

Most programming languages executes set of statements from Top to Bottom but SQL Server executes set of statements in a logical order which is uniquely decides by the SQL Server in a predefined order known as Logical Query processing phase. ...Read more
Posted by: Manish Dubey
On 28 Oct 2015 | Views: 187 | Categories: Database (SQL Server)
0

Like

xp_regread reads the exact literal registry path you specify, while xp_instance_regread reads(or can transform) the path you specify so that it matches the instance of SQL Server that you're currently using. ...Read more
0

Like

I need to find out the physical path where my database files are being stored. The following query will give you the physical path to store database's mdf and ldf files for your current SQL Server's instance. ...Read more
0

Like

MS SQL Server have the feature to send emails. There we have a Stored Prcocedure named msdb.dbo.sp_send_dbmail used to send emails. ...Read more
0

Like

http://idreesdotnet.blogspot.com/2015/08/connect-sql-server-from-powershell.html ...Read more
Posted by: Muhammad Idrees
On 25 Aug 2015 | Views: 195 | Categories: Database (SQL Server), Community, C#
Page 1 of 10
Other lins

.Net Techies
Other lins