in the previous example just I gave ref. see the below code for more view:

-- Code

-- Procedure Creation

createprocedure#Orders

(@OrderIDvarchar (100)

)

as

declare@Querynvarchar (2000)

set@Query= 'select * from Northwind.dbo.Orders where OrderID in (' +...

use DBCC CHECKDB, DBCC DBREPAIR (sql 2000) and then observe the display output.

you can pass multiple SalesOrderID, see the below example, and re-write you sp accordingly.

Code:

declare@OrderIDvarchar (100)

,@Querynvarchar (2000)

set@OrderID= '10248, 10249, 10260'-- Multiple values

set@Query= 'select * from Northwind.dbo.Orders where OrderID in (' +...

for SQL 2000: select * from master..sysmessages;

SQL 2005: select * from master.sys.messages;

This table exists in master database.

need some more info. of your query.

use OpenDataSource in you Select Statement to get the Oracle Data.

For more information see SQL BOL.

not possible to restore database with .ldf file, send a query to directly microsoft sql server team.

try like this:

select ID, isnull (firstname, '') + ' ' + isnull (middlename, '') + ' ' + isnull (lastname, ''), isnull (address, ''), isnull (phoneno, '') from contact

set the isolation levels for database. So don't worry about whether record is commited or not.

for more info see SQL BOL.

in SQL 2000, there is no PIVOT command, but you can get the data like PIVOT for more information see SQL BOL.

in SQL 2005 and above version PIVOT command exists,...

use COALESCE function instead of IsNull or NullIf.

can you try like: selectconvert (varchar, getdate(), 106), for more info see SQL BOL CAST & Convert Funtions.

No direct command available related to PIVOT in SQL 2000, but you can get it, see the SQL BOL and search "PIVOT Table".

follow the Jack instructions.

Generally SQL 2008 Dev. edition available to download for MSDN / Tech Net subscribers.

Dev. Edition cost is $50. See the link: http://www.microsoft.com/sqlserver/2008/en/us/pricing.aspx