Search results for query: *

I have a database with 12 fields. When I select my data - I would like it to appear back like this: 1, 2, 3, 4 /N, 5, 6, 7, 8 /N, 9, 10, 11, 12 /N I would like a /N appended to every fourth item - and like to have it returned as a single field. Is there a simple way to do this using a PL/SQL...

Hi! I've got a SQL Statement that looks like this: SELECT project.strprojectid, strprojecttitle, dtDueDate, strProjectStatus, strConsultantName FROM project, projectConsultant, Consultant WHERE project.strProjectID = '9jjx1ujn4sa' AND project.strProjectID = ProjectConsultant.strProjectID AND...

Hi! I've got a SQL Statement that looks like this: SELECT project.strprojectid, strprojecttitle, dtDueDate, strProjectStatus, strConsultantName FROM project, projectConsultant, Consultant WHERE project.strProjectID = '9jjx1ujn4sa' AND project.strProjectID = ProjectConsultant.strProjectID AND...

Does anyone out there know a quick and effective way to migrate the structure and data from a MySQL database to a SQL Server database? I would appreciate any help I can get. Thanks!

What is the easiest way to move data/table structure from an XML file into a SQL Server database? Is there a way to do it w/o manually creating the tables? Thanks!

Can anyone out there tell me the proper steps to take to migrate a MySQL database to SQL Server?? We do not have MySQL in-house...we will have to access the database remotely using the MyODBC connector. Thanks!

I'm new to MySQL(meaning I've never seen or used it before). What I'm wondering is if you can take a backup file from a MySQL database and attach it to SQL Server and have an up and running copy of the database file? Can anyone out there answer this question or point me in the direction of...

Is there anyway in a SQL query to display the most recent fields submitted based on a datetime field? If so what is the proper syntax? Thanks!

Please help! I have a contact database that has basic contact info in it (approx 1200 records). Now I have found out that I need an ID number. Does anyone have any ideas on how to populate this field in a quick and easy way without have to run 1200 update statements??? Any help would be...

Is there anyway in a select statment to list 5 fields but only display 3 of them? I need some of the fields for the order by clause but don't actually want them displayed. Is there a solution?

I was wondering if there is any way to view what is in the transaction log backup files. Thanks!

Is there anyway in Enterprise Manager to remove old backup files like you see as an option in the maintenance plan?

Does anyone know how to solve this?? I would like to run the following SQL statement SELECT field1, ' - ', field2 FROM TableName ORDER BY field2 and get the result:: field1 - field2 Can anybody help??

I have a programmer that would like to be able to pull information out of a table one row at a time. I know that cursors are performance killers and not a good option...I'm just not sure if there is any other way to do this. The cursor we have now pulls out the info one row at a time...but...

I would like to be able to run my backups once a day to a mapped out network drive. I tried creating a new backup device, but it only allows me to see the C:/ drive...not the network drive that has been mapped out. Can anyone help me with this?

Is there anyway to customize what information is stored in your log files. My server was down over the weekend and there is nothing in the log files noting what happened. Thanks

We are trying to pull a record out of a table based on the number it is in result set. There is no actual number assigned to the row in the table. It somehow needs to be numbered after the query is pulled...without storing the number in the database. Does anyone out there have a way to solve...

I've got a programmer trying to use this statement... Select 3/8 ..and have it return the decimal value of 0.375 Right now it returns the value of 0. Can anyone help me get this return the correct value??