Often see someone in some BBSs to ask Access to convert to MS SQL, or write a stored procedure, now the younger brother should write some attention or common syntax to everyone (part of the ASP commonly used function ------------------- Access: now () MS SQL: getdate () ------------------- Access: Midms SQL: SubString (Expression, Start, Length) Expression - To search for the target, but cannot use aggregate functions start- specify the start position of the string Length - specify the length of the string --------- -------- ASP: INSTRMS SQL: CHARINDEX (Expression1, Expression2) Parameter Position and ASP INSTR just opposite ----------------- ASP : DIMMS SQL: Declare @variable DataType Example: Declare @varname Varchar (50) Declared Variable @varname is VARCHAR type, length is 50 ----------------- assignment: Declare @Varname varchar (10) set @varname = 'this is content' -------------------- Data type conversion function, CSTR, CSTR, CAST (Expression) AS Dattype) Expression is the data type for the target object DataType for converted to the data type: declare @varname varchar (20) - Declaration a @
