zim (9/25/2007)

Posted - 09/25/2007 : 04:13:20 Show Profile Email Poster Edit Topic Reply with Quote

i want to write a database trigger to increment the salary...

make sure you use a field that is datetime. it can contain both the date and the time together; if you stored it as a varchar, change it to solve...

gotta watch for any scripts that use sp_MSFOREACHDB and also that selects from master.dbo.sysdatabases as well. any script susing that wouldn't explicitly say the db name, but might be using...

yes there is an easy efficient way;

look at this post:

http://www.sqlservercentral.com/Forums/Topic398428-338-1.aspx

there, someone wanted to replace extended ascii with the html encode; ie '‘Special Digital Data Service Obligation’ got some characters stripped...

thank you Pam!

I didn't know they did that in 2005. much easier to restore I assume, since it's part of the backup.

In the original posters case, since the backup came...

this will work for any binary file it was here on SCC from 07*02/2007 post if you want to google the whole thread.

INSERT INTO myTable(Document) SELECT *...

am i wrong? i thought full text catalogs were not part of the database, but a separate file stored on the server, so you needed to back those up separetely,...

you should script the deletes and truncates manually;

when people say they want to delete the data, they are really saying just certain data...they typically don't want to dete teh data...

using SQL2000's QA to connect to botha SQL2000 and SQL 2005, i get the same results that your SQL 2000 did; no null row; i changed SET ANSI_NULLS on and...

ok i got a vb project to work based on your parameters...here's my question;

in your example, the file had 5 columns. typically, BULK INSERT would expect 5 columns for all...

how about this?

SELECT

RegionDesc,

MATotal,

PartsTotal,

DemandTotal,

Total,

(CASE WHEN ISNULL(Total,0.00) = 0 then 0

     ELSE  ISNULL(MATotal,0.00)    +

           ISNULL(PartsTotal,0.00) +

           ISNULL(DemandTotal,0.00)   / Total END) * 100 As Percentage

FROM SOMETABLE

look in the script contributions for the split() function.

it takes a delimited list and turns it into a table, so your statement woudl simply change to this:

"user_accounts INNER...

here's the answer to both questions: change a login name:

--Usage: EXEC pr_RenameLogin 'webdev', 'WebDeveloper'

--modified from from http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=408&lngWId=5

---Code should be put in master database ---

CREATE PROCEDURE...

i think this is nothing more than adding a HAVING statement to the query you posted:you might need to select max(score), testcount as a separate subquery instead because of all...

is a design change so that the fields are stored as encrypted data instead of plain text/numbers out of the question?

I recently had to do that, redid the table so...