devxlogo

February 2, 2001

Create a Linked Server in SQL Server

You can establish a link to the remote SQL Server using this code: Sp_addlinkedserverSyntax :SP_addlinkedserver[@Server]=’server'[,[Srvproduct=]’product_name'[,[@provider=]’provider_name’][,[@datascr=]’data_source’][,[location=]’location'[,[@provstr=]’Provider_string'[,[@catalog=]’catalog’]server: Name of the linked server to createproduct_name: Product name of te OLE DB data sourceProvider_name:

Why Static Methods Can Only Make Calls to Static Methods

Write the following code, compile it, then try to run it: class TstApppublic static void main (String args[])Next_Level(args[0]);}public void Next_Level(String Incoming_String)System.out.println(Incoming_String);}} It is very simple code but it will not

Retrieving the Date From lastModified()Method

The lastModified() method in java.io.File returns a long datatype. Thislong datatype represents the date and time when the file was last modified.The value does not carry any usage unless it

Create a Shortcut Key For a TextBox

Associate a label that describes what the text box is meant for.For example, a label with the caption ‘Name’ would be a good pair for a text box wherein you

Add Multithreading to Your VB.NET Applications

evelopers have been requesting that Microsoft add more threading functionality to VB for some time?it will finally happen with VB.NET. VB6 does have support for building multithreaded EXEs, DLLs, and

Understanding and Calculating Dates

QL Server provides many sophisticated functions to calculate dates. But knowing how to use them can often be a challenge. Suppose you want to calculate when a package is due

Cloning Data Accurately and Randomly

ecently I encountered a couple of Oracle-tuning projects that required me to evaluate the performance of PL/SQL and SQL code. I had to generate a substantial amount of data from