New RTO code list for vehicle registration of Rajasthan 2012

This is a list of the Rajasthan RTOs and the assigned codes for vehicle registration

Code	RTO Office Name	Code	RTO Office Name
RJ-01	Ajmer	RJ-24	Sirohi
RJ-02	Alwar	RJ-25	Sawai Madhopur
RJ-03	Banswara	RJ-26	Tonk
RJ-04	Barmer	RJ-27	Udaipur
RJ-05	Bharatpur	RJ-28	Baran
RJ-06	Bhilwara	RJ-29	Dausa
RJ-07	Bikaner	RJ-30	Rajsamand
RJ-08	Bundi	RJ-31	Hanumangarh
RJ-09	Chittaurgarh	RJ-32	Kotputli
RJ-10	Churu	RJ-33	Ramganj Mandi
RJ-11	Dholpur	RJ-34	Karauli
RJ-12	Dungarpur	RJ-35	Pratapgarh
RJ-13	Sri Ganganagar	RJ-36	Beawar
RJ-14	Jaipur	RJ-37	Didwana
RJ-15	Jaisalmer	RJ-38	Abu Road
RJ-16	Jalore	RJ-39	Balotara
RJ-17	Jhalawar	RJ-40	Bhiwari
RJ-18	Jhunjhunu	RJ-41	Chomu
RJ-19	Jodhpur	RJ-42	Kishangarh
RJ-20	Kota	RJ-43	Phalodi
RJ-21	Nagaur	RJ-44	Sujangarh
RJ-22	Pali	RJ-45	Jaipur North
RJ-23	Sikar

How to Find Number of Record in All Table in SQL SERVER

DECLARE @name VARCHAR(500)
DECLARE @sql VARCHAR(1000)

CREATE TABLE #TableRecordCount
( TableName VARCHAR(100),
  RecordCount INT
)

DECLARE dbCursor CURSOR FAST_FORWARD
FOR SELECT T.NAME FROM SYSOBJECTS T WHERE T.XTYPE = 'U' AND LEFT(T.NAME,1)<>'_' AND NOT T.NAME='Timeline' ORDER BY T.NAME

OPEN dbCursor
FETCH NEXT FROM dbCursor INTO @name
WHILE @@FETCH_STATUS = 0
BEGIN
      SET @sql = 'INSERT INTO #TableRecordCount (TableName, RecordCount) '
      SET @sql = @sql + 'SELECT ''' + @Name + ''' AS TableName, COUNT(*) AS CNT '
      SET @sql = @sql + 'FROM [' + @name + ']'
      EXEC (@sql)
      FETCH NEXT FROM dbCursor INTO @name
END

CLOSE dbCursor
DEALLOCATE dbCursor

SELECT SUM(RecordCount) FROM #TableRecordCount
SELECT * FROM #TableRecordCount WHERE RecordCount>50 ORDER BY RecordCount DESC

DROP TABLE #TableRecordCount

Delete An undeletable File

Open a Command Prompt window and leave it open.
Close all open programs.
Click Start, Run and enter TASKMGR.EXE
Go to the Processes tab and End Process on Explorer.exe.
Leave Task Manager open.
Go back to the Command Prompt window and change to the directory the AVI (or other undeletable file) is located in.
At the command prompt type DEL <filename> where <filename> is the file you wish to delete.
Go back to Task Manager, click File, New Task and enter EXPLORER.EXE to restart the GUI shell.
Close Task Manager.


Or you can try this

Open Notepad.exe

Click File>Save As..>

locate the folder where ur undeletable file is

Choose 'All files' from the file type box

click once on the file u wanna delete so its name appears in the 'filename' box

put a " at the start and end of the filename
(the filename should have the extension of the undeletable file so it will overwrite it)

click save,

It should ask u to overwrite the existing file, choose yes and u can delete it as normal


Here's a manual way of doing it. I'll take this off once you put into your first post zain.

1. Start
2. Run
3. Type: command
4. To move into a directory type: cd c:\*** (The stars stand for your folder)
5. If you cannot access the folder because it has spaces for example Program Files or Kazaa Lite folder you have to do the following. instead of typing in the full folder name only take the first 6 letters then put a ~ and then 1 without spaces. Example: cd c:\progra~1\kazaal~1
6. Once your in the folder the non-deletable file it in type in dir - a list will come up with everything inside.
7. Now to delete the file type in del ***.bmp, txt, jpg, avi, etc... And if the file name has spaces you would use the special 1st 6 letters followed by a ~ and a 1 rule. Example: if your file name was bad file.bmp you would type once in the specific folder thorugh command, del badfil~1.bmp and your file should be gone. Make sure to type in the correct extension.