You missed my point. Anyways, execute following in your system (another window). Then execute your query in first window.

ALTER PROCEDURE SP_MULTI_INSERTS

(@SUB_QUERY AS VARCHAR(2000),

@INSERT_PART AS VARCHAR(2000),

@DELIMITER AS VARCHAR(100),

@ERRORMESSAGE AS VARCHAR(2000)

)

AS

--By Narayana...

GilaMonster (12/23/2011)

---

Dev (12/23/2011)

---

Errr, no.

It is needed for...

The current clustered index is an aid int, bid int, date datetime, those three columns are the one the application most frequently queries against, this becomes extremely fragmented, extremely fast...

I worked on Multi-Lingual databases and honestly speaking I never bothered to verify it in SSMS. First reason for that was I didn’t know the language :hehe:. Second reason, SSMS...

Per BOL:

FOR UPDATE [OF column_name [,...n]]

Defines updatable columns within the cursor. If OF column_name [,...n] is supplied, only the columns listed allow modifications. If UPDATE is specified without a column...

I don’t want to discourage or disappoint you but Google is the right place to start. Find BOL & books of your own interest and start learning it.

It can be achieved with SQL query but I won’t recommend you that. As Lutz has already suggested, please do it on Front End. That’s the right place for such...

To all my SSC Friends,

Happy Holidays!!! :smooooth:

Are you kidding me :w00t: I don’t share the same degree but I guess share interest. I read Psychology when I get bored of technical articles. :doze:

It’s...

DemonicKat78 (12/23/2011)

---

I want to know if some one can help me make this "query SQL" a php script. So i can set a Cron Job for everyday at 12am.

If...

It might not appear in the same format in SSMS but when you pull it back in application with proper regional font, does it appear correctly there?

Search for 'Results to Text' in following article.

SQL Server Management Studio Database Engine Query Editor Window

http://msdn.microsoft.com/en-us/library/ms177264.aspx

BrainDonor (12/23/2011)

---

The Night Before Startup

...

On update, on add, on inquire and delete,

on batch jobs, on closing on functions complete.

His eyes all glazed over, hands nimble and lean,...

In my case I also have 2 post-graduate degrees, one of which pertains managing a business and understanding these types of things. Like a techy MBA 🙂

...

It is just...

I have the same understanding as yours that if the password expires SQL Server won’t stop functioning unless it restarts.

I don’t want to argue on Company Policy but if I...