Translate
Monday, 13 October 2014
Friday, 10 October 2014
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;
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;
Wednesday, 8 October 2014
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
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
Wednesday, 1 October 2014
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
(
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
Monday, 15 September 2014
Friday, 5 September 2014
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.
-------------------------------------------------------------------
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.
-------------------------------------------------------------------
Wednesday, 3 September 2014
Subscribe to:
Posts (Atom)