enrique_aeo
asked on
I should not use temporary tables or cursors, correct?
Hi, I have understood that I should not use temporary tables or cursors, correct?
if it is correct to use?
1. CTE
or
2. Table Value Parameters
or
3. code in. net and then add the ddl to my database
which is the best option?
if it is correct to use?
1. CTE
or
2. Table Value Parameters
or
3. code in. net and then add the ddl to my database
which is the best option?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
hi goHord
can you give me an example about it's
"because your doing something t-sql can't do"
can you give me an example about it's
"because your doing something t-sql can't do"
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
CTE is better.
check out this link.
http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/1aaacef5-226d-4965-b7cf-68feadc864f3
http://blogs.msdn.com/b/craigfr/archive/2007/10/18/ctes-common-table-expressions.aspx