="INSERT INTO SFA_SYS_CODE(CD_CTRY_CODE,CD_TYPE,CD_CODE,CD_DESC,CD_BACKEND_IND,DATETIMESTAMP) VALUES('MYS','COUNTRY','"&B2&"','"&A2&"','N',current timestamp);"
=CONCATENATE(CONCATENATE("DELETE FROM SFA_SYS_CODE WHERE CD_CTRY_CODE = 'MYS' AND CD_TYPE = 'NEW_COUNTRY' AND CD_CODE = '", B1, "';
"), CONCATENATE("INSERT INTO SFA_SYS_CODE(CD_CTRY_CODE, CD_TYPE, CD_CODE, CD_DESC, CD_BACKEND_IND, DATETIMESTAMP) VALUES('MYS', 'NEW_COUNTRY', '", CONCATENATE(B1&"','"&A1), "', 'N', current timestamp);"))
=RIGHT(C2,4)
=E2&" "&F2
=IF(LEN(B2)=1,"occupation.000"&B2,IF(LEN(B2)=2,"occupation.00"&B2,IF(LEN(B2)=3,"occupation.0"&B2,IF(LEN(B2)=4,"occupation."&B2))))
相关推荐
Generate SQL scripts from database objects. Query designer -Design SELECT, UPDATE, DELET and INSERT queries. Use data preview ofr analysing of query result. GPS Visualiser -Visualise points, ...
With Cocoon you can serialize any XML datasource (which might be a ESQL page outputting in SQL for instance) by simply applying the stylesheet and designating the serializer. If you're merely ...
for those who love fast and effective solutions you can use the jqPlot library to generate charts with amazing effects and animations using only a few lines of code; if you want more power and need ...
Generate SQL statement and ADO Code Connection without the use of an ADO Data Control. <END><br>15 , client.zip This application is about programming with Client Side Cursors. <END><br>16 , Access...
Added the possibility to generate a single INSERT statement. The MultipleInsert property. 3. TQExport4XML. Now the BLOB filed data is uploaded using base64 encoding. (For Delphi 2005/CBuilder 2006...
Generate a grid with a million rows to a chart with unlimited points. Over 65 .NET Windows Forms controls, including the ones you can't get anywhere else. ComponentOne Studio® for WinForms ...
Generate a grid with a million rows to a chart with unlimited points. Over 65 .NET Windows Forms controls, including the ones you can't get anywhere else. ComponentOne Studio® for WinForms ...
Generate a grid with a million rows to a chart with unlimited points. Over 65 .NET Windows Forms controls, including the ones you can't get anywhere else. ComponentOne Studio® for WinForms ...
Generate a grid with a million rows to a chart with unlimited points. Over 65 .NET Windows Forms controls, including the ones you can't get anywhere else. ComponentOne Studio® for WinForms ...
Generate a grid with a million rows to a chart with unlimited points. Over 65 .NET Windows Forms controls, including the ones you can't get anywhere else. ComponentOne Studio® for WinForms ...
excel_odbc_demo.zip A discussion and demonstration of reading Excel files using ODBC (20KB)<END><br>30,SPCW.zip A tool to generate class files to implement stored procedures(354KB)<END><br>31,...
Although most of us will use a SQL Server to store and retrieve data sets. There are several situation where an embedded database make sense. When you don't have a SQL Server available When you ...
<END><br>85,Shape.zip I have used SHAPE command instead of PARAMETERS to generate dynamic report.Open with VB6. <END><br>86,AlarmPrj.zip An Alarm Class project. <END><br>87,hyperlink.zip A ...