Apps Media

SQL Rename Column or Tables Use of SP RENAME --Rename a Column Name replacing Old_Name EXEC SP_RENAME TABLE_NAME.COLUMN_NAME,COLUMN_NAME,COLUMN OR SP_RENAME TABLE_NAME.COLUMN_NAME,COLUMN_NAME,COLUMN ALTER TABLE Employee ALTER COLUMN download  file  now

SQL SERVER Delaying Sql Execution Use of WAITFOR Cluse --Example:-1 --WHILE LOOP --USE WAITFOR FOR DELAYING THE EXECUTION FOR SPECIFIED TIME GO DECLARE @T INT SET @T=1 WAITFOR DELAY 00:00:10 WHILE @T<=10 BEGIN PRINT MANOJ_KUMAR SET @T = @T+1 END GO --Example:-2 GO WAITFOR DELAY 00:00:02 SELECT THIS IS DB BLOG GO Descriptions:- It block/slow down the execution Process of any sql statement(Procedure/Commands).The delay specified period of time that must pass, up to a maximum of 24 hours, before execution of a batch, stored procedure, or transaction proceeds. While executing the WAITFOR statement, the transaction is running and no other requests can run under the same transaction. The actual time delay may vary from the time to time specified and depends on the activity level of the server. The time counter starts when the thread associated with the WAITFOR statement is scheduled. If the server is busy, the thread may not be immediately scheduled; therefore, the time delay may...

Starting lighttpd network c 358 cant bind to port 80 Address already in use Recently I had the error message appearing when trying to launch my PB on my Ubuntu machine: Starting lighttpd: (network.c.358) cant bind to port:  80 Address already in use  Turns out there are quite a few old forum threads on this topic where the issue comes down to one of 2 things: Another webserver application is running (like apache) To solve this issue check what is running on port 80 by: sudo fuser -v 80/tcp And then kill or remove this application. IPv6 is causing some issues in the lighttpd.conf file Open lighttpd.conf file in any text editor and comment the line include_shell "/usr/share/lighttpd/use-ipv6.pl" with a #, so: #include_shell "/usr/share/lighttpd/use-ipv6.pl" Although in case of the PirateBox script package, this comes ready and set. My personal issue was that somehow I had apache2 webserver installed on my system. I do not remember installing it, but now it has been re...

SpyPhone Do not put smart phone near computer hackers use it to spy no more privacy Its a pattern that no doubt repeats itself daily in hundreds of millions of offices around the world: People sit down, turn on their computers, set their mobile phones on their desks and begin to work.  What if a hacker could use that phone to track what the person was typing on the keyboard just inches away? SpyPhone picks up keystrokes, vibrations & more... Read the whole story: http://www.machineslikeus.com/news/iphone-turns-spiphone Posted via email from colby pre-posterous download  file  now

some basic commands that we use in linux Pranaam to all bhai ji _/_ in this post we will go through some basic commands which we use commonly in linux. but first of all let me clear term full path and relative path. full path is the path of something with respect to  /   for example if we are in /root directory and we have file i.txt , then full path for the file will be  /root/i.txt  for file , which exist in  var directory, having name log.txt , full path will be /var/log.txt relative path is path respect to current working directory in which we are working suppose, we are in directory /home/ica and there is file user.txt in directory document the relative path for file user.txt will be document/user.txt and full path will be /home/ica/document/user.txt   we will discuss about following commands in this tutorial pwd - to know present working directory cd - change directory cp - file/directory copy purpose rm - removing file/directory mkdir - create new d...

SOLVED Cant use sudo etc sudoers RHEL 5 nopasswd When using no password you may be thrown a error ex. >>> sudoers file: syntax error, line xx <<< sudo: parse error in /etc/sudoers near line xx Solution : if you are giving a single command then just add a comma user ALL=command , NOPASSWD: ALL instead of ( This will be throwing an error) user ALL=command NOPASSWD: ALL download file now