jQuery slice() method is very useful and give more flexibility than substring method of jQuery. It takes 2 parameter and both are optional. If none is specified then it sliced the whole. Important thing with this method is that it doesn't consider the last sliced item in its result.
...
[More]
27. June 2012
Anil Kumar
C#
Understand Sealed Class in C# programming
[More]
jQuery 1.8 first BETA version is released and can be experienced by downloading it from jQuery CDN.
[More]
We can find the checked value of a radio button using :checked attribute and radio button's name as a selector.
The System.Web namespace contains the important base level ingredients for ASP.NET applications. System.Web namespace is an important base for Web Form user interface and web services.
Use of Built-in Objects like Request and Response are very common and widely used. We directly write them without creating objects as they are built-in objects.This namespace has following built-in Objects : (1) Request (2) Response (3) Server (4) Application
[More]
How to get the list of all tables that are not having any indexes on them :
Today, I got a question on this and decided to put the way here also.
SELECT [name] AS Tables_Without_Indexes
FROM sys.tables
WHERE OBJECTPROPERTY(OBJECT_ID,'IsIndexed') = 0
ORDER BY 1;
The above statemen...
[More]
There is a system stored procedure “sp_helpindex”, which can be used to get the list of all existing indexes by supplying table name to it. We can use this stored procedure as –
EXECUTE sp_helpindex my_Table_Name
[More]
I was looking for SQL Server diagram understanding and found a good article on Atif Shehzad.One can find and read this nice article - Getting started with SQL Server database diagrams
We can use sys.triggers view (object schema view) to know the status of trigger(s) in a database.
USE [myDatabaseName]
GO
SELECT * FROM sys.triggers
WHERE [is_disabled] = 1 ; -- 0:Enabled and 1:Disabled
To get the status of a particular trigger:
SELECT * FROM sys.triggers
WHER...
[More]
Two easiest command syntacx to disable /enable existing triggers on table are as below-
To Disable-
ALTER TABLE [mySchemaName].[myTableName] DISABLE TRIGGER myTriggerName
OR
DISABLE TRIGGER myTriggerName ON [mySchemaName].[myTableName]
To Enable-
ALTER TABLE [...
[More]