Articles - Database (SQL Server)

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: 80 | 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: 69 | Categories: Database (SQL Server), Community, C#
0

Like

While restoring SQL backup file from one machine to another, I got this error message:

System.Data.SqlClient.SqlError: The operating system returned the error '5(Access is denied.)' while attempting 'RestoreContainer::ValidateTargetForCreation' on 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.x\MSSQL\DATA\x.ldf'. (Microsoft.SqlServer.Smo) ...Read more
Posted by: Muhammad Idrees
On 25 Aug 2015 | Views: 49 | Categories: Database (SQL Server)
0

Like

This is a simple tip post. In this post I will show you a user defined function in SQL Server which parse the HTML and retrieve the Text only from it. ...Read more
Posted by: Manish Dubey
On 06 Aug 2013 | Views: 1192 | Categories: Database (SQL Server)
0

Like

In SQL Server , Installation by default are case insensitive .This means that SQL Server ignores the case of the characters and treats the string 'Dot Net World' equal to the string 'dot net world'. SO how to perform case sensitive search in SQL? ...Read more
Posted by: Manish Dubey
On 03 May 2013 | Views: 674 | Categories: Tips & Tricks, Database (SQL Server)
0

Like

In this post, I have given a simple tip to check that primary is exists or not in table. ...Read more
Posted by: Manish Dubey
On 15 Apr 2013 | Views: 623 | Categories: Database (SQL Server)
Page 1 of 10
Other lins

.Net Techies
Other lins