I have this stored procedure that sets defaults to blank strings for all the
columns in a table. I have some date columns in this table also, how would I
identify that the column is data or integer or double or char..
PROCEDURE DefaultsALL
USE qtk EXCLUSIVE
FOR i = 1 TO FCOUNT()
fieldname = FIELD(i)
ALTER TABLE Qtk ALTER COLUMN (fieldname) set default ' '
ENDFOR
ENDPROC
Re: looping through a listbox values in stored proc ... You only get proper validation if you do use CSV or table valued parameters; relying on the data type covers almost nothing - you still have to write a load of logic to make sure your values passed are between 5 and 15. ... Adding an extra parameter to the stored procedure would be a nightmare - not only would you have to go through a complete test cycle on the stored procedure but all the applications that use it would need to be changed and tested - one hell of a resource burden when you could have done it up front more dynamically. ... performance depended on the length of the CSV strings (I vaguely ... (microsoft.public.sqlserver.programming)
Cannot Get Pass String Limitations In DTS ... I have a loop in a Stored Procedure that reads records from a table to build ... Doing this I CANNOT exceed 4000 characters regardless of what type of string ... Even after I have successfully concantinated the strings... (microsoft.public.sqlserver.dts)
Re: Using Stored Procedure Variables ... I see what you're talking about but these numbers are listed as strings,... but the first 6 digits I already know, so doing a between statement will ..."Keith Kratochvil" wrote: ... The stored procedure would stoere that in a variable such as ... (microsoft.public.sqlserver.programming)
RE: Multiple Input Parameters ... May be your @SQLString parameter is declared too short to contain the concatenation of two strings. ... May be you miss a space when you concatenate the two strings.... You start the debugger in SQL Query analyzer by right-clicking the stored procedure and then select "debug". ... (microsoft.public.access.adp.sqlserver)
Re: TSQL problem ... First of all, use single-quotes, not double quotes, for strings.... you don't need to use dynamic SQL in this situation: ... > i want to execute my string in stored procedure... > exec @query... (microsoft.public.sqlserver.programming)
