Skip to content

Instantly share code, notes, and snippets.

@vanduc1102

vanduc1102/Common.sql

Created September 29, 2015 02:09
Show Gist options
  • Save vanduc1102/353bcf4613f248207147 to your computer and use it in GitHub Desktop.
Save vanduc1102/353bcf4613f248207147 to your computer and use it in GitHub Desktop.
Download ZIP
This is common commands SQL
Raw
Common.sql
-- select top 5 rows
SELECT * FROM [framework_eventlog] WHERE [id] > (SELECT MAX([id]) - 5 FROM [framework_eventlog]);
@vanduc1102
Copy link
Author 

SELECT id,objectType,eventType,eventSubType,server,eventData,initiator,userName,system,applicationName,eventDate 
FROM [framework_eventlog] WHERE [id] > (SELECT MAX([id]) - 10 FROM [framework_eventlog]);

@phuchieuct93abc
Copy link 

SELECT top 10 id,objectType,eventType,eventSubType,server,eventData,initiator,userName,system,applicationName,eventDate 
FROM [framework_eventlog] order by id desc

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment