Simon-413722 (1/9/2012)

---

jnuqui (1/8/2012)

---

they should have read the background of the company first before proceeding with the implementation.. customer feedback review is also a must.

Anyway, I have a horror story too...

amen to you sir..

aw dang... and me thought there really is a problem.. this is just a typical LOGIC question being asked in interviews. the interviewer nailed you man. hahaha

please give us more details like screenshots for details so we could help.:-D

in addition you may use this script.. 🙂

you may want to run this per database lol.. haha just change the value to what you want to search lol.. you...

hi you may use the Len variable.

select employeeID, EmployeeName, EmployeeTask from Employees

where Len(employeedID) = 9

this will post only all employeeID whos lenght is 9 eg.(000333444)

hope this helps...

cheers! 🙂

Dude this manipulation should be done in application side. 🙂

You should set column in your user table that will verify if this is an admin user.

Sample table:

UserName ...

your job is a success because you've successfully executed a script which should fail. lol. kiddin.

FYI that SQL server checks your script before you could create the job. 😀 it...

hi!

You may use this step by step guide by PINAL. Im pretty sure this procedure is the same as the one when we did encryption thingy in our MS SQL...

try using the GUI version lol. h:-D

they should have read the background of the company first before proceeding with the implementation.. customer feedback review is also a must.

Anyway, I have a horror story too but its...

of course you may not. 😀

put [ ] in their names. same as reply above. 🙂 sample [North-wind].[Employee].[User-Names] something like that. 😛

haha click the F5 button dude! 😀

OK so heres the catch. put the email alert on the same stored procedure your application is using to insert the orders. with this it will surely mail the new...