Can any one tell me max allowed size of argument of exec(') function in sql server ?
moreover, i am using this function to create stored procedure dynamically. so is it advisable to use exec(') for this purpose ?
View Complete Post
Is there a function I can use in the precedence constraint editor to check if a Exec SQL task populated an ADO recordset object?
Basically I have a select a,b,c from metadata_table where key = param and enabled = 1 and the output gets saved as an recordset object
I want the constraint to check that the object was populated before continuing and error out if not (the package should never execute with 0 rows being returned)
i've tried using
!isnull(User::ListOfFiles) and Len(User::ListOfFiles)>0 but both return true even when 0 rows are returned
I'd rather not add a @@rowcount output parameter to the Exec SQL task
Does the object have any methods I can use in the expression bit of the constraint editor that'll check if it has any rows? Or are there any Count-like functions that'll work on it? I'm not much of a .net coder so can't think of anything else
edit: nvm I just realised I need to use a script task to set the error message anyway so I can load the object there and do a Rows.Count
I had a custom confirm box Using Jquery....In that It crates two buttons Yes and No.
I need to execute my code in Yes click.....how?????
I cannot seem to work out how to put it together I get all sorts of errors
I would like to create a single bat file that execute 3 bat files and runs 10 sql scripts.
Any examples? help thanks a lot
I'm working on converting a datbase currently in SQL 2000 over to SQL 2008 and found this peculiarity:
DECLARE @sql varchar(1)
SET @sql = NULL
On my SQL 2000 machine that code returns 0, but on my test box running SQL 2008 it returns 1 no matter the compatibility level of the database (80 or 100). Is there a global setting / flag that might affect this behavior? Or is it just
a design difference in the two engines?
I haven't turned up anything when searching elsewhere, hoping someone can shed some light.