I wud like to know in number of characters

Lynn

I am concating my sql statemements and exec as

exec (@sqlcmd1+@sqlcmd2+@sqlcmd3)

I will get 3 result sets but i need only 1 result set, like

exec @sqlcmd1 union exec @sqlcmd2 union exec@sqlcmd3

how...

If am using sql server 2005, how many characters does nvarchar allow me.

just curious to know if my proc will run in 2005

Lynn

What if I have 1000 lines of sql statements instead of just one select statement?

because nvarchar allows jusr 4000 characters

is there any other way where I can find the column name with the given data.

its a hard coding...

jobname,jobrole will be same for all the rows in emp

EXECUTE('select * from [' + @dbname + '].dbo.sysfiles')

for the same query how can i add where caluse like..

EXECUTE('select * from [' + @dbname + '].dbo.sysfiles') where date='09/04/1998'

I dont have any link to the table to update, can i update by querying where field='' something like tht?

I have 5 Db's and the test DB on the server.

I have a store proc where in it has more than 1000 lins of sql statements, how can i use dynamic sql there.

what i am trying to do is this...

I am trying to do something like this, but getting syntax error

CREATE PROCEDURE [dbo].test

@DBName varchar(30)

AS

SET NOCOUNT ON

Select * FROM @DBName.dbo.emp

WHERE jobid=''

GO

I can use FOR XML AUTO for select statements but how can i use for store proc

any more help pls..

I dont have that proc in msdb Db, coz its sql 2000. If you can copy the proc here i ca just create it in my 2000 and try working...

how can i export my store proc result set into a text file first?