Reseed/Reset Table Identity Value

DBCC CHEKIDENT Used To Reset Your Table Value
For Example

    If  We Want Next Record To Have Identity As 135 We Need To Run Sql Query To :

DBCC CHECKIDENT (yourTABLEname, reseed, 134)

                                                             For More Details Visit Microsoft Tech Lab

WebService Url

http://www.mikesdotnetting.com/Article/104/Many-ways-to-communicate-with-your-database-using-jQuery-AJAX-and-ASP.NET

WebService , Ajax

  <script type="text/javascript">
    $(document).ready(function(){
    $("#Customers").change(function(){
    //Using Load Method
       $("#CustomerDetails").load("FetchCustomer.aspx?CustomerID=" + $('#Customers').val());
     });

    //Using getMethod
    $.get("FetchCustomer.aspx",
       { CustomerID: "" + $('#Customers').val() + "" },
       function(data){
                $('#CustomerDetails').html(data);
                });
 
     //Using Ajax Method
      $.ajax({
               contentType : "text/html;charset=utf-8",
               data:"CustomerID="+$('#Customers').val(),
               url:"FetchCustomer.aspx",
               dataType:"html",
               success:function(data){
                $('#CustomerDetails').html(data);
                }
             });
          });
     });
    </script>

Drop All Procedures

DECLARE @name VARCHAR(128)

DECLARE @SQL VARCHAR(254)

SELECT @name = (SELECT TOP 1 [name] FROM sysobjects WHERE [type] = 'P' AND category = 0 ORDER BY [name])

WHILE @name is not null

BEGIN

    SELECT @SQL = 'DROP PROCEDURE [dbo].[' + RTRIM(@name) +']'

    EXEC (@SQL)

    PRINT 'Dropped Procedure: ' + @name

    SELECT @name = (SELECT TOP 1 [name] FROM sysobjects WHERE [type] = 'P' AND category = 0 AND [name] > @name ORDER BY [name])

END

GO

C# Sql Connection String

connetionString="Data Source=ServerName;
  Initial Catalog=DatabaseName;User ID=UserName;Password=Password"

  cnn = new SqlConnection(connetionString);

Example

string connetionString = null;

            SqlConnection cnn ;

   connetionString = "Data Source=ServerName;Initial Catalog=DatabaseName;User ID=UserName;Password=Password" 

            cnn = new SqlConnection(connetionString);

            try

            {

                cnn.Open();

                MessageBox.Show ("Connection Open ! ");

                cnn.Close();

            }

            catch (Exception ex)

            {

                MessageBox.Show("Can not open connection ! ");

            }

Delete single row from duplicate rows in SQL Server 2005

DECLARE @ID int

DECLARE @NAME NVARCHAR(50)
DECLARE  @COUNT int

DECLARE CUR_DELETE CURSOR FOR
SELECT [ID],[NAME],COUNT([ID]) FROM [Example] GROUP BY [ID],[NAME] HAVINGCOUNT([ID]) > 1

OPEN CUR_DELETE

FETCH NEXT FROM CUR_DELETE INTO @ID,@NAME,@COUNT
/* Loop through cursor for remaining ID */
WHILE @@FETCH_STATUS = 0
BEGIN

DELETE TOP(@COUNT -1) FROM [Example] WHERE ID = @ID

FETCH NEXT FROM CUR_DELETE INTO @ID,@NAME,@COUNT
END

CLOSE CUR_DELETE
DEALLOCATE CUR_DELETE

Blog Started

Today 29'th Feb 2012 started my blog..........