Database

select disk_reads,sql_text 
from v$sqlarea 
where disk_reads > 10000 
order by disk_reads desc

if not exists(select * from tblStafff where StaffID = @StaffID)
Begin
   -- Add record
End

ALTER PROCEDURE SP_CHECKDUPLICATEID
	-- Add the parameters for the stored procedure here
	(@ID INT)
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;

    -- Insert statements for procedure here

	-- VARIABLE DECLARATIONS
	
    IF ( (SELECT COUNT(*) FROM TBLSTAFF WHERE ID=@ID) = 0 )

	BEGIN

		INSERT INTO TBLSTAFF(ID) VALUES(@ID)

	END
END
GO

Phumlani Kunene wrote:

How to code connection string for retriving database when is online?

Phumlani Kunene wrote:

How to code dynamic connection string?

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
  <configSections>
  </configSections>
  <connectionStrings>   
    <add name="dbName" connectionString="Data Source=DBServer\SQLEXPRESS;Initial Catalog=DBHM;Integrated Security=True"
      providerName="System.Data.SqlClient" User Name="Niladri" Pwd="password"/>
  </connectionStrings>  
</configuration>

a)name="dbName" ; 

It is a string which we will access from the class file

b)Data Source</b>=DBServer\SQLEXPRESS;; 

The database server name 

c)Initial Catalog</b>=DBHM; 

The database name

System.Configuration.ConfigurationManager.ConnectionStrings["dbName"].ConnectionString;

<add name="dbName1" connectionString="Data Source=DBServer\SQLEXPRESS;Initial Catalog=DBHM1;Integrated Security=True"
      providerName="System.Data.SqlClient" />

<add name="dbName2" connectionString="Data Source=DBServer\SQLEXPRESS;Initial Catalog=DBHM2;Integrated Security=True"
      providerName="System.Data.SqlClient" />

<add name="dbName3" connectionString="Data Source=DBServer\SQLEXPRESS;Initial Catalog=DBHM3;Integrated Security=True"
      providerName="System.Data.SqlClient" />

<add name="dbName4" connectionString="Data Source=DBServer\SQLEXPRESS;Initial Catalog=DBHM4;Integrated Security=True"
      providerName="System.Data.SqlClient" />

SqlConnection Conn = new SqlConnection();
switch(condition)
{

case 1: Conn.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["dbName1"].ConnectionString;
break;

case 2: Conn.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["dbName2"].ConnectionString;
break;


case 3: Conn.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["dbName3"].ConnectionString;
break;


case 4: Conn.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["dbName4"].ConnectionString;
break;
}

Conn.Open();