8 Simple Rules For Developing More Secure Code
Check out this article "8 Simple Rules For Developing More Secure Code" at http://msdn.microsoft.com/msdnmag/issues/06/11/SecureHabits/default.aspx Cheers!!!
Posts
- Get link
- X
- Other Apps
Again a Long time later
So its exactly 1 week that i updated my blog. So i was again at office. I am busy with oracle these days. I have installed Sql Server and finally started recollecting things.
I was browsing through orkut today. It is a real good site for friendship to grow and meet your old pals whom you missed your contact with.
Ok again i pledge that i will continue to blog regularly.
Cheers
- Get link
- X
- Other Apps
After a Long Gap
Its 5:50 PM on a easter sunday i am sitting in my office cubicle....... whatz up???????? hey nothing i am working even .. very dedicated .. just then i realised of not blogging for over 2 months ............... became very annoyed .......... and started of writing this snippet here. Hey i am just wondering whether i got tooooooooo much into the work that i forgot to blog. Its been some time i never saw the Sql Analyser as i am not working on it. I hope i recollect all the things back.........
Ok i will be blogging hereafter ...........
Cheers
- Get link
- X
- Other Apps
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...
- 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...