MS SQL: Reset identity seed
Occasionally, I need to reset the value of the identity column in MS SQL database. I keep forgetting how to do this, and have to search all the time. So here is a note to myself: DBCC CHECKIDENT (TableName, RESEED, 0)
Occasionally, I need to reset the value of the identity column in MS SQL database. I keep forgetting how to do this, and have to search all the time. So here is a note to myself: DBCC CHECKIDENT (TableName, RESEED, 0)
Warning: this guide is only a personal note to remind myself when I have to restore Grub again. In my previous post, I had just installed Windows 7 as a dual boot with Debian on my Toshiba laptop. The following describe the steps taken to restore the Grub boot loader so that Debian can be started again. I booted the laptop with Ubuntu Live CD, then open a Terminal. To get the partition tables, as a root execute the fdisk command: ...
I just finished installing Windows 7 64-bit Ultimate edtion on my 1+ year old Toshiba laptop. The model is Satellite A200-*****. The installation went smoothly, well almost. On the first boot, the graphic card driver, the finger print reader were automatically updated with Windows update. The only two devices which weren’t detected are: unknown device “ACPITOS6205” (bluetooth) and the Texas Instrument 5-in-1 card reader. The 64-bit driver for the bluetooth can be downloaded from: http://aps2.toshiba-tro.de/bluetooth/ thanks to this post at Toshiba Laptop forum. ...
Suppose we have the following code sinppets: <br /> private BlogDataContext db = new BlogDataContext ();<br /> ... article.Created = DateTime.UtcNow; article.Modified = DateTime.UtcNow; db.Articles.InsertOnSubmit(article); db.SubmitChanges( ); The ID of the article is automatically generated. How do we get the Id of the newly inserted record? It turns out that the article is updated with the value of Id after the method SubmitChanges( ) is invoked. So, we can just get the Id this way: ...
There are probably a gazillion ways to do this. I use FAAC, Freeware Advanced Audio Coder, to do this job. It works very well: <br /> faac originalfile.wav -o outputfile.m4a<br />