October 2003 Entries
Great article on Overview of 64bit SQL by Ram Kishore (ramki120@hotmail.com) http://www.sqlservercentral... The Publisher says "This is a great article, seems like it covers almost every question you might have about installing and using the 64 bit version of SQL2K" Pretty work Ram Kishore :)...
Simple quries to check whether they are existing in database or not. 1. Checking whether procedure exist in the NORTHWIND database with name 'CustOrdersDetail' Approach -1: use NORTHWIND if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CustOrde... and OBJECTPROPERTY(id, N'IsProcedure') = 1) print 'CustOrdersDetail Exists in the NORTHWIND database' else print 'CustOrdersDetail *does not exist* in the NORTHWIND database' Approach -2: Use NORTHWIND if exists(select * from...
Optical DSPs promise tera-ops performance Startup Lenslet Labs has demonstrated an optically based digital signal processing engine (ODSPE) that has the potential to take DSPs from the current giga-operations-per-second (Gops) limit to tera operations per second (Tops) by 2005, the company announced at the inaugural Communications Design Conference in San Jose last week. http://www.eetimes.com/stor... Lenslet site: http://www.lenslet.com/inde... Here is my admired praise to (32)...
Find overview of Programming C# http://www.jaggersoft.com/p
SQL Server 2000's Coolest Features Just when you think you have a handle on SQL Server 7.0, Microsoft ships a new SQL Server release. SQL Server 2000 might skip 1,993 release numbers, but you won't find the same degree of difference between SQL Server 2000 and 7.0 as you found between SQL Server 7.0 and 6.5. Even so, this latest release is full of new functionality. Here are seven of my favorite new SQL Server 2000 features. 7. Integrated XML Support XML support is key to Microsoft's push to Web-enable...
Simple way to Remove Duplicate Rows from an Existing Table in SQL SELECT DISTINCT * INTO duplicate_table FROM original_table GROUP BY key_value HAVING COUNT(key_value) > 1 DELETE original_table WHERE key_value IN (SELECT key_value FROM duplicate_table) INSERT original_table SELECT * FROM duplicate_table DROP TABLE duplicate_table