Double up on the quotes.

declare @sql varchar(1000)

select @sql = 'INSERT dbo.mytest SELECT 'insert sales select ''test'' '

Also, watch your spaces. You are missing a few.

This was a 2003 question

Hany Helmy (2/23/2015)

---

In the daily newsletter email I recieved, the answer for that question was: "You can use certificates, asymmetric keys, or passwords" while the answer on the website is:...

mar.ko (2/24/2015)

---

re: "GUIDs give you a large space of possibilities."

I understand, but I would never use an Autonumber/Sequence as a key reference to a product or client, etc.

Instead, I would...

http://www.sqlservercentral.com/articles/Build+List/71065/

You might read this to ensure you understand: http://www.sqlservercentral.com/articles/Administration/64582/

There are a few:

http://www.amazon.com/T-SQL-Querying-Developer-Reference-Ben-Gan/dp/0735685045/ref=asap_bc?ie=UTF8

http://www.amazon.com/Microsoft-Server-Fundamentals-Developer-Reference/dp/0735658145/ref=asap_bc?ie=UTF8

http://www.amazon.com/Microsoft-High-Performance-Functions-Developer-Reference/dp/0735658366

Tom has a good summary here. If someone would like to tackle a short, simple, intro piece, we'd appreciate it.

I'll also say that I think my kids spend too much time in front of screens and it makes me crazy. But my son runs cross country, my daughter plays...

My three kids are older (13+ now), and so we've given up...

Very true. Late to respond, but my experience with my two younger kids is that they were much...

Thanks. Glad that you enjoyed it and got something.

You can also query the backup files and look at the LSNs to do some matching to determine what's the latest. Ultimately that's the best. This script might help you:...

I'd lean towards what Gail mentioned. If you need inserts to happen without affecting reads, then isolation is probably the best way. However this changes where resources are needed on...

GUIDs are very unlikely to collide, but there have been reports of this. It's not something to worry about in practice, but be aware.

These certainly are important for things...