Wednesday, September 26, 2012

record speaker and microphone at the same time

record speaker and microphone at the same time

control panel > sound > recording > set "Stereo Mix" as default.

Note: if "Stereo Mix" is not present, right click to enable it.

control panel > sound > recording > Microphone > Properties > Listen > check "Listen to this device" > playback through this device "Speaker"

control panel > sound > Communications > select "Do nothing".

Friday, September 21, 2012

Generate a lot of dummy data records rows

Create a new stored procedure:

BEGIN
 DECLARE x  INT;
 SET x = 1;

 WHILE x  <= 5 DO
  INSERT INTO PRODUCTS (CategoryID, ModelNumber, ModelName, ProductImage, UnitCost, Description) VALUES (x, x, x, x, x, x);
  SET x = x + 1;
  END WHILE;
END

And Run it.