Recent content by Tech

thankyou fellow MVP :) well its a long explanation. but basically they have a big system. they are currently processing messages sent from a source. The details are actually stored on disk in a file system - a bad file system. They want to get away from that and use a structured DB instead. I...

This is slightly odd but was hoping someone could help me identify the key table components and fields here basically its a process of an existing system. they store data in various locations on the file system. Now want to try and move it all to DB in a structured way. i think ive identified...

what is, or does it exist, the T-SQL command to backup an MS Access database. is this possible?

found it ALTER TABLE [TableName] ALTER COLUMN [ColumnName] DataType(size)

what would the T-SQL be for changing (altering) the data length of a field programmatically in a table in MS Access? so if a field had a data length of 50, id like to change this to 60 programmatically. What would the code/syntax be?

Thanks. I found out the code/syntax ALTER TABLE [tableName] ALTER Column [PKColumn] COUNTER(0, 1) this will reset the seed to 0 incrementing by 1 on every new insert on the given fieldname/PK field I just wanted to find out how to reset the seed after deleting all records so it starts seeding...

thanks i will look for them but im trying to do this from .NET and would like the actual SQL/command for it. I know there are links to other pages but not quite what I had in mind.

in MS Access, is there a command like SQL which resets the Identity seed? I need to know this as after i remove all the records, would like the ID reset back to 0

this is a tricky one. Basically I have 3 tables country state city relationship: 1:m -> country:state 1:m -> state:city I want to get all the country, state and cities. SELECT * FROM country, state, city thats fine. But I only want to show unique values, in other words, just want to show...

I had resolved it doing something a bit cheeky, however I will take a look at that zip file I would have replied to the last comment made by SQL Hell but i wont, being the better person

well i do apologize. sorry if it is of any inconvenience - i am doing several projects of my own... i am facing a problem and asking a question on how to go about resolving the problem.

doublepost

I havent made one up as I am stuck! :( I am still learning SQL I guess part of the query would be: SELECT * FROM Matches WHERE TeamID = 'team1a' SELECT TeamName FROM Teams WHERE TeamName LIKE 'team%' Thought I had it in my mind last night, but that's not it! so I want to check for matches...

Hi there. This is a different SQL Table/database I have. What I want is this: say for instance, we have 2 teams. each team has subteams. subteams can play against each other from the same team. I want a SQL query which will retrieve me: 1) team 1a vs team 1b and the opposite of that...

they are not the same ;)