HTH.

It's not only a good habit... it's one of the very first best pratice anyone should learn. Comes bite you in the ass so often that you have no...

ya.. you're gonna have fun though... 1000 columns will certainly break the 8000 char limit .

I'm wondering how I would get around that...

set yourfield = null

I was asking you this question because you posted in the "suggestion" section instead of reporting services.

While I don't know anything about it, I can tell you that Access works...

Yes there's a log in sql server, however this information is stored in hexadecimal format and needs to be interpreted. Also sql server logs only the MODIFICATIONS to the...

Yup... but this sure kicks but compared to all the other ways we have in sql server 2000. Yukon will handle this even easier.

Still faster to relink that to rename manually .

WHAT (I know Frank is correct)?????????

Declare @v-2 table (a varchar(100))

Declare @Text as varchar(100)

Set @Text = 'ARE ' + CHAR(10) + CHAR(13) + CHAR(9) + 'YOU' + CHAR(10) + CHAR(13) +...

HTH.

it's even easier to do query generation on the server using QA. You just got to know your way around the sys* tables.. or the information_schema views

Not the way I've written it... assuming I got the PK right and that I understand what he wants to do .

You'll need something like this :

IF Object_id('ListTableColumns') > 0

DROP FUNCTION ListTableColumns

GO

CREATE FUNCTION dbo.ListTableColumns (@TableID as int)

RETURNS varchar(8000)

AS

BEGIN

Declare @Items as varchar(8000)

SET @Items = ''

SELECT

@Items = @Items + C.Name + ',...

Are you talking about the reporting services?

GO

CREATE PROCEDURE dbo.DEMO @a as int, @b-2 as int out, @c as int output

AS

SET NOCOUNT ON

SET @b-2 = @a + 1

SET @c = @a * 5

Select @a as a, @b-2...