I have a table FileName with a field called Path. Here is an example of a record in the field: C:\My Documents\My Pictures\Vacation2010\Sunset.jpg 1. I need to write a procedure/function that will parse the extension from field Path in the table FileName to field extension in the table FileName. (THIS...

Hi All, What if I install just SQL client tools on my pc using a enterprise edition 180 day trail version. will that installed tools to get expired after 180 days or will that tools be good after 180 days too?

Hi All, What if I install just SQL client tools on my pc using a enterprise edition 180 day trail version. will that installed tools to get expired after 180 days or will that tools be good after 180 days too?

On a Client Computer named client1, a VB.NET application running which have a event named event1 with some arguments and the application connected to a SQL Server computer named server1. Another client computer named client2 have another vb.net application by which the user update the databse on server1...

HI All, I am setting up a very basic point score database and require some help with writing the appropriate SQL query. I have 3 tables, and only need to run a few few reports. Table 1 - Members id, Name, Class Table 2 - Events id, date, venue, type, president_series, clubman_series, points (clubman_series...

Hi, Say... My transaction table has date field and time field. How do I calculate the time elapsed after doing the transaction? Thank you. Regin

Experts I have created a small SQL server Express/VB.Net app for a couple of users to manage a small dataset on a single standalone computer. I want tihe users to be as autonomous as possible so have created a backup/restore process in the application for the SQL server data for a daily full back up...

Hello Experts! I'm trying to write a fairly simple SQL stored procedure and have run into some difficulty. The purpose is to test whether one of the parameters is 0 or -1 (via a bit variable) and if it is 0 then perform a certain INSERT statement and if it is -1 then perform a different INSERT statement...

I've got a daily maintenance plan that does the following: 1. Full Backup 2. Delete old backups 3. Delete old history 4. Reorganize Index Task 5. Update Statistics Task I was hoping to change #4 to reorganize the index for tables that have an avg_fragmentation_in_percent between 5% and 30% and rebuild...

hi, there; using sql server 2008, i have 2 tables: tblRequests and tblResponses tblRequests has the following: fldRequestID fldRequest 1 This is request 1 2 This is request 2 3 This is request 3 4 This is request 4 5 This is request 5 tblResponses has the following: fldResponsID fldResponse fldResquestID...