Copying records from database into another -- SQL

I had this requirement today where I had to copy from a table in one database into a similar table in another database.

the code I have used in

[code]
insert into database1.dbo.table1 select * from database2.dbo.table1 where xxxxx
[/code]

where xxxx is the criteria that you need to add.

Precautions you have to tak before you do this.

Backup the database into which you are copying the record so that you can restore if something goes wrong.
Copy contents when there are no other transactions being entered into the database1

Amazing Free Website Template, Table less Website

Free table less or div template of Website Brewers... Cool website layouts with psd files, ie6 and firefox compatible. Ready to used to CMS template such as Wordpress or Joomla. Other templates includes Flash Slideshow and FLA File. You can also used on static pages... CSS Style Sheet have description and comments. The images are optimize by 80%.

read more |

Water Text Photoshop Tutorial

Learn how to create a text with "water" effects.

read more |

20+ Ways to Make Money Creating Online Cartoons

Various methods of using animation to make money, a few I am sure you expect and perhaps a couple you haven’t yet considered.

read more |

Learn, discuss and explore the realm of Graphic Design

Useful resource for designers. Interesting articles.

read more |

Mastering Visual C# .NET

Mastering Visual C# .NET is the best resource for getting everything you can out of the new C# language and the .NET Framework. You'll master C# language essentials, quickly taking advantage of the many improvements it offers over C++ and see tons of examples that show you all the ways that .NET can make your programming more efficient !I have already downloaded it.

read more |

XML in 10 points

If you are new to XML, it may be hard to know where to begin. This summary in 10 points attempts to capture enough of the basic concepts to enable a beginner to see the forest through the trees.

read more |

Open Book Tutorial

In ten simple steps, this tutorial teaches you how to design a simple but an effect open book design that can be used either for your flash autobiography or as a splash page for your website. This tutorial can even be accomplished by beginners so go ahead and give it a try!

read more |

Flower Photoshop Brushes

Free for download at gfxfever.com

read more |

Filemail - Email Large Files

Filemail is a nice online service,which allow you to send 2GB email attachments

read more |

7 Incredibly Useful Tools for Evaluating a Web Design

If you are interested in analyzing and optimizing your page layout - here are some extremely useful tools that you can use to help.

read more |

15 Watercolour Photoshop Brushes

A great collection of 15 watercolor photoshop brushes

read more |

Tutorial Photoshop: Reflection

A new Photoshop tutorial explaining you how to create this reflection effect on a text.

read more

List of SQL Server database users and permissions

Today I was doing some research as to how to list the database users and the permissions they have and came across this article which is very useful.

http://www.mssqltips.com/tip.asp?tip=1071

Test you site in different browsers...

If you are interested to test your website in different browsers then Browsershots is very helpful for you. Browsershots shows how your website looks in different browsers. It is very easy to use. Just go to Browsershots site and then submit

read more | digg story

Introduction to C++ Programming and Graphics: Download ebook

Introduction to C++ Programming and Graphics offers a venue for rapidly learning the language by concisely revealing its grammar, syntax and main features, and by explaining the key ideas behind object oriented programming (OOP), with emphasis on scientific computing. The book reviews elemental concepts of computers and computing..

read more

Photoshop Videos Search Results at macromedia.com

Search results for Photoshop videos. Lots of good Photoshop information, tips, tricks and techniques.

read more

Adobe Photoshop Tutorials - Best Of

An overview of professional step-by-step tutorials which can enrich your design skills and improve the quality of your works.

read more

Excel to Word mailmerge problem

Today there was this small thing that took my time. A date field in excel was formatted correctly but when the field was used in the mailmerge with Word. The format in the excel was not being reflected in word.

So I used the following steps to correct this in Word.

Step 1. Right click on the field name
Step 2. Click on the ‘Toggle Field Codes’ option For eg., { MERGEFIELD “AFinish” }
Step 3. Edit the field to include \@ “dd-MM-yyyy” e.g. { MERGEFIELD “AFinish” \@ “dd-MM-yyyy” }
Step 4. Right click and click update field.


You can see the date format as 17-08-2008

Viewing DTS scheduled jobs

I wanted to view the scheduled DTS jobs. So obvious way I thought was to do view it where I created. But for some reason, the schedule has been reset. So there is no way we can view the scheduled jobs of DTS here.

If you want to view these jobs, you have to access the SQL SERver Agent as these jobs are run by SQL SERVER Agent. So follow these steps to ciew your scheduled jobs on SQL server.

Go to SQL SERVER Enterprise Manager -- Management folder
Then click on SQL SERVER AGENT -- Jobs

Here you can see the job name status etc.