Thursday, October 25, 2012

OnClientClickevent and AJAX is not working for telerik RadControls

One may need to provide a confirmation dialog or check some validation to the users and initiate an AJAX request if confirmation accepted or validation perform successful. Confirmation using standard post backs often looks like this: 

<asp:Button ID="btnSaveComplaint" runat="server" Text="Save" OnClick="btnSaveComplaint_Click" OnClientClick="return ValidateMacroText();" /> 
 Note: ValidateMacroText() is javascript function which returns true if validation perform successfully.

Friday, October 5, 2012

SQl Server Tricks-Part2

Get list of all procedures created on a particular date in a database

To get the list of all the procedures created on a particular date in a data base, you can use this query.

Use YourDBName
Go
select name from sys.objects
where type = 'P'
and create_date=@yourdate
Go

Thursday, October 4, 2012

SQl Server Tricks-Part1

Getting the List of all databases on a server

To get list of all database on a server, you can use this query.
USE master
GO

SELECT
*
FROM sys.Databases
GO
OR you can use the sp_helpdb procedure for this.

^ Scroll to Top