30.4.11
How to use append correctly
http://www.learningjquery.com/2009/03/43439-reasons-to-use-append-correctly
28.4.11
23.4.11
Sql Queries Information
1.)if you want to check, last 7 days sp created in database use this..
SELECT * FROM sys.objects WHERE type = 'P' AND DATEDIFF(D,create_date, GETDATE()) < 7
2.)Find Text In Store Procedure:
SELECT ROUTINE_NAME, ROUTINE_DEFINITION
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_DEFINITION LIKE '%Users%'
AND ROUTINE_TYPE='PROCEDURE'
3.) Check tables created in database last 7 days:
SELECT * FROM sys.tables WHERE type = 'U' AND DATEDIFF(D,create_date, GETDATE()) < 14
4.) List of All tables in Database:
SELECT * from sys.tables where type_desc = 'USER_TABLE'
5.) List of All users Sps in Database.
SELECT * FROM sys.objects WHERE type = 'P'
SELECT * FROM sys.objects WHERE type = 'P' AND DATEDIFF(D,create_date, GETDATE()) < 7
2.)Find Text In Store Procedure:
SELECT ROUTINE_NAME, ROUTINE_DEFINITION
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_DEFINITION LIKE '%Users%'
AND ROUTINE_TYPE='PROCEDURE'
3.) Check tables created in database last 7 days:
SELECT * FROM sys.tables WHERE type = 'U' AND DATEDIFF(D,create_date, GETDATE()) < 14
4.) List of All tables in Database:
SELECT * from sys.tables where type_desc = 'USER_TABLE'
5.) List of All users Sps in Database.
SELECT * FROM sys.objects WHERE type = 'P'
20.4.11
Load Content On scrolling
http://www.go4coding.com/post/2011/04/11/Auto-loading-content-on-page-scroll-in-aspnet-using-jquery.aspx
14.4.11
Datalist with custom paging
http://www.dotnetfunda.com/articles/article456-custom-seo-friendly-paging-with-aspnet-repeater-or-datalist-control-.aspx
Subscribe to:
Posts (Atom)