In order to send mail using Database Mail in SQL Server, there are 3 basic steps that need to be carried out. 1) Create Profile and Account 2) Configure Email 3) Send Email.
The following is the process for sending emails from database.
- Make sure that the SQL Server Mail account is configured correctly and enable Database Mail.
- Write a script to send an e-mail. The following is the script.
USE [YourDB]
EXEC msdb.dbo.sp_send_dbmail
@recipients...
Friday, July 29, 2011
How to get @@Error and @ROWCOUNT at the same time?
if @@Rewcount is checked after error checking statement then it will have '0' as the value of @@Recordcount as it would have been reset. and if @@Recordcount is checked before the error-checking statement then @@Error would get reset. To get @@error and @@rowcount at the same time do both in same statement and store them in local variable.
select @recCount = @@Rowcount, @Err = @@error
Compiled By: Rajesh Rol...
Wednesday, July 27, 2011
What is Table Scan?
Table Scan comes to picture when you search for data in a table and you table does't have any index created on it or your query does't take advantage of any existing index of table.
In normal condition Table Scan is not good but in some circumstances its good to use.
A table scan is the easiest and simplest operation that can be performed against a table. It sequentially processes all of the rows in the table to determine if...
Monday, July 25, 2011
ASP.NET Application and Page Life Cycle
Today we are going to learn complete application and page life cycle of asp.net
Beginning from request sent from browser to process and then response sent back to browser.
In broad way there are only 2 step process
- creation of an environment which can process the request
(creation of application object, request, response and context...
Monday, July 18, 2011
Will finally blocks be executed if returning from try or catch blocks
Yes, the finally block is executed however the flow leaves the try block - whether by reaching the end, returning, or throwing an exception.
The return value is determined before the finally block is executed though, so if you did this:
int Test()
{
int result = 4;
try
{
return result;
}
finally
{
// Attempt to change value result
result = 1;
}
}
the value 4 will still be...
Where is session stored if cookie is disabled on client’s machine
The session cookie is a special non-persistant cookie. It's only stored in memory, so in most cases even when cookies are disabled it still works fine.
It's also possible to enable something called cookieless sesssions where the sessionID is embedded in the URL, like this:
http://yourserver/folder/ (encrypted session ID here) /default.aspx
Here's a link to an MSDN article with more details:
http://msdn.microsoft.com/en-u...
Get all column names of datatable into string array
using Linq you can easily get list/array of all column names of a datatable:
string[] columnNames = dt.Columns.Cast< datacolumn > ().Select(x => x.ColumnName).ToArray();
//or in LINQ
string[] columnNames = (from dc in dt.Columns.Cast< datacolumn >() select dc.ColumnName).ToArray();
Compiled By: Rajesh Rol...
LINQ over Datatable
using below code we can use LINQ to query Datatables:
var res = from p in dt.AsEnumerable()
where p.Field< string >("YourFieldName") == "Value" || p.Field < string > ("YourFieldName") == "Value"
select p;
Compiled By: Rajesh Rol...
The query results cannot be enumerated more than once
While doing LINQ you will face this error to resolve it add a ToList() at end of your LINQ query. This way, the results are retrieved from the server, after which you can do with them whatever you want (since they are now loaded in-memory).
Compiled By: Rajesh Rol...
Fastest way to extract number from string
To extract numeric values from string you can use below function:
static string ExtractNumbers(string expr)
{
return string.Join(null, System.Text.RegularExpressions.Regex.Split(expr, "[^\\d]"));
}
Compiled By: Rajesh Rol...
Subscribe to:
Posts (Atom)