![](https://img-blog.csdnimg.cn/20201014180756923.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
SQL
smile_juan
这个作者很懒,什么都没留下…
展开
-
Chcek MySQL version in three ways on Win OS
1. Without login into mysql, type it into your cmd mysql -V mysql Ver 14.14 Distrib 5.1.45, for Win32 (ia32) 2. login mysql mysql> status -------------- mysql Ver 14.14 Distrib 5.1.45,原创 2012-11-27 22:47:30 · 601 阅读 · 0 评论 -
Export table structure on Sql server 2008
I just tried the first one, it works 1. Create a script of the table's definition. From Management Studio in Object Explorer, right-click the table and point to Script Table as and then selec转载 2012-12-01 04:46:32 · 865 阅读 · 0 评论 -
SQL Server 2008 alter table column type
I ran into the issue twice when I tried to change table column type. I directly went to table design page and tried to change column type as I do many times on MySQL. But it didn't work on SQL Server原创 2012-12-05 01:48:09 · 3790 阅读 · 0 评论 -
Specify datasource on tomcat(app server)
I learned that from my coworker Michael. He's really helpful. I learned a lot from him in half an hour. In our company, we have several portlets in Liferay portal which we can add them into our pages原创 2012-12-05 06:14:06 · 535 阅读 · 0 评论 -
Export table data sql scrpit on sql server 2008
Since this is my first time working on sql server, I didn't know how to export data. Previously, I was silly to write the insert sql manually. It's time-consuming.This time, I have to insert a lot of转载 2012-12-12 00:38:09 · 2455 阅读 · 0 评论