I Don't think it makes a difference in a case insensative environment, but I am not sure about a case sensative environment.

Gregory Larsen, DBA

If you looking for SQL Server Examples...

Yes.

Here is an example:

use pubs

go

select case when city = 'Oakland' or city = 'Menlo Park'

then 'Change City'

...

I'm confused. Why do you want 10000, when batch 100 does not have a value at all in batch_table. Plus don't all the batch's associated with cut 10001...

If you create a clustered index on the column you want the data sorted by, then the data will be returned in asc order based on that column.

Gregory Larsen, DBA

If...

Here is something I think might work for you:

select * into #tmptest

FROM OPENROWSET('SQLOLEDB','<yourserver>';'<user>';'<password>',

'exec sp_who ') AS a

select column_name from tempdb.information_schema.columns where table_name like '#tmptest___%'

Gregory Larsen, DBA

If you looking for SQL...

I have yet to put one out on the web. Try this example:

create table #tmpwho (

spid int,

ecid int,

status char(20),

loginame char(100),

hostname char(100),

blk int,

dbname char(100),

cmd char(100))

go

INSERT INTO...

Ooops. Thank you for correcting my typo!!!!

Gregory Larsen, DBA

If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

Sorry for the blank post.

Yes. You can take the output of one sp, and place it into a temporary table. Then process through that temporary table...

quote:

---

can this be done??? I would like to make a Stored Procedure that builds a Select statement, based on the results of...

Yes you can also create network backups using a BACKUP devices that point to UNC names in SQL Server 2000.

Gregory Larsen, DBA

If you looking for SQL Server Examples check out...

Correct me if I'm wrong, but I think the select statement Antares686 provided will give you what you ask for the allocated size of the transaction log, but I think...

You can backup a database to a network share in SQL Server 7.0. Just like you said, create a backup device that points to a UNC name, then backup...

I tested this a while back when this came up. My quick test proved that you could skip the bad full backup and still restore the database.

Gregory Larsen, DBA

If...

I think you want you last query to look something like this. Basically you want to return all sysobjects of type = 'U' (left join with where o.type =...

Hey just thought of another way. You could capture the encrypted password, and then daily check to see if the encrypted password changed. Once it changed, you would...