Sandeep Tawaniya

List All The Column With Specific Data Types of Specific Table

2012-01-02T18:54:00.000+05:30

Since we upgraded to SQL Server 2005 from SQL Server 2000, we have used following script to find out columns with specific datatypes many times. It is very handy small script.

select c.name as ColumnName,
(select name from sys.types where user_type_id=c.user_type_id)as Type,
c.max_length as Size
from sys.columns c where object_id=
(select object_id from sys.objects where name='order' and type_desc='USER_TABLE')

How to send/receive SOAP request and response and return in dataset using C#

2011-12-12T18:32:00.000+05:30

public Dataset GetCountries (string _agentCode, string _password)
{
WebRequest webRequest = WebRequest.Create("http://www.flexiblecarhire.com/flexibleservice/fchxmlinterface.asmx");
HttpWebRequest httpRequest = (HttpWebRequest)webRequest;
httpRequest.Method = "POST";
httpRequest.ContentType = "text/xml; charset=utf-8";
httpRequest.Headers.Add("SOAPAction: http://fchhost.org/GetCountries");
Stream requestStream = httpRequest.GetRequestStream();
//Create Stream and Complete Request
StreamWriter streamWriter = new StreamWriter(requestStream, Encoding.ASCII);

StringBuilder soapRequest = new StringBuilder("");
soapRequest.Append("");
soapRequest.Append("" + _agentCode + "");
soapRequest.Append("" + _password + "");
soapRequest.Append("");

streamWriter.Write(soapRequest.ToString());
streamWriter.Close();
//Get the Response
HttpWebResponse wr = (HttpWebResponse)httpRequest.GetResponse();
StreamReader srd = new StreamReader(wr.GetResponseStream());

DataSet ds = new DataSet();
ds.ReadXml(wr.GetResponseStream());

return ds;
}

Database Backup by Stored Procedure

2010-05-07T16:47:00.001+05:30

---------------
--Backup all db
---------------
DECLARE @name VARCHAR(50)
DECLARE @path VARCHAR(256)
DECLARE @fileName VARCHAR(256)
DECLARE @fileDate VARCHAR(20)

SET @path = 'C:\backup\DB\' ---Give Your Path Here where you want to store this backup file
SELECT @fileDate = CONVERT(VARCHAR(20),GETDATE(),105) -- Add Date in File Name
DECLARE db_cursor CURSOR FOR
SELECT name
FROM master.dbo.sysdatabases
where name = 'Kool_Project_Test' ---Name of Database that you want to get Backup

OPEN db_cursor
FETCH NEXT FROM db_cursor INTO @name

WHILE @@FETCH_STATUS = 0
BEGIN
SET @fileName = @path + @name +'_'+ @fileDate + '.BAK'
BACKUP DATABASE @name TO DISK = @fileName WITH NOFORMAT, INIT

FETCH NEXT FROM db_cursor INTO @name
END

CLOSE db_cursor
DEALLOCATE db_cursor

Find Duplicate Rows in a Sql Table

2010-05-07T16:44:00.000+05:30

select SHORT_NAME, count(SHORT_NAME) as SN
from TBLKOOL_GENERAL
group by SHORT_NAME

String Formats For Decimal Values

2010-05-07T16:40:00.000+05:30

txtFabricProcessingCost.Text = String.Format("{0:F2}", totalProcessCost);

txtFabricProcessingCost.Text = totalProcessCost.ToString("#0.00");

txtFabricProcessingCost.Text = totalProcessCost.ToString("N2");
txtFabricProcessingCost.Text = totalProcessCost.ToString("N3");

double v = 17688.65849;
double v2 = 0.15;
int x = 21;
string str = String.Format("{0:F2}", v); // 17688.66

str = String.Format("{0:N5}", v); //17,688.65849

str = String.Format("{0:e}", v); //1.768866e+004

str = String.Format("{0:r}", v); //17688.65849

str = String.Format("{0:p}", v2); //15.00%

str = String.Format("{0:X}", x); //15

str = String.Format("{0:D12}", x); //000000000021

str = String.Format("{0:C}", 189.99); //$189.99

Sql Qurey to Select Multiple Tabels and Procedure

2010-05-07T16:34:00.000+05:30

