how to insert the multipe records in sql server with xml data

while inserting multiple records at a same time in a single transaction without failure (eg: bulk booking cinema tickets) means how to do this. for that inserting datas in sql server via xml is better.By using this we can also stop the transaction failure................. The following example shows how to insert the multiple records using xml data CREATE TABLE [dbo].[empinfo](     [eno] [int] NULL,     [ename] [varchar](50) ) Stored procedure: Create  Procedure sp_InsertEmp @in_XML Text AS Begin DECLARE @XMLHandle AS INTEGER   Declare  @temp table (empno int,  empname varchar(20) )...

Read More

How to backup all sql server 2005 databases

Backup all sql server 2005 Database using ScriptDECLARE @name VARCHAR(50) -- database name  DECLARE @path VARCHAR(256) -- path for backup files  DECLARE @fileName VARCHAR(256) -- filename for backup  DECLARE @fileDate VARCHAR(20) -- used for file name SET @path = 'C:\Backup\'  SELECT @fileDate = CONVERT(VARCHAR(20),GETDATE(),112) DECLARE db_cursor CURSOR FOR  SELECT name FROM master.dbo.sysdatabases WHERE name NOT IN ('master','model','msdb','tempdb')  OPEN db_cursor   FETCH NEXT FROM db_cursor INTO @name  ...

Read More