SQL Server Basic Questions
-
Hi all, 1.can any one please explain me what are this DTS? and why we use this DTS? 2.what is the difference b/w Stored procedure & Function? 3.what are Cursors? 4. what is a join and it's types? Thanks, Rahi
If you look at what you do not have in life, you don't have anything, If you look at what you have in life, you have everything... "
-
Hi all, 1.can any one please explain me what are this DTS? and why we use this DTS? 2.what is the difference b/w Stored procedure & Function? 3.what are Cursors? 4. what is a join and it's types? Thanks, Rahi
If you look at what you do not have in life, you don't have anything, If you look at what you have in life, you have everything... "
Rahithi wrote:
1.can any one please explain me what are this DTS? and why we use this DTS?
Data Transformation Services. Supersceded by SSIS (SQL Server Integration Services). It allows you to extract, load and transform data between different databases.
Rahithi wrote:
2.what is the difference b/w Stored procedure & Function?
A function must be deterministic. A stored procedure doesn't have to be. Stored procedures are more flexible in what you can do within them. Functions can be used inside a SELECT statement, but stored procedures can't. e.g.
SELECT * FROM dbo.FunctionName(1, 2, 3)
Rahithi wrote:
3.what are Cursors?
Cursors provide a way to iterate over a result set in a procedural way. They are slow and should be avoided unless you cannot do what is required in a set based operation.
Rahithi wrote:
4. what is a join and it's types?
A join is a way of combining the data in two or more tables into one result set. For more details see Types of Join[^]
Upcoming Scottish Developers events: * Glasgow: Tell us what you want to see in 2007 My: Website | Blog | Photos
-
Hi all, 1.can any one please explain me what are this DTS? and why we use this DTS? 2.what is the difference b/w Stored procedure & Function? 3.what are Cursors? 4. what is a join and it's types? Thanks, Rahi
If you look at what you do not have in life, you don't have anything, If you look at what you have in life, you have everything... "
a google is highly recommended
-
Hi all, 1.can any one please explain me what are this DTS? and why we use this DTS? 2.what is the difference b/w Stored procedure & Function? 3.what are Cursors? 4. what is a join and it's types? Thanks, Rahi
If you look at what you do not have in life, you don't have anything, If you look at what you have in life, you have everything... "
Unless you're just asking out of curiosity you'll really need to dig into a good book which addresses each of the topics in detail. Off the top of my head I'd say SQL Server Unleashed would be a good place to start. It should address each and every one of those questions and show you how to use them as well.