Sometime you want to modify exists table in database. You don't want to delete and recreate. So in SQL Server we can use Alter Table to modify table. We can delete columns, add new columns, modify columns name, modify datatype.
Please follow below scripts:
1. Add Column
Syntax: Alter Table TableName ADD NewField DataType
EX: Alter Table tbl_Staff Add DOB DateTime
How to know Last Backup Date in SQL Server
My friend asked me about one problem in SQL Server. He
cannot find the last backup date in SQL Server. He asked me help him find
scripts to query last backup date. I try a few days for find this scripts. Finally
I found one scripts that can query this data.
How to Remove Pagefile.sys on Hard Disk
I have a problem with my laptop, in drive C has grew up
without reason. I tried to find all folders but didn’t see big file or folder.
I have wondered why my hard drive is growing up like this. Then I found the
cause of this issued. This problem is happened by has pagefile.sys in drive C.
What is pagefile.sys? Pagefile.sys is the “Virtual Memory” or “Swap Space” that
it come from RAM when not currently begin used. I never delete this file, now
its size is 8GB. To solves this issued we can reduce its size or don’t allow to
have this file in hard disk.
How to Find Empty Table in SQL Server
Today I have a good tip to share about find empty table in
SQL Server. Sometime you created table in database, but you didn’t insert any
rows. Once day you want to optimize or want to delete some table, you should
run this query to know which empty table. It is necessary to clarifies the
empty table for prevent lost your data before you delete it.
5 Ways to Improve Computer performance
This topic will guide you to improve your computer speed. After
you read this tips you are able to fix when your computer going to slow. Because when
we use computer everyday it will be grow of unnecessary file and have a lot case
to make your computer slowly. You didn't know there are a lot of service is
running when we use computer for other work. Some services also run while
computer no need. So we need to know how to stop those services. But first we
must know why and what the
5 Ways to Improve Execution Query in SQL Server
SQL Server is the popular products to store data in
database. When the database growth up to large we need to care about two
things. The first we must care about security. We could make schedule to backup
and set policy to the user. And the second we should know when the data is
large we will has problem with queries data from database. Why it make queries
data slowly? Because it has a lot record, need take time to find data that we
want. To increase performance of query in database is not
How to resolve Selected Partition Error 0x8007045d
Many users met the selected partition error 0x8007045d when
they used SATA hard drive. This problem is missing boot file in the system. If we
met this problem please try this solution.
Try open window in safe mode and copy necessary data. If we can’t
open computer in safe mode please try with third party application to open
window.
How to Make High Security in MS SQL Server
Security is very important think that we need to know and
careful on your data. As you know data in each organization is kept secret. They
don’t allow someone know except theirs staff. Another thing they must prevents the
data lost. If your data are stolen it effect to your organization because they will
know your secret data. How to prevent above problem? Here are some tips to make
high security to prevent your data from hacker or other person that want to steal
your data. To make high security on MS SQL Server there are 2 things. One is
prevent someone steal and prevent it lost.
MS SQL Server with Khmer Unicode
MS SQL Server is a product of Microsoft that we use it for
store data, information and we can easy find that data when you need. MS SQL
Server is the database application for manage data or any information of
organization. If we compare with MS Access we can say MS SQL Server is better
because MS SQL Server have more features, tools, function than MS Access in
manage data. Today I have one topic to
share you about how to make MS SQL Server support with Khmer Unicode.
Make MySQL support Khmer Unicode
Hi everyone today I write one topic about MySQL why it doesn’t
support Khmer Unicode. It depends on
version of MySQL too. The new version of MySQL is support with Khmer Unicode just
change Collation to UFT-8 like this picture when you create.
Resolve problem install .Net Framework (HRESULT 0xc8000222)
When your install Visual Studio it will install .Net
Framework. In case it has the problem (HRESULT 0xc8000222). How can solve
it? Please see the solution below:
- Click Start => Run => Type cmd => Press Enter command prompt will appear
- Then type net stop WuAuServ in Command prompt => Click Enter
- Click Start => Run => Type %windir% => Press Enter it will open Window explorer
- Find and rename folder SoftwareDistribution to new name(Ex: SoftDold)
- Click Start => Run => Type cmd => Press Enter command prompt will appear
- Then type net start WuAuServ
Then please install again.
Wish this topic can helps you and if have anything issue please comment.
How to Create Yahoo Account
Yahoo
is the popular company that provides email services to all people in the world.
So if we want to use theirs service, we need to register. After you register we
can send email to our friend, relative, or our customer. Yahoo have many
service like Yahoo Messenger for make chat to our friend. In using the Yahoo
mail is easy use and understands about tools and feature. The best thing for
Yahoo mail is high security. It mean you don’t worry to lost our email and
don’t care about our email is stolen. So let go to follow below step to create
Yahoo mail.
Understanding about Features of WordPress
WordPress is more powerful to build and update website. Functionality
of WordPress is very easy to install and use (More detail: http://kh-code.blogspot.com/2014/12/easy-to-install-wordpress.html).
There are many useful tools to design and update your contents. Why many people
like to use WordPress for build theirs website? The easy answer because
WordPress is easy to install and update your content events you don’t know the
code or any programming language. But before you create website using WordPress
you need to know about tools and features.
How to Share File in Google Drive
Google Drive is a product of Google. It is important to
store your data that you don’t worry to lost data and you can access it
everywhere that have internet connect. In the previous topic I wrote one topic
about How to create and Use Google Drive but it has other option that I
need to show in this topic. In Google Drive have one option that you can share
your data file like document, PDF, image to your friend without using flash to
copy or attach by email.
Easy to Install WordPress
Nowadays, there is a lot of website in the world that show
information of theirs company or personal information of people. The websites
are created for show information, services, and products of company and the
people can know about everything of company by go to visit the website. How to
easy to create website? There are many ways to create website, but you should
choose one way that easy and fast to create it. Now I guide you to use WordPress
to create website that it easy and fast. What is WordPress? WordPress is the
CMS (Content Management System) like Joomla, Drupal and we use it to create
website
How to Create and Use Google Drive
What is Google Drive? Google Drive is one of product’s
Google. It is the place that provide by Google to store documents, PDF and
image file that we can access from anywhere via internet. There are two way to
access Google Drive. We can access by web browser and we can install
application in computer or mobile also. After we install Google Drive
application in computer and mobile we can easy to create, upload, download,
delete, prints your documents that have in Google Drive. Please follow below
step to create account in Google Drive.
Easy Way to Create Gmail Account
Gmail is the one product of Google Company. People in the world has been created Gmail account to contacts to other people for communication, businesses, chat or created to use another products of Google that it requite to have Gmail account. To create Gmail account is very easy and quick. After you created Gmail account you can access to other products of Google such as: Google+, YouTube, Chat etc.
So Gmail account is very important for you to use. Here is
the easy way to create Gmail account. Please follow below step:
Use Select Case In SQL Server
In Sql Server you can use Select Case for select data from table
bye use Select Case. It is importance to use because you can used it
for select data that have complicate condition.
Please see example as below:
SELECT title, price,
Budget = CASE price
WHEN price > 20.00 THEN 'Expensive'
WHEN price BETWEEN 10.00 AND 19.99 THEN 'Moderate'
WHEN price <>
ELSE 'Unknown'
END,
FROM titles
In this example, price is a condition that we want to show Message by quality of price
bye use Select Case. It is importance to use because you can used it
for select data that have complicate condition.
Please see example as below:
SELECT title, price,
Budget = CASE price
WHEN price > 20.00 THEN 'Expensive'
WHEN price BETWEEN 10.00 AND 19.99 THEN 'Moderate'
WHEN price <>
ELSE 'Unknown'
END,
FROM titles
In this example, price is a condition that we want to show Message by quality of price
Subscribe to:
Posts (Atom)