Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
lsamant77
Starting Member
1 Post |
 Posted - 2009-04-23 : 10:09:58
|
| I work with mysql more tha SQL SERVERThere is an EXPLAIN command in mysql Is there any replacement in SQL SERVER for this command |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-04-23 : 10:15:54
|
Maybe sp_helptext ?sp_helptext 'name of stored procedure here'
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
pootle_flump
1064 Posts |
Posted - 2009-04-23 : 10:20:14
|
| Just a hint for future (Peter may have got this for you this time) - if you want to know if one app can do something another app can do, let us know what that command does in the first app! |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-04-23 : 11:01:11
|
http://dev.mysql.com/doc/refman/5.0/en/explain.htmlIt seems SET SHOWPLAN_TEXT {ON | OFF}is the tool he wants.
E 12°55'05.63"N 56°04'39.26" |
|
|
|
|
|
|
Query Execution