Friday, 2024-03-29
Hamster Online
Site menu
Section categories
Umum [15]
Komputer [36]
Kreatif [3]
Space Kosong
Adsense Indonesia
&
Bersepeda Yuk....
Main » Files » Ilmu » Komputer

Entries in category: 36
Shown entries: 31-36
Pages: « 1 2 3 4

Sort by: Name · Rating · Comments · Downloads · Views

Introduction

The Northwind and Pubs sample databases are staples of other sample code on this and other development websites. They are used in countless tutorials and walkthroughs published by Microsoft and others. Being a SQL/SQL Server newbie myself, I figured there may be others in my boat who might want both databases in an easily-accessible spot, and an easier, less error-prone way of installing them into SQL Server 2008 Express Edition than, say, running SQL query scripts.

There have been requests for an update to my SQL Server 2005 article for SQL Server 2008; so, by popular demand, here is the update! This article is based on an installation of Microsoft SQL Server 2008 Express Edition with Tools, Service Pack 1, on a machine with Microsoft Windows Vista Business, Service Pack 1, installed.

Komputer | Views: 1871 | Downloads: 0 | Added by: hamster | Date: 2011-02-22

So yeah, you could use the Microsoft SQL Server Management Studio UI to rename your table or column. But sometimes you need to do the rename in T-SQL. Here’s how.

How to rename a table:

EXEC sp_rename 'OldTableName', 'NewTableName'

Rename DataBase
EXEC sp_renamedb 'oldName', 'newName'


How to rename a column:

EXEC sp_rename
@objname = 'TableName.OldColumnName',
@newname = 'NewColumnName',
@objtype = 'COLUMN'

Komputer | Views: 1230 | Downloads: 0 | Added by: hamster | Date: 2011-02-05

Masukkan CD master SQL Server 2000, tunggu beberapa saat hingga muncul layar berikut
Komputer | Views: 865 | Downloads: 0 | Added by: hamster | Date: 2010-12-23

Kali ini kita akan dubbing video dengan menggunakan widows movie maker. caranya
Komputer | Views: 1783 | Downloads: 0 | Added by: hamster | Date: 2010-12-16

Punya Blog dan ingin menghasilkan rupiah dari blog tersebut ? Caranya gampang tinggal ikutan PPC.Apa itu PPC ?? PPC merupakan singkatan dari Pay Per Click yang artinya Dibayar Per Klik
Komputer | Views: 836 | Downloads: 0 | Added by: hamster | Date: 2010-12-11

Buat teman-teman yang lupa password deep freeze bisa download aplikasi di bawah. Semoga bisa membantu. Deep freeze password remover di bawah dapat menjebol Deep freeze 6.61 dan 6.62
Komputer | Views: 2628 | Downloads: 0 | Added by: hamster | Date: 2010-12-10


Statistics

widgeo.net

Total online: 1
Guests: 1
Users: 0
Berita Terkini

Link Friend
Globe

ip address
Copyright MyCorp © 2024  Create a free website with uCoz