Database

"Data Source=dbserver;Initial Catalog=mydb;Persist Security Info=True;User ID=user;Password=password;Connection Timeout=60;Packet Size=16384;Pooling=false"

1. EntitiesDataContext db = MyProject.Misc.HttpDataContext<entitiesdatacontext>.Current;
2. Client client = Application.GetClient();
3. db.GetPartsByClientType(...)</entitiesdatacontext>

public static T Current {
			get {
				string key = typeof(T).FullName;
				T datacontext = (T)System.Web.HttpContext.Current.Items[key];
				if (datacontext == null)
					System.Web.HttpContext.Current.Items.Add(key, datacontext = new T());
				return datacontext;
			}
		}

EntitiesDataContext db = MyProject.Misc.HttpDataContext<entitiesdatacontext>.Current;</entitiesdatacontext>

CREATE TABLE #T (ID INT IDENTITY(1,1), FirstName nvarchar(20))
INSERT INTO #T (FirstName) SELECT 'John'
INSERT INTO #T (FirstName) SELECT 'Kyle'
INSERT INTO #T (FirstName) SELECT 'Stacey'

INSERT INTO 
	OPENROWSET (
		  'Microsoft.Jet.OLEDB.4.0'
		, 'Excel 8.0;Database=c:\testXL.xls;HDR=YES;'
		, 'SELECT ID, FirstName FROM [Sheet1$]'
	)
SELECT 	ID, FirstName  
FROM #T

DROP TABLE #T

EXEC sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
EXEC sp_configure 'Ad Hoc Distributed Queries', 1;
GO
RECONFIGURE;
GO

EXECUTE msdb.dbo.sysmail_configure_sp 'LoggingLevel' , '2';

sysmail_help_queue_sp @queue_type = 'Mail';

<br />
SELECT <br />
	dbo.tbl_Login.MID,<br />
	convert(varchar(20),TSDate,101) as [Date],<br />
	TSSubject as [Subject],<br />
	TSDescription as [Description],<br />
	TSHour as [Hour],<br />
	TSMin as [Minute],<br />
	convert(varchar(20),CreationDate,101) as [Creation Date],<br />
	CreationBy as [Name Of Employee] <br />
FROM @tbl_TempManagers M<br />
INNER JOIN tbl_login E ON E.Mid = M.ManagerID<br />
INNER JOIN tbl_TSEnterData D ON D.CreationBy = E.UserName<br />
WHERE D.TSDate BETWEEN DATEADD(wk, -1, @d) <br />
	AND DATEADD(dd, -1, @d) <br />
order by D.CreationBy asc,D.TSDate Desc<br />