Sleepless Night
Again the work continued the whole night.
This is some info on Extended SP's
Insight to Extended Stored Procedures
For a long time i was thinking about this Extended Stored Procedures that we have SQL SERVER. Here i am going to explain the usage of few of the Extended Stored Procedures.Before i begin with the explaination of few the Extended Sps, Let me define what is a Extended Stored Procedures.
An Extended Stored Procedure is one which has its functionality logic in a Dynamic Link Library and these functions can be called for the TSQL as normal procedures.
Lets begin with the usage of few of the Extended Stored Procedures.
1.xp_fixeddrives
This will give us the drives in your machine.
exec master..xp_fixeddrives
2.xp_dirtree
This one will return the directory structure of the path provided.
EXEC xp_dirtree 'C:\Program Files\Microsoft SQL SERVER\'
3.xp_fileexist
This will give whether the file exists or not.
EXEC xp_fi...
Posts
Showing posts from 2003
- Get link
- X
- Other Apps
A simple piece of code
This is a code to select the #row from a table.
For example if you give 2 it will select the second row from the table.
The procedure is
create procedure SP_FETCH_ROWS(@num int)
AS
BEGIN
select * from employee a where @num=(select count(*) from employee b where a.id >= b.id)
END
The table i am using employee. The structure is
id int
name varchar(50)
age int
sex char(1)
The rows in my table are
id name age sex
----------- -------------------------------------------------- ----------- ----
1 shaju 25 M
2 thomas 25 M
3 anil 25 M
4 ashley 25 M
Now when execute the procedure to select the third row
exec SP_FETC...
- Get link
- X
- Other Apps
Something Abt Sql Server Yukon.
Have a look :)
What You Need to Know About SQL Server Yukon
The next version of Microsoft SQL Server, code-named Yukon, is set for a mid-2003 beta 1 test and an early 2004 release. Microsoft considers this release to be as crucial to the company's plans as Windows Server 2003, saying that Yukon will be a database server upgrade and also a platform on which Microsoft will base future versions of Active Directory (AD), Microsoft Exchange Server, the Windows file system, and other products. Microsoft says that Yukon is all about programmability, enterprise database enhancements, and business intelligence. Here's what you need to know about Yukon.
Programmability
Because of its deep integration with the Windows .NET Framework and Common Language Runtime (CLR), Yukon will be a significant release for developers, who, for the first time, will be able to use languages other than T-SQL to program the database. In the past, developers w...