Browse by Tags

CTAS and Select Into

In both Oracle and MySQL, you can do: create table T1 as select * from T1 This CREATE TABLE AS statement basically clones table T1 with its structure and data in T2. This can be pretty handy at times. The equivalent of that in Sql Server is SELECT INTO. For example, you can do: select * into T2 from...

Posted to Haidong Ji (Weblog) by hji on 01-22-2007
Delete permission implementation differences

I mentioned when grant statements take into effect in Sql Server, MySql, and Oracle here. I found out recently that there are some implementation differences when you grant only delete permission on a table to a user. MySql and Sql Server do this the same way, whereas Oracle is different. Suppose you...

Posted to Haidong Ji (Weblog) by hji on 01-11-2007
When does grant statement take into effect

In both Sql Server and Oracle, permission changes to a user take into effect right away, even when said user is connected at the time you made the change. In MySql, it is a little different, depending on how the permissions are given. If you use the GRANT statement, then it takes into effect right away...

Posted to Haidong Ji (Weblog) by hji on 01-11-2007
desc is sp_columns in Sql Server

In Oracle and MySql, to get the column name and data type of a table, you can use: desc MyTable or describe MyTable The equivalent of desc in Sql Server is sp_columns. Therefore, run the command below will get similar results: sp_columns MyTable

Posted to Haidong Ji (Weblog) by hji on 12-19-2006
Executing sql scripts using command line tools

Sql Server 2005 has a command line tool named sqlcmd. MySQL has a command line tool named mysql. Oracle has a command line tool called sqlplus. They can all be used for interactive query processing and batch scripts processing. They do similar things, albeit in different ways. They are functionally equivalent...

Posted to Haidong Ji (Weblog) by hji on 12-19-2006
PASS Reports 20061116

It is good to be at PASS Sql Server conference in Seattle. Most people here have this kindred Sql Server spirit. Since we all have this in common, it is easy to start a conversation with pretty much anybody. All you need to do is to smile, greet each other warmly, and share your own stories that a lot...

Posted to Haidong Ji (Weblog) by hji on 11-16-2006
Connecting to Sql Server from Unix or Linux with FreeTDS

To connect to Sql Server from *nix environment, you can use JDBC (Java), Perl’s DBI and DBD packages, unixODBC, etc. You can also use another open source tool called FreeTDS . TDS stands for Tabular Data Stream. It is a protocol that defines how data is transmitted between computers. Both Sybase and...

Posted to Haidong Ji (Weblog) by hji on 08-31-2006
Connect to a different database server within command line utility

In sqlcmd, you can connect to a different server by this command: :connect MyServer The above command will attempt to use integrated / Windows Active Directory authentication. To use traditional Sql Server authentication, use this instead: :connect MyServer -U MyLogin You can do the same kind of thing...

Posted to Haidong Ji (Weblog) by hji on 05-09-2006
64-bit, virturalization, and their impact

VMWare recently released a freeware called VMWare Player that can play a pre-built virtual machine file. A virtual machine is an OS bundled with whatever the virtual machine creator put there. This is perfect for people to test-drive various operating systems and software, without going through the hassle...

Posted to Haidong Ji (Weblog) by hji on 01-15-2006
Vista, SQL Server 2005, AJAX, and Web 2.0

Ken's question made me think about Vista's impact. Virtually all Microsoft's products depend on the win32 API, so I wonder how much of change can Vista make? In other words, if Vista breaks win32 API calls, the cascading effects it has on other products like SQL Server, Exchange, BizTalk, Office, etc...

Posted to Haidong Ji (Weblog) by hji on 10-20-2005

Page 1 of 1 (10 items)