Pabitra@Microsoft.Research: July 2017

Friday 28 July 2017

sql query to get table definition

sp_help 'tableName'
example : sp_help 'Category'

OR

select Table i.e.
Category
and press Alt+F1

OR

SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Category'

OR Customize query

SELECT COLUMN_NAME as 'Column', DATA_TYPE as 'Data Type', CHARACTER_MAXIMUM_LENGTH as 'Max Length' ,IS_NULLABLE as 'IS Null Status'
FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Category'

What is test or testing ?

In general testing is a process to find out how well something works. In computer software its mean that whether the object is same as the analysis is done before developing the software or the list of functionality is working properly and giving the proper out put or not.

Tuesday 25 July 2017

c# :string reverse

Using pure c#

string StrInput ="PABITRA";
string StrReverse = "";
int Len = StrInput.Length - 1;
for (int i = Len; i>=0; i--)
StrReverse = StrReverse + StrInput[i];
//Console.Write(StrReverse);
//Console.ReadLine();

Response.Write(StrReverse);

OR

string StrInput ="PABITRA";
string StrReverse = "";
int Len = StrInput.Length - 1;
while (Len >= 0)
{
StrReverse = StrReverse + StrInput[Len]; Len--;
}
//Console.Write(StrReverse);
//Console.ReadLine();

Response.Write(StrReverse);

Using IEnumerable
IEnumerable<char> c = "pabitra".Reverse();
string rev = string.Empty;
foreach (var v in c)
{
if (rev == string.Empty)
rev = v + "\n";
else
rev = rev + v + "\n";

}
Console.Write(rev);
Console.ReadLine();

OR

Using Linq
string reverse = string.Join(" ", "pabitra".Split(' ').Select(x => new string(x.Reverse().ToArray())));
Console.Write(reverse);
Console.ReadLine();

sql: RIGHT and LEFT

sql query
select RIGHT(value,noofCharater);
select LEFT(value,noofCharater);

select RIGHT('pabitra',2)-- result ra
select LEFT('pabitra',2)--result pa

RIGHT: It extract right value from given no.
RIGHT: It extract left value from given no.

Friday 21 July 2017

sql : query for total no of column in a table

SELECT count(*)
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'tblEmployee'

or

SELECT COUNT(COLUMN_NAME)
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_CATALOG = 'master' AND TABLE_SCHEMA = 'dbo'
AND TABLE_NAME = 'tblEmployee'

Tuesday 18 July 2017

Disabling JavaScript in Mozilla Firefox

use
about:config

Friday 14 July 2017

prevent browser back button in any browser

<script type = "text/javascript" >
function preventBackButton() {
window.history.forward();
}
setTimeout("preventBackButton()", 0);
window.onunload = function () { null };
</script>

CurrentPage
----------------------

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="CurrentPage.aspx.cs" Inherits="CurrentPage" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
<script type = "text/javascript" >
function preventBackButton() {
window.history.forward();
}
setTimeout("preventBackButton()", 0);
window.onunload = function () { null };
</script>
</head>

<body>
<form id="form1" runat="server">
<div>
<a href="NewPage.aspx">New Page</a>

</div>
</form>
</body>
</html>

-----------------

NewPage

---------------------

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="NewPage.aspx.cs" Inherits="NewPage" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

function preventBackButton()

{

window.history.forward();

}

setTimeout("preventBackButton()", 0);

window.onunload = function () { null };

</script>

</head>

<body>

<div>

<a href="CurrentPage.aspx">CurrentPage</a>

</div>

</form>

</body>

</html>

Pabitra@Microsoft.Research

Translate