Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.
I ran into an error when one of the search_name field values was O'leary because of the single quote. How can I avoid it but include it in the search?
Dim connectionString As String = "Data Source=AV-W12-ROMS-1;Initial Catalog=RESUMES;Integrated Security=True" Dim sql As String = "" Dim connection As New SqlConnection(connectionString) Dim cmd As New SqlCommand sql = "SELECT IsNull(COUNT(1),0) as 'count' FROM RESUMES.dbo.ftbl_resume_files WHERE CONTAINS([name],'" + search_name + "')" connection.Open() cmd.Connection = connection cmd.CommandText = sql name_count = cmd.ExecuteScalar() connection.Close()
|Oracle DB monitor SW||21||48|
|MS SQL tables, .net application and ETL connundrum||3||54|
|SELECT query on two levels (detail and summary)||13||48|
|T-SQL: New to using transactions||9||22|