select * from sys.tables Where name like 'tblKool%'
select * from sys.procedures Where name like 'spKool%' order by name
BEGIN
FOR r in (SELECT object_name FROM user_objects WHERE object_type = 'PROCEDURE' )
LOOP
EXECUTE IMMEDIATE 'DROP PROCEDURE 'r.object_name;
END LOOP
END

Query to get all column names from database table in SQL Server.

2009-10-24T19:29:00.000+05:30

SELECT COLUMN_NAME,Data_Type+'('+convert(varchar,character_maximum_length)+')'as DataType

FROM INFORMATION_SCHEMA.COLUMNS

WHERE TABLE_NAME = 'Your Table Name'

ORDER BY ORDINAL_POSITION

How can I get my menu to display over my Flash (.swf) movie?

2009-10-08T19:18:00.000+05:30

User Name & Password of Nod32

2009-09-14T12:04:00.000+05:30

S/N: Name: AV-2364945
S/N: jubqqrjsa2

Name: AV-2267079
Password : m7auys7jph

User: AV-2593035
Password: merjvieno1

Name: AV-2230918
Serial: 48rf4ieot2"

Username: En-2007224
Password: nx1qs5myj6

Name: FiENdisH_MB
S/N: Name: AV-2267079
Pas
try all... one will work!

Is Date function Using Javascript

2009-09-04T21:00:00.000+05:30

var dtCh= "/";
var minYear=1900;
var maxYear=2100;

function isInteger(s){
var i;
for (i = 0; i < c =" s.charAt(i);"> "9"))) return false;
}
// All characters are numbers.
return true;
}

function stripCharsInBag(s, bag){
var i;
var returnString = "";
// Search through string's characters one by one.
// If character is not in bag, append to returnString.
for (i = 0; i < c =" s.charAt(i);" 4 ="="" 100 ="="" 400 ="="" i =" 1;" i="="4" i="="6" i="="9" i="="11)" i="="2)" daysinmonth =" DaysArray(12)" pos1="dtStr.indexOf(dtCh)" pos2="dtStr.indexOf(dtCh,pos1+1)" strday="dtStr.substring(0,pos1)" strmonth="dtStr.substring(pos1+1,pos2)" stryear="dtStr.substring(pos2+1)" stryr="strYear">1) strDay=strDay.substring(1)
if (strMonth.charAt(0)=="0" && strMonth.length>1) strMonth=strMonth.substring(1)
for (var i = 1; i <= 3; i++) { if (strYr.charAt(0)=="0" && strYr.length>1) strYr=strYr.substring(1)
}
month=parseInt(strMonth)
day=parseInt(strDay)
year=parseInt(strYr)
if (pos1==-1 || pos2==-1){
alert("The date format should be : dd/mm/yyyy")
return false
}
if (strMonth.length<1>12){
alert("Please enter a valid month")
return false
}
if (strDay.length<1>31 || (month==2 && day>daysInFebruary(year)) || day > daysInMonth[month]){
alert("Please enter a valid day")
return false
}
if (strYear.length != 4 || year==0 || yearmaxYear){
alert("Please enter a valid 4 digit year between "+minYear+" and "+maxYear)
return false
}
if (dtStr.indexOf(dtCh,pos2+1)!=-1 || isInteger(stripCharsInBag(dtStr, dtCh))==false){
alert("Please enter a valid date")
return false
}
return true
}
function ValidateDate(Obj)
{
if(Obj.value.replace(/\s/g,"") != "")
{
if (isDate(Obj.value)==false)
{
Obj.focus()
Obj.value="";
return false
}
}
return true
}

Is Numeric function using Javascript

2009-09-04T20:57:00.000+05:30

function IsNumeric(txtvalue)
{
if(txtvalue.value != "")
{
if(isNaN(txtvalue.value))
{
alert("Please Enter Numeric Value")
txtvalue.focus();
txtvalue.value = "";
return false;
}
}
}

Is Alfa function using Javascript

2009-09-04T20:55:00.000+05:30

