brcraju@hotmail.com
There are 11 entries for the tag
SQL
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/library/default.asp?url=/library/en-us/dnexxml/html/xml03172004.asp
Find these cool BizTalk Server Installation 1) Windows 2000 Server / Advanced / Professional 2) Service pack 1 is mandatory 3) Must add Windows 2000 user account to the Administrators group before you install any software. 4) Message Queuing Service is mandatory. 5) Internet Information Service (IIS) is mandatory. 6) NTFS partition is recommended. 7) To avoid problems accessing and saving specifications to the BizTalk Server 2000 repository, you must turn off the Enable Authoring option in Internet ......
BizTalk Orchestration DesignerVisually define and build robust, distributed business processes. Long-Running TransactionsEnsure transactional integrity on asynchronous transactions that span minutes, days, or even weeks. Concurrency and SynchronizationInitiate several independent business processes simultaneously and synchronize them at defined meeting points. Advanced Process CorrelationManage multiple independent simultaneous instances of business processes. Business Process State ManagementTrack ......
Data Reader: Forward-only data read Equivalent to: Recordset's CursorType = adOpenForwardOnly, LockType = adLockReadOnly (often referred to as a "fire-hose" cursor) DataReader Four Execute Methods through Command object: ExecuteReader - Simply executes the SQL query against the database, using the Read() method to traverse through data, as illustrated below ExecuteNonQuery - Used whenever you work with SQL stored procedures with parameters, as illustrated in the Stored Procedures section below ExecuteScalar ......
Using C#: using System.Data.SqlClient;...Sq... oSQLConn = new SqlConnection();oSQLConn.Co... = "Data Source=(local);" + "Initial Catalog=mySQLServerDBName;" + "Integrated Security=SSPI";oSQLConn.Ope... Using VB.NET: Imports System.Data.SqlClient...Dim oSQLConn As SqlConnection = New SqlConnection()oSQLConn.Con... = "Data Source=(local);" & _ "Initial Catalog=mySQLServerDBName;" & _ "Integrated Security=SSPI"oSQLConn.Open() If connection to a remote server (via ......
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, ......
Futuristic Features of Oracle 10g (Grid technology) On the database side we are hearing a voice of grid from database giant – ORACLE, It says The central idea of grid computing is computing as a utility. What is this Grid all about? You shouldn’t care where your data resides, or which computer processes your request. You should be able to request information or computation and have it delivered – as much as you want, and whenever you want. This is analogous to the way electric ......
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