.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Easy Web
Imran Ghani
Post New Web Links

How to renumber figures

Posted By:      Posted Date: September 27, 2010    Points: 0   Category :ASP.Net
 

I have a column in which I IdNumber this issue:
1
2
3
4
5
6
7
8
9
10

If the number 5 want to add one record how to renumber from there?

Example:
1
2
3
4
5
6 - INSERT NEW RECORD (
renumber)

7
8
9
10
11




View Complete Post


More Related Resource Links

Question about logical/physical reads figures

  
My script is: set   statistics io off set   nocount on --drop table mytbl create   table mytbl (x int) --create clustered index iii on mytbl(x) declare   @i int; set @i = 0 while   (@i < 10000) begin   insert into mytbl values (@i)   set @i = @i + 1 end set   statistics io on select   * from mytbl The result is: Table 'mytbl'. Scan count 1, logical reads 17, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0. My questions: 1. Why do I get 17 logical reads? an integer is 4 bytes. a data page is 8000 bytes. I have 10 thousand records times 4 bytes means 40 thousands bytes which fits to 5 data pages. why are there 12 extra logical reads? (ok there might be additional haeder and footer to the data page but that shouldn't get to an extra 12 pages) 2. why are there no physical reads? It's the first time i read from this table. Was the table stored in the cash when I inserted it? was it actually written to the disk data pages? 3. How can I know what data pages are currenctly stored in the buffer cache? (of which tables/indices)? 4. Is there a logical/physical writes couter? 5. When I add the clustered index I get 19 logical reads - why is that? thanks, Dror  

I am trying to extract 2 figures of 1-4 digits out of a string.

  

hey all. i am just starting with C# and programming , dont have much experience and i run into a problem i cant seem to fix for the past 3 days.

I have the string

"{Width=444, Height=455}"

And i am trying to extract only the 444,455 everything i tried so far result  in giving me the whole string back {Width=444, Height=455}.

Any help would be highly appreciated.



Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend