the recommended way is to use the system views like this:

select * from INFORMATION_SCHEMA.COLUMNS

if you want to start doing it yourself, this will get you started:

select object_name(id) as TableName,

name as...

first thing I'fd suggest is avoiding trying to use NOLOCK;

the NOLOCK in should only be used as a last ditch attempt to improve performance...you usually don't need to allow dirty...

an OLD post for version 3.5 of Redgate implies that this error could occur if you are running out of disk space, or backing up over a network share...could that...

I've done something very similar with a tally table, where i wasinserting avbCrLf after a certain number of characters; I'm away from my hoe PC that has the code, but...

it sound's to me like you want to take Brian Kelly's suggestion one step further, and log successful logins as well...i think you are saying everyone is SUPPOSED to connect...

by "get rid of it" i assume you mean eliminate from the query, and not delete from the table...

you want to use the LIKE operator: LIKE '%-%' means a...

the built in convert functions can give you the format you want: you'd end up with a varchar containing all the inf....is that goo?

select convert(varchar,getdate(),112) ,

convert(varchar,getdate(),114),

replace(convert(varchar,getdate(),112) + convert(varchar,getdate(),114),':','')

2008101708:57:54:45320081017085754453

DBASkippack (10/17/2008)

---

Need...

it's pretty simple...you'd use a BETWEEN statemnt for 2004 AND YEAR(GETDATE())...but you need to select it from a table, right?

once again, Jeff Moden's Tally Table would be the ideal tool...

your going to be mad at yourself...you did everything except CAST/CONVERT your answer to the desired decimal:

create table test(

Price decimal(5,2),

QuotedCost decimal(5,2),

OrigCalc AS ([Price]-[QuotedCost])/[Price] *(100)...

duplicate thread;

follow the answered thread here:

http://www.sqlservercentral.com/Forums/Topic587537-359-1.aspx

you've show us just part of your stored procedure, it looks like...the line you posted wil certainly only display a single column, "Records", so there must be a line in...

this sounds very much like a homework assignment....

aside from that...

you want to do a few things....

you said only three specific values.... as you suspected, read about CHECK CONTRAINTS in you...

try something like this:

select gpsdata_history.*

from gpsdata_history

inner join

(SELECT

REGISTRATIONNO, MAX(GPS_DATETIME)

FROM ...

here's how i would do it:

first id read everything into a single string, instead of line by line.

then i could use substring functions to find what we need instead.

...

there is a free open source project that is a 2005 profiler, independant of MS;

I use it all the time and it is very good.: very small footprint and you...