SADSAC (5/5/2016)

---

Felix Pamittan (5/5/2016)

---

Correct answer:

Yes, you can run this code, This returns 97

Explanation:

You can run this code. The CHAR variable is converted to NCHAR and the first character's...

david.gugg (7/9/2015)

---

What is the difference between Shared Storage and SMB File Share? The link on that msdn page goes to https://msdn.microsoft.com/en-us/library/ms143506(v=sql.110).aspx#storagetypes, but it doesn't really describe them,...

+1

+1

Iwas Bornready (5/21/2015)

---

tom.w.brannon (5/21/2015)

---

As I read the documentation at

https://msdn.microsoft.com/en-us/library/ms181591(v=sql.110).aspx

and saw

ENCRYPTION = { DISABLED | { { SUPPORTED | REQUIRED }

[...

Jacob Wilkins (5/20/2015)

---

Nice question! I didn't have access to a server to test the code, so had to guess based on documentation. I saw nothing about the default algorithm, so...

Nice Question

SQLRNNR (5/6/2015)

---

r0yster (5/6/2015)

---

I CALL FOUL - the only correct answer to this should begin with 'It depends'. The CMS CAN be part of the server list by using...

Xavon (4/15/2015)

---

free_mascot (4/15/2015)

---

Carlo Romagnano (4/15/2015)

---

Hugo Kornelis (4/15/2015)

---

But note that supplying an offset only produces the expected results if you can be sure that there is exactly one row per month...

Sean of the Lynchmob (4/8/2015)

---

I got this when I ran it:

Msg 2760, Level 16, State 1, Line 1

The specified schema name "tmp" either does not exist or you do not...

free_mascot (4/8/2015)

---

+1...

Good one, Thanks Steve

+1 😀

interesting question... thanks

sipas (3/26/2015)

---

Joy Smith San (3/26/2015)

---

I created a job with only the command

"Select getdate())" which has syntax error in it.

The job failed. But,

1. It created the file when it was not...