Search results for query: *

What is the SQL equivalent of the Mid function in a SQL Server view ? It will allow SELECT Left([que_file_key],2) But not Select Mid([que_file_key],3,20) It says Mid is not a recognised function name - anyone got any ideas ?

I have successfully added "all" to a combo box using a union query with access 2000 i.e SELECT "*" FROM EMPLOYEES UNION (SELECT [LASTNAME] FROM EMPLOYEES;); Then I can select from a query using the Like "*" operator. This all works fine within access but when I try...

Hi, I am using SQL server 2000 and am storing an xml string in a sql field of datatype text, length 16. The size of the xml string may vary from small to quite large but whenever I export the file to disk (using a scheduled DTS task) the file created is always the same size - over 2mb. This is...

I need to store a text file into a sql server field - I am cureently using varchar however the data is getting truncated as it is more than likely greater than 8000 characters. I may need to hold up to 20,000 characters I tried to use text which I believe can hold up to 2GB of data but when I...

I want to out the contents of a field in a record to a file and then update the contents of another field called STATUS to "Exported"

I want to create a stored procedure that will select records meeting the required criteria, then loop though and run another stored procedure on each record individually before proceeding to the next - is this possible ? Any help would be greatly appreciated e.g. CREATE PROCEDURE sp_test as...

I have a scrollable form with 2 subforms. If I am half way down the form and move to the next record the data refreshesokay but the layout of the form goes all over the place (its like its putting the new form ontop of the previous one - anyone any ideas ?

I have an access 2000 application which is using MS access security. I have setup my user and admin groups with permissions to edit a form. I have a status field on the form and if the staus field is changed from "in progress" to "billed", I want to prevent any member of the...

I have a for with a combo box containing a value list which calls a query to out put values select. How do I put an All option so that the query will select all the values in the value list ?

I have a SQL Server 2000 application with a access 2000 front-end with multiple users. Users can enter new records but when they try to update an existing record access id giving a "write conflict" error. I presume this is as a result of locking in SQL Server - any ideas on howI get...

Tried this but it does not seem to work

I am using NT authentication to logon to sql server and I have written an insert trigger that needs to capture the NT user name for the user that adds a new entry. I have added a field called modifier and set the default of this field as(suser_name()). However, this does not seem to capture...

Hi, I'm new to SQL Server (ver 7)and would appreciate any help with the following - I wanted to capture every action that occurred on a particular table, such as who modified the record, what kind of modification took place, and when the record modification occurred. What is the best way to go...