Prev: SQL 2008 passing Table-Value-parameters to stored proc via ODBC
Next: Insert multiple rows with stored procedures
From: Tony Rogerson on 23 Dec 2009 02:10
The --CLEKO-- troll is getting more and more extreme and off topic for this
Microsoft SQL Server forum.

Must be his age now Erland.

But this is getting very serious now; its confusing the hell out of people
just wanting to use what is in the product and don't care about portability.

Tony.

"Erland Sommarskog" <esquel(a)sommarskog.se> wrote in message
news:Xns9CEA2357F2E2Yazorman(a)127.0.0.1...
> --CELKO-- (jcelko212(a)earthlink.net) writes:
>> SQL has no loops. SQL has no sequential data access. It is a
>> declarative language that works with completed sets of rows, not
>> records from sequential files.
>
>
> The other day you said:
>
>> There is a WHILE loop in T-SQL last time I looked. Does the T-SQL
>> compiler remove invariant expressions in the WHILE loop? Does the T-SQL
>> compiler unroll a WHILE loop (granted that is easier with a counting
>> loop)?
>
> While there are no loops in SQL, you still care about whether SQL Server
> unrolls them!
>
>
> --
> Erland Sommarskog, SQL Server MVP, esquel(a)sommarskog.se
>
> Links for SQL Server Books Online:
> SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
> SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
> SQL 2000:
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
>
From: --CELKO-- on 23 Dec 2009 15:35
I did not know that SQL = T-SQL :) I did not know that cursors are
the preferred way to code and that you want to avoid declarative
code.

You knew exactly what I was saying. Come on, I expect this kind of
stupid sniping from Tony. You are usually better.

From: Tony Rogerson on 23 Dec 2009 16:24
> You knew exactly what I was saying. Come on, I expect this kind of
> stupid sniping from Tony. You are usually better.
>

I "snipe"

You "troll"

We are as bad as each other ;)

Perhaps you might want to consider this is a MICROSOFT SQL SERVER forum, not
a general "SQL" forum; there is a forum for that somewhere else - it gets
about 10 posts per month!

--ROGGIE--

"--CELKO--" <jcelko212(a)earthlink.net> wrote in message
news:cff2f152-ba33-459b-80c5-132623a26aab(a)m26g2000yqb.googlegroups.com...
> I did not know that SQL = T-SQL :) I did not know that cursors are
> the preferred way to code and that you want to avoid declarative
> code.
>
> You knew exactly what I was saying. Come on, I expect this kind of
> stupid sniping from Tony. You are usually better.
>
From: Erland Sommarskog on 23 Dec 2009 17:48
--CELKO-- (jcelko212(a)earthlink.net) writes:
> I did not know that SQL = T-SQL :)

In this newsgroup it is.




--
Erland Sommarskog, SQL Server MVP, esquel(a)sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

From: mouser on 23 Dec 2009 18:59

On 22-Dec-2009, "Tony Rogerson" <tonyrogerson(a)torver.net> wrote:

> The --CLEKO-- troll is getting more and more extreme and off topic for
> this
> Microsoft SQL Server forum.
>
> Must be his age now Erland.
>
> But this is getting very serious now; its confusing the hell out of people
>
> just wanting to use what is in the product and don't care about
> portability.

As I remember he was pretty intolerable around this time of year last
year...more so than usual. I do worry about his liver....
First  |  Prev  |  Next  |  Last
Pages: 1 2 3
Prev: SQL 2008 passing Table-Value-parameters to stored proc via ODBC
Next: Insert multiple rows with stored procedures