function IsAlpha(txtvalue)
{
var numaric = txtvalue.value ;
for(var j=0; j
{
var alphaa = numaric.charAt(j);
var hh = alphaa.charCodeAt(0);
if((hh > 64 && hh<91)> 96 && hh<123) || (hh == 32) || (hh==46))
{
}
else
{
txtvalue.focus();
txtvalue.value = "";
alert('Please Insert [a-z] only number are not allowed!');
return false;
}
}
return true;
}

Print Using Javascript

2009-09-04T19:49:00.001+05:30


function CallPrint()
{
var prtContent = document.getElementById('Print');
var WinPrint = window.open('','','top=0,width=800,height=700,left=120,scrollbars=yes,status=0');
WinPrint.document.write(prtContent.innerHTML);
WinPrint.document.close();
WinPrint.focus();
WinPrint.print();
WinPrint.close();
prtContent.innerHTML=strOldOne;
}

My Websites

2009-09-01T14:23:00.000+05:30

www.sufiyacollege.org
www.acaedutech.com
www.tanurajgolden.com
www.tagoreengineeringcollege.org
www.bharadwajitc.com
www.shreeshyamitc.com
www.niitcdausa.com
www.vinayakitc.com
www.kuldeepitc.com
www.girishitc.com
www.meenakshiitc.com
www.kesaritc.com
www.shreeagrasenitc.com
www.shreevishwakarmaitc.com
www.maharashiangiraitc.com
www.iiitcniwai.com
www.shivitc.com
www.mahatmagandhiitc.com
www.deepakitc.com
www.swastikitc.com

Top 35 Torrent Sites

2009-08-19T14:49:00.000+05:30

Very Useful Websites Details

2009-08-18T13:32:00.000+05:30

Free Mp3 Downloadable Sites
http://www.beemp3.com/
http://www.funmaza.com/indian_movie_songs.html
http://www.songs.pk/
http://www.desimp3s.com/
http://www.indiamp3.com/
http://www.indianmelody.com/
http://www.mp3babu.net/
http://www.funmaza.com/indian_oldies.html
http://www.raaga.com/channels/hindi/
http://www.masti4india.com/ (Find in Songs Section)
http://www.bollywoodsargam.com/

http://www.indianscreen.com/

Other Sites where you can try your search:

http://www.onesmartclick.com/desi/desi-masala.html http://www.indianchild.com/hindi_songs_indian%20songs.htm

Free Sharing ,Uploading and Downloading Sites

http://www.4shared.com/

http://skydrive.live.com/

http://www.esnips.com/

http://www.rapidshare.com/

http://rapidlibrary.com/

Free Game Download From Here

http://games.rapidshare.com/gamesnew/

http://www.zapak.com/

Free Mobile Software, Games, Theams and Applications Download

http://www.zedge.net/

http://www.getjar.com/

http://www.funmaza.com/mobile_software.html

http://www.ringtones2world.com/

http://www.mobiletoones.com/

http://www.mobile9.com/

Free Vedios Downloadable Sites

http://www.youtube.com/

http://www.metacafe.com/

http://video.google.com/

Free Software Downloadable Sites

http://www.filehippo.com/

http://www.brothersoft.com/

http://download.cnet.com/

http://www.freewarefiles.com/

http://www.completelyfreesoftware.com/
Free Website Layouts
http://www.freelayouts.com/

Torrent Trackers List

2009-08-18T12:06:00.000+05:30

http://tracker.thepiratebay.org/announce

udp://tracker.thepiratebay.org:80/announce

http://tracker.thepiratebay.org/announce

http://tracker2.istole.it:60500/announce

http://inferno.demonoid.com:3400/announce

http://vip.tracker.thepiratebay.org/announce

http://track.sextorrent.to:2710/announce

http://tracker.deluxebits.to:3552/announce

http://denis.stalker.h3q.com:6969/announce

http://tracker.torrentbox.com:2710/announce

http://tracker.hexagon.cc:2710/announce

http://tracker.torrent.to:2710/announce

http://axxo.sladinki007.net:6500/announce

http://220.162.244.175:53880/announce

http://tpb.tracker.prq.to/announce

http://open.tracker.thepiratebay.org/announce

http://eztv.sladinki007.net:60500/announce

http://tv.tracker.prq.to/announce

http://218.145.160.136:8080/announce

http://tracker.prq.to/announce

http://tracker.torrenty.org:6969/announce