SQL Server 2005 : Generate Sequence number and delete rows with top

Generate Sequence Number in SQL 2005

Select ROW_NUMBER() OVER(ORDER BY Column_Name) As ID,* From Table_Name


Delete First Row in SQL 2005

WITH T1 AS (Select Id,FirstName,LastName, ROW_NUMBER()
OVER (PARTITION BY Id,FirstName,LastName Order By Id) AS NUMBER From TEMP)
Delete From T1 Where Number > 1


The Most easiest way to delete first row in SQL 2005 is,

Delete top (1) From Table_Name

Java script Confirm with Yes No buttons

You can write javascript with diffrent button options like YesNo, YesNoCancel etc.
You can change the code 4132 and see the O/P.
To Complete this task, just write following java script in your code,
< script language=javascript >

function window.confirm(str)
{
  execScript('n = msgbox("'+str+'","4132","Title")', "vbscript");
  return(n == 6);
}

</script>

In this script, the line will execute vbScript's Message box withYesNo Option.
execScript('n = MsgBox("Yes Or No?",vbYesNo,"Title")', "vbscript");

SQL Stuff

--- Database transactions
begin tran
rollback tran
Save Transaction tran_name

--Deletes last row inserted in table Employees
declare @topN int
set @topN = 1
set rowcount @topN
Delete From Employees


--Makes ROWCOUNT Off
--Once the rowcount is set , it is set until you explicitly make off
Set ROWCOUNT 0

Important :
When a transaction begins,
resources used during the transaction are held until the completion of the transaction
(namely locks).
When part of a transaction is rolled back to a savepoint, resources
continue to be held until the completion of the transaction
(or a rollback of the complete transaction).


@@TRANCOUNT
Returns the number of active transactions for the current connection.

@@ROWCOUNT
Returns the number of rows affected by the last statement.

@@IDENTITY
Returns the last-inserted identity value.

@@FETCH_STATUS
Returns the status of the last cursor FETCH statement issued against any cursor currently opened by the connection.

Return value Description
0 FETCH statement was successful.
-1 FETCH statement failed or the row was beyond the result set.
-2 Row fetched is missing.

@@ERROR
Returns the error number for the last Transact-SQL statement executed.

@@DBTS
Returns the value of the current timestamp data type for the current database. This timestamp is guaranteed to be unique in the database.

Creates a user-defined data type.
sp_addtype [ @typename = ] type,
  [ @phystype = ] system_data_type
  [ , [ @nulltype = ] 'null_type' ]
  [ , [ @owner = ] 'owner_name' ]

Perform shallow copy of an object : example

To Perform shallow copy of an object MemberwiseClone() function is used.
In this example, you can also observe the behavior of static and non-static members.
To understand this function create Console Application.
In Console Application create class MyBaseClass as follows.
  class MyBaseClass
  {
  public static string CompanyName = "My Company";
  public int age;
  public string name;
   
//overides to string method
  public override string ToString()
  {
  return string.Format("CompanyName = {0}, age = {1}, name = {2}", CompanyName, age, name);
  }
  }
Now, Rename Program.cs to MyDerivedClass.cs,  paste following code,  and check output.
  class MyDerivedClass : MyBaseClass
  {
  static void Main(string[] args)
  {
  // Creates an instance of MyDerivedClass and assign values to its fields.
  MyDerivedClass m1 = new MyDerivedClass();
  MyDerivedClass.CompanyName = "Softweb Solutions";
  m1.age = 42;
  m1.name = "Sam";

  //Performs a shallow copy of m1 and assign it to m2. (Value Type)
  MyDerivedClass m2 = (MyDerivedClass)m1.MemberwiseClone();

  //Performs a copy of m1 and assign it to m3. (Reference Type)
  MyDerivedClass m3 = m1;


  Console.WriteLine("\nBefore Change");

  Console.WriteLine("Object m1---------:" + m1.ToString());
  Console.ReadKey();

  Console.WriteLine("Object m2---------:" + m2.ToString());
  Console.ReadKey();

  Console.WriteLine("Object m3---------:" + m3.ToString());
  Console.ReadKey();

  //Now Change m1 and print m1, m2, and m3
  MyDerivedClass.CompanyName = "TRC";
  m1.age = 100;
  m1.name = "Charles";

  Console.WriteLine("\n\nAfter Change");

  Console.WriteLine("Object m1---------:" + m1.ToString());
  Console.ReadKey();

  Console.WriteLine("Object m2---------:" + m2.ToString());
  Console.ReadKey();

  Console.WriteLine("Object m3---------:" + m3.ToString());
  Console.ReadKey(); 
  }
  }

New operator ?? in c#

The operator '??' is in c#, which is used check the value is null.
Previously, we used to check the null value by the following methods..

if (a!=null) { c=a; } or
c = ((a!=null)?a:0);

we can do the same checking with the new operator ?? like this..
c = a??0;

By this statement the value a will be assigned to c if it is not null else the zero will be assigned. 

Locate nested controls easily

Finding controls within a Page's control hierarchy can be painful but if you know how the controls are nested you can use the lesser known "$" shortcut to find controls without having to write recursive code. The following example shows how to use the DefaultFocus property to set the focus on a textbox that is nested inside of a FormView control. Notice that the "$" is used to delimit the nesting: 

<form id="form1" runat="server" DefaultFocus="formVw$txtName">
  <div>

  <asp:FormView ID="formVw" runat="server">
  <ItemTemplate>

  Name: 
  <asp:TextBox ID="txtName" runat="server" 

  Text='<%# Eval("FirstName") + " " + Eval("LastName") %>' />
  </ItemTemplate>

  </asp:FormView>

  </div>
</form> 

This little trick can also be used on the server-side when calling FindControl().
Here's an example: 

TextBox tb = this.FindControl("form1$formVw$txtName") as TextBox;

if (tb != null)

{
  //Access TextBox control
} 

Set the default focus to a control when the page loads

 This is extremely simple thing that can be done without resorting to writing JavaScript. If you only have a single textbox (or two) on a page why should the user have to click in the textbox to start typing? Shouldn't the cursor already be blinking in the textbox so they can type away? Using the DefaultFocus property of the HtmlForm control you can easily do this. 

< form id="frm" DefaultFocus="txtUserName" runat="server" >
  ...
</form>