Thanks for the responses, BlueJay was correct, it required vbNullstring.
I am the SQL developer, I rebuilt/ expanded the database that works with a new c#/xml front end. All stored procedures using this legacy spreadsheet have now been re-created but with parameters to scope them to the data...
Hi all, I am dealing with a piece of legacy code in an Excel spreadsheet. The following code has worked successfully for years however we have recently moved to a new SQL server and our stored procedure now requires a parameter.
The code retrieves stored procedure names from the database which...
Hi all,
I am having some difficulty in finding how to make a Table Valued Function (TVF) work in C# and T-SQL. I have managed to get a Scalar Valued Function (SVF) working perfectly however I have not been able to find any adequate documentation on how to implement a TVF.
I am not a fluent C#...
Thanks RiverGuy, that was essentially my issue with it!
As a self taught SQL developer I was just worried that I was being "dumb" and had missed some feature that lets you reference to a component of a primary key rather than the entire key. It seems that after much procrastination on my part...
Thanks for responding Borislav, that was my initial suggestion and was discussed as a solution however It was decided that the insert method was better for our needs (I agree with this after being talked round).
The issue boils down to,
"Is it possible to maintain a referenced relationship...
Hi All, I wondered if you could clear something up for me.
I have a database that we are currently attempting to roll out as a web app. Large scale changes are happening to the schema and we are currently working on provision for recording history within the database concentrating on the...
To follow on from my last statement I have just got this working
declare @db_name varchar(max)
select @db_name = top1 dbName from dbases
declare @q varchar(max)
set @q = 'select * from ' + @db_name + '.[dbo].infoSchema'
exec(@q)
infoschema definition
create view infoSchema as
select * from...
Hi bborissov,
I know the names of the databases, that isn't the problem. Are you suggesting that I use a stored procedure to retrieve the data from Information_schema.columns by building a string?
i.e.
exec 'select * from ' + @db_name + '.Information_schema.columns'
Hi all,
I need to create a view of Information_schema.columns for a particular set of databases, all located on the same server.
The project is to improve the data documentation manuals that we currently hold as word documents, I Intend to create a database that contains a view listing all of...
Sorry I possibly should have said I am purely a copy and paste VBA programmer and I generally guess how to do these kinda things and google it.
If that would be the way to do it I would appreciate direction to a tutorial, especially the referencing the field element bits.
I'm guessing from...
Hi all hopefully someone can help me with this, I think it should be possible but I'm not sure how to do it, my access experience is limited.
If this is a question that has been answered somewhere else a link to a guide would be appreciated however I cannot currently find one.
I have a very...
Hi all I would apreciate some generic help with the following problem as it's probably far too complex to document and solve on a forum but I need some more ideas on how to diagnose this problem.
situation:
PHP running on a Hiawatha server using an mssql 2000 database.
all of my queries run...
Hi all, I'm having a little bit of a problem making my table look as intended. I am attempting to make a table to display data with a fixed header. After adapting the example at
http://web.tampabay.rr.com/bmerkey/examples/nonscroll-table-header.html
for my purposes I have inserted some form...
Ok my general question is :-
If I have a cursor with 2 stored procedures in it each with an identically named cursor inside of them and an error occurs in the first procedure - is this cursor left open?
Secondly is the cursor left open after the end of the first stored procedure leading to an...
Dennis, I thought about this but decided that it would make no difference as each process is not mutually exclusive. Records created by proc1 are then used in proc2 so if the first part of the program falls over then the rest of the run is invalid.
Hi Mark,
I'm not sure that it would be possible to do a set based insert on this table for one reason.
The none auto incrementing primary key would make it difficult to insert multiple records directly into the table.
The solution(s) to this that we have found so far are to do it in the way I...
Hi Christiaan,
Here is my code - I must point out that I am dealing with a badly designed legacy database previously held in an ISAM Clarion TPS database - the code follows. I am also aware that the manual generation of new RecordID variables is a stupid way to do it but I do not have control...
Hi Mark - the cursors are neccecary - by design there are only ever 2 cursors open accross the whole process at any one time. 13 million is not the number of rows processed it is the number of update statements executed by the system as a whole. all cursors only hold a limited amount of data...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.