Database

1. What are ODBC Escape Sequences?
2. Why use ODBC Escape sequences?
3. Where can I use ODBC Escape Sequences?
4. Date, Time and Timestamp Escape Sequences.
5. Procedure Call Escape Sequence.
6. Scalar Function Escape Sequence.
7. Which functions supports in my database server?
  • String functions.
  • Numeric functions.
  • Date and time functions.
  • System functions.
  • Explicit Data Type Conversion Function.
8. Functions Description and the samples of functions calls.
  • String functions.
  • Numeric Functions.
  • Date and time functions.
  • System functions.
  • Explicit Data Type Conversion Function.

ALTER     PROC [dbo].[uprUpfronts_GetByIntroducerDate]<br />
@IntroducerID	int,<br />
@BalanceID	int,<br />
@UserID		varchar(10)<br />
AS<br />
BEGIN<br />
<br />
	--SET LoanID = U.LoanID as varchar (10)<br />
	SELECT	CASE<br />
			WHEN EXISTS (SELECT LoanID FROM FastLoan_Applications.dbo.tblLoanPurpose WHERE LoanID = U.LoanID) <br />
			THEN ' * ' + CAST(U.LoanID AS varchar(10)) <br />
			ELSE U.LoanID <br />
			END [Loan Number],<br />
			A.ShortName, <br />
			CASE<br />
				WHEN U.LoanIncreaseID IS NULL THEN LS.StageDate<br />
				ELSE LIS.StageDate<br />
			END [Settlement], U.LoanAmount, U.UpfrontRate,<br />
			U.UpfrontAmount, U.ApplicationFee, U.UpfrontGST, U.UpfrontTotal,<br />
			ISNULL(US.Name, L.IntroducerRef) [SalesPerson], <br />
			U.CommissionRunID<br />
	FROM		FastLoan_Commissions.dbo.tblUpfront U<br />
	LEFT JOIN	FastLoan_Applications.dbo.tblLoan L ON L.LoanID = U.LoanID<br />
	LEFT JOIN	FastLoan_Applications.dbo.tblApplication A ON A.ApplicationID = L.ApplicationID<br />
	LEFT JOIN	FastLoan_Applications.dbo.tblLoanStage LS ON LS.LoanID = L.LoanID<br />
		AND	LS.LoanStageTypeID = 6<br />
	LEFT JOIN	FastLoan_Applications.dbo.tblLoanIncreaseStage LIS ON LIS.LoanIncreaseID = U.LoanIncreaseID<br />
		AND	LIS.LoanStageTypeID = 6<br />
	LEFT JOIN	FastLoan_Applications.dbo.zstblUser US ON US.UserID = A.IntroducerSalesPersonID<br />
	WHERE		U.BalanceID = @BalanceID<br />
		AND	U.IntroducerID = @IntroducerID<br />
<br />
	ORDER BY	Settlement