How to change Caps Lock key to Shift key in Microsoft Windows 7 or disable it

0 Comments

If you want to change the Caps Lock key to a Shift key, use the following registry changes:   Windows Registry Editor Version 5.00 [HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Keyboard Layout] "Scancode Map"=hex:00,00,00,00,00,00,00,00,02,00,00,00,2a,00,3a,00,00,00,00,00   If you want to completely disable

Create table in T-SQL with named primary key and foreign key

0 Comments

Just a simple example of creating a table by using T-SQL: if not exists(select 1 from sys.objects where object_id = object_id(‘Product’)) begin   create table [dbo].[Product]   (     [Id] [int] not null identity (1,