enriquezreyjoseph (9/24/2013)

---

Sean Lange (9/24/2013)

---

PLEASE do yourself a favor and read this article. http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/[/url]

It has been suggested to you at least a couple of other times in the various threads you...

You'll have to play around with the String Functions to get what you want.

Maybe...

SELECT REVERSE(SUBSTRING(REVERSE('1a'), 2, LEN('1a')));

SQL and Strings... not exactly a match made in heaven.

srajinigandh (9/18/2013)

---

ramakantshankar (9/13/2011)

---

Hi,

As you said we can use the SQLCMD to execute operating system commands by indicating the " !! " before the command.

I have created a POC on...

(I'm very sorry but this is so funny)

I can't believe you actually posted that question on a...

Thanks for the responses.

ApexSql do a free intellisense tool (and no, I don't work for them):

http://www.apexsql.com/sql_tools_complete.aspx

gurjer48 (9/2/2013)

---

where we use dynamic sql queries??

in my office we don't use dynamic sql queries but I am want to know in which case it finds application??

if possible give...

I think people spend way more time than they should denegrating Certifications.

Regardless of whatever qualifications you have, degree, ms certs, including mcm's / mca's (no disrespect to them), once you...

By all means use the Splitter, I've used it a few times and it's work really well but take the time to look at the Table Valued Parameter approach suggested...

Maybe now would be a good time to pick up on Extended Events 🙂

Maybe if you show us what you can see for stored procedures we can help you find it's equivalent for views.

I would second the PowerShell approach.

It's a lot cleaner and dare I say more flexible IMHO.

Scheduling a PShell Script from within Sql Agent is also straight forward as has already...

This should amount to simple CASE Statements within your Procedure but you will have to provide a bit more information to get the help you need.

hristo1977 (8/19/2013)

---

Hi,

I have a Excel sheet with usernames, I would like to loop through the usernames and see what info exists in the database, based on each username. Where do...

Rather than hide that logic in a Trigger, wouldn't it be better to just deny your users direct access to the base table and then use a Stored Procedure...