Hi friends,
Sorry to sound slow but where is the 'Query Analyzer' in SQL Server. Can't find it in Enterprise Manager?
Thanks,
Lee.
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21324793.html
Hi
I have a SP which takes two parameters as in put
1) datetime
2) PK (-1 for allrecords)
i.e if -1 is supplied then data for all the records is displayed , and if a particular PID is suppli...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20751685.html
Zones:
MS SQL ServerDate Answered: 09/30/2003 Rating: 7.8 Views: 0
Hi,
In vba I can insert a break point in code module and step through the code one line at a time. Is this possible with query analyser, if so how?
Does anyone know how to step through execut...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20727119.html
Zones:
MS SQL ServerDate Answered: 09/02/2003 Rating: 9.4 Views: 0
I am trying to find a way of shrinking the transaction logs on all databases against a specific SQL Server instance, this would ideally occur at a specific time. Is it possible to do this with a Tr...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2311...
We have a SQL DB and im trying to write the stored procedure for use with the crystal report.
It is to trace pallets of product booked from our warehouse into production, and then returned back ...
http://www.experts-exchange.com/Programming/Languages/SQL_Syntax/Q_23989561.html
Zones:
SQL SyntaxDate Answered: 12/17/2008 Rating: 9.2 Views: 0
I need to select only the first 4 numericals from the fields eg
4468SWM00 want to select 4448
4465SWC00 want to select 4465
4896SWW00 want to select 4896
http://www.experts-exchange.com/Microsoft/Applications/Q_24626881.html
the dba is on holiday and i have been asked to amend this view I have to add another reference on a completely different table.
the table is costcentre
salesarea_id is the common field on costcen...
http://www.experts-exchange.com/Database/Oracle/PL_SQL/Q_24639663.html
I have a huge T-SQL script that does a db update. It was working fine but now gives me "Incorrect syntax near the keyword 'TABLE'" but no info for tracking down the specific line that generates the...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23933657.html
Zones:
MS SQL ServerDate Answered: 11/27/2008 Rating: 8.2 Views: 4
