how can i get the time and date in the datecreated field in a data table while inserting a record?

how can i save the value of a field into a parameter in T-SQL?what i wrote is- Create Procedure a_c @C_Name varchar(100), as if exists( select id as 'ID' from ABC where C_Name = @C_Name) begin ---- end else begin --- end go is this syntax correct?and should i declare 'ID'and how can i do it?

how to generate primary keys automatically in SQL Server2000 using enterprise manager

is it possible in VS2003 to populate a dropdownlist control with data from a table in DB rather that manually entering values.....if yes how can we do that?

i want to know how i could create tabs in a web form?and wen those tabs are clicked how can i have different pages for each tab.

how do u do looping in T-SQL?

what is the most important factor to consider when overloading and overriding in c#?

Thank You Jay.:)That was really helpful.i have another question...if there are nN number of buttons in a datagrid and u want 2 know which button was clicked then what do u do?:confused:

how do you find out which button is clicked among many in a page?or what code should you write in page_Load method to find out which button was clicked?