Search results for query: *

I have a SQL Server 2022 database and Visual Studio 2022. The database has a join table connecting several other tables. There is a view that shows the join table with the joined tables values rather than the keys used in the join table (all keys are uniqueidentifiers). I am a beginner with SSIS...

Unfortunately, most of the Database Developer jobs out there seem to require SSIS.

Thank you for the clarification. You say you wouldn't be keen to use SSIS going forward. Is this due to difficulty or is there something wrong with SSIS or other better items out there?

I've got SQL Server 2022 and am trying to learn SSIS to go with it. However, I can't find any books for SSIS 2022 nor any YouTube videos. When I try to use an old SSIS 2005 book, tries to lead me through SQL Server Data Tools, which don't seem to exist in SQL Server 2022. Am I doing something...

Thank you very much.

Thank you very much. "Runtime" - that's what I couldn't remember. Is the following done for each table in the database? ' ADOX: create table Set adxTable = New ADOX.Table With adxTable .Name = "Table1" With .Columns .Append "Field1", adDate ' date .Append "Field2"...

Not quite. How does one, using MS Access create an Access database that can be used on a computer that does not have MS Access installed?

No. How does one create it?

I have seen an application that uses an Access database without the user's computer needing to have MS Access installed. Once someone has created the database in MS Access, how do they create this version of the database?

At one time, Windows included a stripped down version of SQL Server. Do the current versions of Windows still have this feature?

Thanks. I guess the best to suggest that they do it that way. Thank you.

I don't have any of that information - the user is supplying it. I agree. It is bad form but that's the way I've been instructed to do it. I've had this type of nonsense happen before.

Unfortunately, I need to present the data as in the form - one field for the three pieces The data going into the field is Building Name/Floor/Room. They are going, eventually, to tblBuilding, tblFloor, tblSpace. I believe that the code is already in place to split these three pieces of...

Someone, in their infinite wisdom has created a website that connects to a database. This website has a data entry form which has a field into which three pieces of information are to be entered separated by slashes (/). The .sql code in the database then breaks up the three pieces of...

I have a column of dropdowns. I would like to be able to set cell A1 (it can be any given cell) equal to the value selected from the dropdown. Is there any way of doing it with Excel functions rather than using macros?

A column was accidentally deleted from a table and needs to be added back in the same place that it was originally. Using Design from the Object Explorer for the table in question, I can easily add the column wherever I want in the table. However, when I go to leave, I get a message that says I...

I tried with Explorer. Ah. I thought about a DOS prompt but it's been so many years since I used it that I don't remember how to do it.

I am a photographer and keep my photos and associated post-processing info on an external hard drive. I also have a second hard drive to act as a backup of the first hard drive. What I didn't realize was that each time there was a backup, it was added to the second hard drive. I now find that...

Thank you both very much. It works fine now. Unfortunately, I need to run these script against various databases that are sent to me, so I need to be able to create the function if it isn't there, but not have the script choke if it is there.

I need a function within a script. At any time when this script is run, the function may or may not exist. I have tried writing it in the form of IF EXISTS DROP FUNCTION GO CREATE FUNCTION GO This gives an error saying the function already exists (I guess because they are in separate...