Transact-SQL v.s. SQL?

[SONYFX]

Are they pretty much the same? (one is used foe MS SQL and one is generic?)

 

[kamper]

Tsql is just microsoft's dialect for stored procs and hence is more powerful/complex than regular sql. You can do loops and conditional and shiznit. Every vendor has something similar (but different). It's entirely possible to use sql server without tsql.

 

[mugs]

Originally posted by: kamper
Tsql is just microsoft's dialect for stored procs and hence is more powerful/complex than regular sql. You can do loops and conditional and shiznit. Every vendor has something similar (but different). It's entirely possible to use sql server without tsql.

I think Transact-SQL actually refers to Microsoft's variant of SQL as well, not what you use for stored procedures.

 

[kamper]

Originally posted by: mugs

Originally posted by: kamper
Tsql is just microsoft's dialect for stored procs and hence is more powerful/complex than regular sql. You can do loops and conditional and shiznit. Every vendor has something similar (but different). It's entirely possible to use sql server without tsql.

I think Transact-SQL actually refers to Microsoft's variant of SQL as well, not what you use for stored procedures.

Fair enough, but then doesn't it get to be like arguing about whether c is c++ (or a if shitzu is a dog)?