Any suggestions? I'm getting an error when trying to use an UPDATE statement inside of a function. error: Invalid use of side-effecting or...
Is there a way to query table names and the date the tables were created? thanks in advance [:D]
Any ideas on how to tackle this using SQL: column A = 10 column B = 20 column C = 30 column D = the lowest value of the 3 columns (which would be 10)...
Hello All, I'm inserting into a table via the back end. (using a stored proc) I think my insert locks the table because there is a delay on the front...
I have a function that evaluates if a record exist. I return a char(1) y or n. The function works fine but what is the general rule of thumb when...
Can anywone share their thoughts on SQL Server monitoring tools specifially for perfomance and maintenance? maybe something with:good out-of-the-box...
hello all, I used the ascii value char(9) at the end of each word in my procedure: SELECT rtrim('MY')+char(9)+rtrim('WORDS')+char(9)+rtrim('ARE'...
Hello all, Using SQL2005 importing I do not see the option to import an xlsx file. Is this a SQL service pack issue? as always thanks for you help
Hi All, I am investigating other options for returning the data to the calling reports or web apps. Since both a table-valued function and stored...
SELECT<br />round(9.425000,2,1),<br />round(34.775000,2,1)<br /><br />returns:<br />9.420000<br />34.770000<br /><br />However I would like to use...
/* Is there are way to use a variable in an UPDATE statement. re: UPDATE @column_name Example using MyColumn1 and MyColumn2 (the numbers "1" and...
/* Hello all... well here is the situation. I need the values in column_name to become columns. Since the value in column_name is not always...
I'm able to send the query as an attachment by setting @attach_results=true The default atatchment is .txt but is there a way to set it to .xls or...
An exchange mailbox was moved over the weekend. This caused my procedure that calls xp_sendmail to stop working. Usually a reboot of SQL server...
restore failed due to disk space. The db now reads "suspect". Realizing I didn't need to restore in the first place I figured let me just detatch...
Hello all, a stored proc returns one value (nextID) I want to call the stored proc and use the nextID for my variable Example: set @myID = exec...
what are some of the better or common design tools most developers use for creating visual database diagrams/schemas etc... so far I looked into...
Is there a method to return the current NT User name (or domain user name)? Host_Name()works for machine name but the requirements is to return the...
Hello all--<br /><br />we would like to have access to an exchange mailbox via SQL. From what I understand, SQL 2000/2005 have "hooks" into Exchange....
I need to pass a variable to the query parameter of xp_sendmail. What place holders do I use to put a variable inside of this text string? EXEC...
Separate names with a comma.
