Long Night
It was a long night at office. Working towards a release..............
Had some Database problem.. It was giving an error "user or role exists in the current database"
Finally it was sorted out.
A Hard day out and i am really tired..
Posts
- 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...