THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |

Search

You searched for the word(s):
Showing page 1 of 5 (44 total posts) < 1 second(s)
  • re: ALTER TABLE SWITCH [PARTITION] – DDL or DML?

    Mark, as I said, by the syntax, it is DDL. But you missed the main point: physical operation is not what defines the Relational Model, it is the logical action. So if there would exist only composable DML syntax and MS would not explain the physical action, this would be a DML for you?
    Posted to Dejan Sarka (Weblog) by Dejan Sarka on April 6, 2014
  • ALTER TABLE SWITCH [PARTITION] – DDL or DML?

    My previous blog post Truncate Table DDL or DML Statement? got quite a few comments. Now I am continuing with a similar discussion: is the ALTER TABLE SWITCH [PARTITION] DDL (Data Definition Language) or DML (Data Manipulation Language) statement? At least it is clear that this is not a Data Control Language (DCL) statement. Again, I can find ...
    Posted to Dejan Sarka (Weblog) by Dejan Sarka on April 6, 2014
  • re: Truncate Table – DDL or DML Statement?

    Brian, this is my point - it is a DML because logically, it does a DML operation. However, yes, because of many things it can be treated as a DDL statement as well. My preference is DML, because this is the main idea of the Relational Model &nbsp;- to work on the logical level and don't care what the underlying system is doing on the physical ...
    Posted to Dejan Sarka (Weblog) by Dejan Sarka on March 31, 2014
  • re: Truncate Table – DDL or DML Statement?

    Koen, thank you for the comment. However, it does not convince me:-) Security is arbitrary selected. For example, in order to use some BULK INSERT options, you need ALTER TABLE permissions (http://technet.microsoft.com/en-us/library/ms188365.aspx). Does this make BULK INSERT a DDL statement?
    Posted to Dejan Sarka (Weblog) by Dejan Sarka on March 31, 2014
  • re: Truncate Table – DDL or DML Statement?

    Lubor, thank you so much for your comment. I will write a next blog on this topic for the ALTER TABLE SWITCH soon.
    Posted to Dejan Sarka (Weblog) by Dejan Sarka on March 29, 2014
  • re: Truncate Table – DDL or DML Statement?

    Sorry, pmbAustin, but I fail to see how the fact whether a command works with table variable or not defines the categorization of the command. But thank you for your comment!
    Posted to Dejan Sarka (Weblog) by Dejan Sarka on March 28, 2014
  • re: Truncate Table – DDL or DML Statement?

    Kennie, thank zou for the comment. Yet, I have to ask - when you say that these commands should not be a part of SQL, you mean &quot;a part of ANSI SQL standard&quot;? I am not talking about the standard, and I don't really care to much whether this is a part of ANSI SQL or not. It is a good thing to have a standard, and that's it. What I ...
    Posted to Dejan Sarka (Weblog) by Dejan Sarka on March 28, 2014
  • Truncate Table – DDL or DML Statement?

    Many times, categories of concepts and things overlap. It can be hard to categorize some items in a single category. The SQL TRUNCATE TABLE statement is an example of an item that is not so easy to categorize. Is it a DDL (Data Definition Language) or DML (Data Manipulation Language) statement? There is an ongoing discussion about this topic. ...
    Posted to Dejan Sarka (Weblog) by Dejan Sarka on March 28, 2014
  • Central Europe Trip with a Reason

    Why wouldnt you make a nice trip in Central Europe? Besides spending some nice days in beautiful cities, you have also a business-type excuse for the trip. You can join the two SQL Saturday events. The first one is going to take place in Budapest, March 1st, and the second one in Vienna, March 6th. I am very happy to meet the SQL community ...
    Posted to Dejan Sarka (Weblog) by Dejan Sarka on February 22, 2014
  • re: Indexing, Querying and Analyzing Text with SQL Server 2012-2014

    Well, Edde, thank you for your kind words!
    Posted to Dejan Sarka (Weblog) by Dejan Sarka on February 8, 2014
1 2 3 4 5 Next >
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement