in

SQLServerCentral.com

The largest free SQL Server community.
All Tags » SqlServer2K » OpenSourceStuff (RSS)

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
Page 1 of 1 (7 items)
Copyright Red Gate Software
Powered by Community Server (Commercial Edition), by Telligent Systems