Jonathan Kehayias (1/22/2010)

---

ChiragNS (1/18/2010)

---

Great article and here comes another dumb question!

After signing the procedure with certificate can the procedure be executed only by the login/user created from the certificate? Can...

Hi anyone there!!

Learnt some thing . But does'nt Set ansi_warning have an impact.

The moderator or who ever checks the questions in QOD can make it compulsory to include the specific version of SQL or have a option that says the question implies...

Will we get our points back.

Great article and here comes another dumb question!

After signing the procedure with certificate can the procedure be executed only by the login/user created from the certificate? Can other users execute...

confusing question. should have been worded better.

learnt some thing. but how does it work?

learnt something new , but i think this is not used regularly or am i wrong?

What info do you want to display.

If i remeber correctly COALESCE returns the first not null value.

Hi

You can use the CASE function for this. I dont have SQL installed in m/c now to give u the exact query.

To OP - not to sound harsh but pls lookup BOL and then ask your doubts. A Few doubts can be cleared by checking BOL.

Hope my comments will be...

Basic thing but is the mssql service running.

I cant read your full err msg but it seems you are trying to insert the value 'staffing' to column whose data type does not support char/varchar data type. Check...