SQLServer
http://www.devarticles.com/... Authors gives good brief on 10 cool features in SQL Server repository. xp_fileexist filename [, OUTPUT]exec master..xp_fileexist 'c:\test.file' xp_regread root_key, path_key, key_valuemaster..xp_regread 'HKEY_LOCAL_MACHINE', 'SYSTEM\Setup', 'SystemPartition' exec master..xp_repl_encrypt @cardNumber1 output exec master..xp_dirtree 'c:\mydir'set @xml = '' exec sp_xml_preparedocument @id output, @xmlselect...
http://www.devarticles.com/... Authors gives good brief on 10 cool features in SQL Server repository. xp_fileexist filename [, <file_exists INT> OUTPUT]exec master..xp_fileexist 'c:\test.file' xp_regread root_key, path_key, key_valuemaster..xp_regread 'HKEY_LOCAL_MACHINE', 'SYSTEM\Setup', 'SystemPartition' exec master..xp_repl_encrypt @cardNumber1 output exec master..xp_dirtree 'c:\mydir'set @xml = '<people><person name="John...
A Survey of Microsoft SQL Server 2000 XML Features from Andrew Conrad This describes latest features on XML with SQL Server with abstract example - Worth of reading http://msdn.microsoft.com/l
http://www.lumigent.com/go/... Find Data-Recovery and Best Practices white paper from By Stephen Wynkoop, Microsoft SQL Server MVP(Founder The SQL Server Worldwide User’s Group) Tips on Triggers Encrypting Trigger DefinitionsIf you want to ensure that other users cannot view the trigger definition, you can use the WITH ENCRYPTION clause. The trigger definition is then stored in an unreadable form.Once encrypted, the definition of the trigger cannot be decrypted and cannot be viewed by anyone,...
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...
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