0
What is the difference between triggers and cursor in sql server?
Wiki User
∙ 10y ago
In SQL Server, a cursor is the actual set of records retrieved by a query. Once declared as a cursor, the set of records can then be manipulated one by one. A trigger is a set of statements that is set to execute only when a certain action occurs, for example, whenever the last name on a table is updated.
Wiki User
∙ 10y ago
Add your answer:
Earn +20 pts
What is difference between VBR and CBR?
Constant bit rate (CBR) encoding persists the set data rate to your setting over the whole video clip. Use CBR only if your clip contains a similar motion level across the entire duration. CBR is most commonly used for streaming video content using the Flash Media Server (rtmp) Variable bit rate (VBR) encoding adjusts the data rate down and to the upper limit you set, based on the data required by the compressor. VBR takes longer to encode but produces the most favorable results. VBR is most commonly used for http delivery if video content (http progressive)
How does a Trojan Horse virus work?
A "trojan horse" is not a virus; it's a type of malware that may be spread like a virus.It hides within other programs, or pretends to be a trusted program, but it is really malicious software. Like the Trojan Horse in the Iliad, it secretly does damage once you mistakenly let it into your computer system.A Trojan Horse is a program that gives a hacker or cracker power over your computer. It usually provides the attacker with unauthorized remote access to a compromised computer, infects files and damages the system, drops other dangerous parasites or steals user sensitive information.Trojans can be very small in size, as little as 8 kb, and can be hidden inside other executables.The Trojan is really two programs in one. The first part is called the "client" and is used by the hacker to control the victim's computer. The client is not installed on your computer but on the hacker's. The second part is the "server" and it is installed on your computer. Once executed this "server program" will provide information to the client program upon request. This server program once installed hides itself on your computer and will run automatically every time you start the computer.First the Trojan must be delivered to your computer. This can be accomplished in many ways, through an e-mail worm, or hidden in another executable program like an mp3 song or a free game or picture. Running the program installs the Trojan on your computer.How Trojans workTrojans usually consist of two parts, a Client and a Server. The server is run on the victim's machine and listens for connections from a Client used by the attacker. When the server is run on a machine it will listen on a specific port or multiple ports for connections from a Client. In order for an attacker to connect to the server they must have the IP Address of the computer where the server is being run. Some trojans have the IP Address of the computer they are running on sent to the attacker via email or another form of communication.Once a connection is made to the server, the client can then send commands to the server; the server will then execute these commands on the victim's machine.Today, with NAT infrastructure being common, most computers cannot be reached by their external ip address. Therefore many trojans now connect to the computer of the attacker, which has been set up to take the connections, instead of the attacker connecting to his or her victim. This is called a 'reverse-connect' trojan. Many trojans nowadays also bypass many personal firewalls installed on the victim's computer (eg. Poison-Ivy).One method of virus/trojan control:1. Run Deckard's System Scanner (DSS)2. Run the vundo and combo fix3. Run Malwarebytes Anti-Malware4. Run the anti spyware removal programs spybot5 Run Superantispyware6. Run a complete scan with free curing utility Dr.Web CureIt!
How do you compile servlet in java using tomcat?
Tomcat is a server. It is used to deploy and run Servlets and not compile them. A Servlet is a java file and has to be compiled just like any other Java Class.
What are the advantages and disadvantages of servlet?
Servlets are an integral part of any J2EE Web application. The key benefits of using Servlets in our web applications are: a. They are faster than CGI scripts because each CGI script produces an entirely new process that takes a lot of time to execute, whereas a servlet creates only a new thread. b. Servlet API is standard and available easily on the internet (like JSPs) c. Servlets have the advantages like ease of development & platform independence (like Java) d. They can access all the J2SE and J2EE APIs e. Can take the full advantage & capabilities of the Java programming langauge As you can see, there are numerous advantages of using the Servlet & JSP technologies. This is exactly why numerous organizations use them as a staple part of their J2EE application development work. The Disadvantage would be that Servlets are a little difficult to learn and use.
What is the difference between a preferred DNS server and an altenate DNS server?
What is the difference between a preferred DNS server and an altenate DNS server?Read more: http://wiki.answers.com/What_is_the_difference_between_a_preferred_DNS_server_and_an_altenate_DNS_server#ixzz2LRd3ICed
What is the difference between server and domains?
The difference between the server and domains is fairly simple. The server is the system on which the entire functions rest, and the domains are pages within that system. Imagine the server as a neighborhood and domains as houses.
What is the difference between client and member server?
client is share to data storage in server
What is a server's physical case?
what is the difference between a server physical case and a client case
What is difference between a firewall and ISA server?
hi
What is the difference between service provider and network provider?
what is the difference between a file server and a internet service provider
What is the difference between mysap and sap?
SAP - Client (installed)/Server mySAP web browser (Client)/Server
What is the difference between client server and mobile agent based approach?
noemally client server is used by client o server and mobile for calling
Difference between sql server 2003 sql server 2005?
There is no such thing as SQL Server 2003. Microft released SQL Server 2005 as the next version of SQL Server 2000.
What is the difference between LDAP and X500 in ADS windows server 2000?
ads
What is the difference between Client and member?
client is share to data storage in server
What is the difference between LPAR and VIOS?
vios server is virtual machine and lpar is
