sql server

Sometimes you want to transfer or backup your database in SQL Server. When the database is attached you cannot copy/move it to any location. All you have to do is detach it first using SQL Server Management Tools.

Another reason why I write this tutorial is to teach you so that when we finish the Library System project you will be able to switch from my own database to your own database just in case you want to differentiate each of the table.

To attach a database

1. Open SQL Server Management Tools.

2. Right click Database and click Attach.

In this tutorial you will learn how to create a Database in SQL Server 2005 Express Edition. The name of the database that we are going to create is “LibSys” which stands for Library System.

Note that I am using SQL Server Management Studio that is bundled with SQL Server 2008 R2. Regardless of version that you are using the environment still looks the same.

Please follow the steps below to create a database.

In this tutorial I will teach you on how to create a Windows Application using Visual Basic .NET 2008. For the sake of this tutorial I will be using Library System as the system model.

I came up with this idea in the hope to help beginner who wish to learn Visual Basic .NET the EASY WAY. I know there are a lot of tutorials out there but they focus on different things. Unlike this tutorial I will create an actual application which will guide you up to the end of this article.

This a notes of vb 6.0 code and sql code and how to use and also the different kinds of connection string...

Always forgot to remember one query. So for them only Below query you can any table, stored procedure or views who ever have that expression as a column or object name. SELECT * FROM SYSOBJECTS WHERE ID IN (SELECT ID FROM SYSCOMMENTS WHERE TEXT LIKE ‘%PRODUC%’) The query produced all the object names. where ever it finds expression like ‘PRODUC‘