How to make sql query result to xml file

Method 1:

SELECT *
FROM dbo.YourStudentTable
FOR XML PATH('Student'), ROOT ('Students')

Method 2:

DECLARE @x xml
SET @x=( SELECT *
FROM dbo.YourStudentTable  FOR XML RAW, TYPE,ROOT('myRoot'))
SELECT @x

Method 3:

SELECT * from  dbo.YourStudentTable
FOR XML RAW ('Employee'), ROOT ('Employees'), ELEMENTS XSINIL;

Basic English Listening Lessons

Basic English Listening Lessons

http://www.talkenglish.com/Listening/ListenBasic.aspx

http://www.englishinuse.net/

Short Stories:

http://www.english-for-students.com/Short-Stories.htmlStories 

http://www.english-for-students.com/Simple-Short-Stories.html


Work on this:

http://www.tolearnenglish.com/english_lessons/simple-english-stories



Online Writing Support

http://www.towson.edu/ows/index.asp

Reading

http://www.englishforeveryone.org/Topics/Reading-Comprehension.htm

http://www.muskingum.edu/~cal/database/general/reading.html

http://www.worldstories.org.uk/stories/stories?lang=tamil

Listening

http://www.learnenglishfeelgood.com/eslvideo/

http://esl.about.com/od/listeningquizzes/

English_Listening_Comprehension_Quizzes_for_ESL_EFL.htm

Speaking

http://www.talkenglish.com/

http://www.englishleap.com/other-resources/spoken-english-tips

http://www.focusenglish.com/dialogues/conversation.html


Frequently Used Sentences in English: 

http://www.english-for-students.com/Frequently-Used-Sentences.html

Practical Dialogue:

https://www.agendaweb.org/listening/practical-english-conversations.html

http://www.focusenglish.com/dialogues/communication/commindex.html

Listing all tables in a database and their row counts in SQL Server

CREATE TABLE #counts
(
    table_name varchar(255),
    row_count int
)

EXEC sp_MSForEachTable @command1='INSERT #counts (table_name, row_count) SELECT ''?'', COUNT(*) FROM ?'
SELECT table_name, row_count FROM #counts ORDER BY row_count DESC

Income Tax e-filling and details

https://incometaxindiaefiling.gov.in/e-Filing/UserLogin/LoginHome.html

Explain about Metrics and types of metrics like schedule variance , effort variance?

Before Going to the concepts, please know what are these and
from where it will come and who will measure

All these are called as Some Metric Measurement,
All these will be calculated by Project QA and Manager,
All these are coming from Project Plan

Effort Variance--Number of Man Months Working for Particular
Module and Difference between Actual and Planned Resources

Ex: For a particular Module 6 resource need to be work but
only 5 are working ,so there will be a lag of resource,then
effort variance will occur

Schedule Variance--Number of Man Months Working for
Particular Module for Number of Days

here both effort variance and Schedule Variance are directly
propositional

---------------------------------------------------------------------------------------------------------------------------
Note: 

Planned Effort is the actual estimate you received from the Client. If you do your own estimate based on the planned effort you get from the client then that will be a different scenario.

Effort Variance should be (Actual Effort - planned Effort)/ Planned Effort.

EV should calculate w.r.t Person Days.

Schedule variance should be (Actual End Date - Planned End Date)/Planned End Date.

SV should calculate w.r.t Person Hours.

-------------------------------------------------------------------

Free Latest Software Download Sites

http://getintopc.com/

http://www.filehippo.com/

Visio Professional 2013 Features

The unique Visio 2013 Pro Features are:

1. Easier to create diagrams
2. improved tools for frequently use
3. Enhanced stencil and Shapes
4. New Themes
5. Collaboration with in Team is now easy
6. Dynamic Diagrams Creation
7. link Real time Data with Shapes
8. Easy diagrams sharing
9. Updated Standards for Diagrams
10. Create Business Process Models
11. Activity diagrams creations
12. UML Standards Diagrams and Use Cases Development
13. power flow charts Engine

More information:

http://getintopc.com/softwares/development/download-visio-professional-2013-free/