How Perform sql query "Insert in to Multiple table using single query"...

You can't use INSERT against two tables in one statement.
I would suggest to use transaction here. For example :

SET XACT_ABORT ON
BEGIN TRANSACTION

INSERT INTO [A](...) VALUES(...);
INSERT INTO [B](...) VALUES(...);

COMMIT TRANSACTION
SET XACT_ABORT OFF

Why do you need such type of query. You can perform this by simple using this:-

Insert into student (c_name) values ('moin')

Insert into address (city) values ('nadiad')

Hope, this will helps you...