Thursday, 15 November 2018

How can I take backup of particular tables in SQL Server 2008?

Process:

SELECT * INTO new_table_1
FROM existing_table_1
 
--- For table 2

SELECT * INTO new_table_2 
 FROM existing_table_2
 
and so on... for n number of tables

This statement WILL CREATE the tables called new_table_1, new_table_2 ,.. thus you do not have to previously create it.

Note: This process takes the backup quite fast but major disadvantage would be that it does not carry over the Keys, Indexes and Constraints of the table and backup is stored within the database not somewhere externally to a file.
 
Posted by at No comments:
Labels:

Friday, 31 August 2018

Clock Wise / Anti Clock Wise Stopwatch in JavaScript

:: Code ::

<html>
<head>
<title>stopwatch</title>
<script type="text/javascript">
var c=60;
var c2=0;
var t,t2;
function stopCount()
{
clearTimeout(t)
}
function stopCount2()
{
clearTimeout(t2)
}
function timedCount()
{
document.getElementById('txt').value=c
c=c-1
if(c==-1)
{
alert("time over")
stopcount()
}
t=setTimeout("timedCount()",1000)
}
function timedCount2()
{
document.getElementById('txt2').value=c2
c2=c2+1
if(c2==61)
{
alert("time over")
stopcount2()
}
t=setTimeout("timedCount2()",1000)
}
</script>
</head>
<body>
<center>
<form>
 <input type="text" id="txt">
 <input type="button" value="Start stopwatch (Anti Clock Wise)" onClick="timedCount()">
 <input type="button" value="Stop" onClick="stopCount()">
 <br/>
 <br/>
 <input type="text" id="txt2">
 <input type="button" value="Start stopwatch (Clock Wise)" onClick="timedCount2()">
 <input type="button" value="Stop" onClick="stopCount()">
</form>
<center>
</body>
</html>

:: Example ::




Posted by at No comments:
Labels: ,

Monday, 19 March 2018

unable to open the physical file mdf operating system error access is denied

Solution:

Steps are given bellow:

  • go to Control Panel ->
  • System and Security ->
  • Administrative Tools ->
  • Services ->
  • Double Click SQL Server (SQLEXPRESS) -> right click, Properties
  • Select Log On Tab
  • Select "Local System Account" (the default was some obtuse Windows System account)
  • -> OK
  • right click, Stop
  • right click, Start
Now you want to try attach your .mdf file.
Posted by at No comments:
Labels:

Friday, 4 August 2017

Delete HTML Table Row Using Javascript/JQuery Without RowIndex

Using JavaScript:

<!DOCTYPE html>
<html>
<head>
<style>
table, td {
    border: 1px solid black;
}
</style>
</head>
<body>

<p>Click the button to delete the any row from the table.</p>

<table id="table1">
  <tr id="myRow1">
    <td>First cell</td>
    <td>Second cell</td>
    <td>Third cell</td>
    <td><input type="button" onclick="deleteRow('myRow1')" value="Delete"/></td>
  </tr>
  <tr id="myRow2">
    <td>First cell</td>
    <td>Second cell</td>
    <td>Third cell</td>
    <td><input type="button" onclick="deleteRow('myRow2')" value="Delete"/></td>
  </tr>
  <tr id="myRow3">
    <td>First cell</td>
    <td>Second cell</td>
    <td>Third cell</td>
    <td><input type="button" onclick="deleteRow('myRow3')" value="Delete"/></td>
  </tr>
</table><br>

<script>
function deleteRow(myRow) {
    var row = document.getElementById(myRow);
    var total_cell=document.getElementById('table1').rows[0].cells.length;

   for(i=0;i<total_cell;i++)
   {
    row.deleteCell(0);
    }
  
}

</script>

</body>
</html>


Using JQuery:


<!DOCTYPE html>
<html>
<head>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
<style>
table, td {
    border: 1px solid black;
}
</style>
</head>
<body>
<table id="table1">
  <tr id="myRow1">
    <td>First cell</td>
    <td>Second cell</td>
    <td>Third cell</td>
    <td><input type="button" onclick="deleteRow(this)" value="Delete"/></td>
  </tr>
  <tr id="myRow2">
    <td>First cell</td>
    <td>Second cell</td>
    <td>Third cell</td>
    <td><input type="button" onclick="deleteRow(this)" value="Delete"/></td>
  </tr>
  <tr id="myRow3">
    <td>First cell</td>
    <td>Second cell</td>
    <td>Third cell</td>
    <td><input type="button" onclick="deleteRow(this)" value="Delete"/></td>
  </tr>
</table><br>



<script>
function deleteRow(this_row) {
    $(this_row).closest("tr").html("");
  
}
</script>

</body>
</html>

Posted by at No comments:
Labels: ,

Thursday, 22 September 2016

How to bind Dropdown Test and Value Dynamically and Retrive also?


<!DOCTYPE html>
<html>
<head>
<script type="text/javascript" src="http://code.jquery.com/jquery-1.10.2.js"></script>
<script>
function DynamicBind()
{
var Ttext="India";//CountryName -> this is visible
var Tvalue="CId-1";//CountryId -> this is invisible for secure back hand code

$("#textandvalueSET").append($('<option></option>').val("").html("-Select-"));
$("#textandvalueSET").append($('<option></option>').val(Tvalue).html(Ttext));

}

function ShowDropTextValue()
{
var countrySelect = document.getElementById("textandvalueSET");
var selectedText = countrySelect.options[countrySelect.selectedIndex].text;
alert(" Selected Text: "+selectedText);

var vv=document.getElementById("textandvalueSET").value;
alert(" Selected Value= "+vv);

}
</script>
</head>
<body>

<br/>
<br/>
<input type="button" value="Dynamic" onclick="DynamicBind()"/>
<select id="textandvalueSET" onchange="ShowDropTextValue()">

</select>
</body>
</html>

Posted by at No comments:
Labels: ,

Wednesday, 22 June 2016

Show/Hide Image in Javascript with fileupload

<html>
<head>
<script>
  var loadFile = function(event) {
var img = document.getElementById('output');
    img.style.visibility = 'visible';
    var output = document.getElementById('output');
    output.src = URL.createObjectURL(event.target.files[0]);
  };
function resetimg()
{
var img = document.getElementById('output');
    img.style.visibility = 'hidden';

}
</script>
</head>
<body onload="resetimg()">
<form name="f1">
<input type="file" accept="image/*" onchange="loadFile(event)">

<img id="output" width="100px" height="150px"/>

<br/>
<input type="reset" value="Clear" onclick="resetimg()"/>
</form>
</body>
Posted by at No comments:
Labels:

Tuesday, 21 June 2016

Preview an Image when browse using Javascript

<html>
<head>
<script>
  var loadFile = function(event) {
    var output = document.getElementById('output');
    output.src = URL.createObjectURL(event.target.files[0]);
  };
</script>
</head>
<body>

<input type="file" accept="image/*" onchange="loadFile(event)">
<img id="output" width="100px" height="150px"/>
</body>
Posted by at No comments:
Labels:
Subscribe to: Posts (Atom)