My mistake... I had put VARCHAR(enter size here) between > and < and it was interpreted as html by the browser. Just make sure that the size you enter...

try

'REPLACED BY ' + CAST(yorkmfgnumberss022405.mfgnumber AS VARCHAR())

Is it normal that you don't have a where condition in this update.. or is the where condition contained in the inner joins?

basically, it means you can't do this

select col1, col2 from x

union all

select col1, col2 from y

order by MissingColumnFromSelect

Keep in mind that the order by is done after the union all...

Select distinct O.Name FROM dbo.SysComments C inner join dbo.SysObjects O on C.id = O.id where Text like '%Create view%' and O.XType = 'P' Order By O.Name

sql = "SELECT Count(tblLinkRequest.LinkRequestID) AS CountOfLinkRequestID, tblLinkRequest.DateSent FROM tblLinkRequest GROUP BY tblLinkRequest.DateSent HAVING (((tblLinkRequest.DateSent)='" & Date() & "'));"

1 - May I suggest that you normalize the design... it's not normal to see field1, field2 in a table definition.

2 - If you are only updating 1 table, I...

well if the procs work.. nothing. SysDepends is used when ou ask sql server to show the object dependencies (spa needs table1,view2 and vice-verca)... but this is not always...

You seem to be close.. can you send the ddl with some sample data. Also what results you are expecting also with what you are getting. It'll be...

What exactly are you trying to do?

2 ways of doing this :

1-

create myproc2 @somevariable as int

as

select 1

go

Create myproc1

as

set @somevariable = 3

exec myproc2 @somevariable

go

2-

Create myproc1 @SomeVariable int output

as

set @somevariable = 3

go

create myproc2 @SomeVariable int

as

select 1

go

declare @var...

1 - Why would you keep the same data in 2 different columns of the same data type?

2 - If you really want to do it you're gonna need a...

I've never seen such a variable in Sql server. The only thing comparable to that would be the line number provided with sql server's error messages. But I...

maybe a left() operation could be faster... but the question is : Is it always ok the truncate the decimal part or do you need to keep it if it's...

That's a very good question... one that I can't answer. However is is considered best pratice to explicitly declare the cursor as local or global.

tinyint = 1

smallint =2

int = 4

bigint = 8

bit = 1 (for the first 8, then 2 bytes from 9 to 16, 3 from 17 to 24...)

datetime = 8

smalldatetime =...