While Shameel and Russel gave you answers it is not the solution, if you are relying on the identity filed to give you sequential information (or any information) your design is WRONG. An ID field has only 1 function, to identify the record.
Never underestimate the power of human stupidity
I also read articles from http://www.sqlservercentral.com/[^] and they have a good Question of the Day feature that gets emailed to you daily so that you can test your knowledge etc.
Lobster Thermidor aux crevettes with a Mornay sauce, served in a Provençale manner with shallots and aubergines, garnished with truffle pate, brandy and a fried egg on top and Spam - Monty Python Spam Sketch
You need to decide what start with. Do you want a general overview? To learn to code (T-SQL)? To learn how to be a DBA? Do you want a certificate?
I would go to a bookstore with a good computer section and look at the SQL books. As an example, have a question in mind, say for T-SQL, lookup data types. If you can understand what they say, that book would be high on the possible list.
Hi.. Recently i created Session State in my project, code is here.. <sessionState mode="SQLServer" allowCustomSqlDatabase="true" sqlConnectionString="Data Source=ADMIN-9F8C57749\SQLEXPRESS;Initial Catalog=kecbliss;Integrated Security=True" timeout="60" stateNetworkTimeout="60"> </sessionState> the problem is day by day aspstatetempsessions table is becoming big so my question is 1.can i delete previous days records from aspstatetempsessions? 2.How to achieve this without affecting to project ? project details front end ASP.NET Back end MS SQL Server
Last Visit: 31-Dec-99 18:00 Last Update: 26-Oct-16 20:17