Last_date

There is no function like last_date in sql server.

Comments

Post a Comment

Please leave your comments

Popular posts from this blog

Image
Elements for IS Auditing An information system is not just a computer. Today's information systems are complex and have many components that piece together to make a business solution. Assurances about an information system can be obtained only if all the components are evaluated and secured. The proverbial weakest link is the total strength of the chain. The major elements of IS audit can be broadly classified: Physical and environmental review —This includes physical security, power supply, air conditioning, humidity control and other environmental factors. System administration review —This includes security review of the operating systems, database management systems, all system administration procedures and compliance. Application software review —The business application could be payroll, invoicing, a web-based customer order processing system or an enterprise resource planning system that actually runs the business. Review of such application software includes acce...
Read more

How to connect to your database

public class connect_tomcat { String foo = "Not Connected"; int bar = -1; public void init() { try{ Context ctx = (Context) new InitialContext(); if(ctx == null ) throw new Exception("Boom - No Context"); DataSource ds = (DataSource)((InitialContext) ctx).lookup("java:comp/env/jdbc/TestDB"); if (ds != null) { Connection conn = ds.getConnection(); if(conn != null) { foo = "Got Connection "+conn.toString(); Statement stmt = conn.createStatement(); ResultSet rst = stmt.executeQuery( "select nom from user_table"); if(rst.next()) { String nom=rst.getString(2); } conn.close(); } } }catch(Exception e) { e.printStackTrace(); } }
Read more

How to upload excel file to MYsql server

Save your spreadsheet as a CSV (comma separated value) file. >| >| After I save the spreadsheet as a CSV file how do I import the data >| into a MySQL table?[/color] Look under the Load Data instruction. I use the following: LOAD DATA LOCAL INFILE 'e:\\sydnet2\\_info\\curdocs.csv' INTO TABLE pnp_docs_current FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n';
Read more