Nita Reddy (8/18/2014)

---

I want to export one table but text contains ',' so can I use double " ? I don't see option when I select delimiter how should I...

Looks to me that it does what it says on the tin.

😎

Inspecting the filter, we find:

WHERE dp.class < 4

Listing permissions for

0 = Database

1 = Object...

Quick suggestion, look...

Here is a quick solution using CHARINDEX

😎

USE tempdb;

GO

CREATE TABLE [dbo].[x_JobMatching](

[CVID] [int] NULL,

[JobNoticeID] [int] NULL,

[isMatch] [bit] NULL,

CONSTRAINT [x_JobMatching_UQ1] UNIQUE NONCLUSTERED

(

[CVID] ASC,

[JobNoticeID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE =...

Luis Cazares (8/22/2014)

---

Note that you might replace strings you don't want them to be replaced.

INSERT INTO @test-2(TEST_STRING)

VALUES

('I am a bad Gal')

,('I am a good Gal')

,('Oh my goodness! There''s no...

Are indexes not ANSI compliant?

😎

Lynn Pettis (8/22/2014)

---

Eirikur Eiriksson (8/22/2014)

---

Nice to see that you are having a friendly chat...

Nice to see that you are having a friendly chat with your best pal:w00t:

😎

shaimaa.tarekelshoeiby (8/22/2014)

---

Thank you all for your replies 🙂

Before copying any create or insert data, here is an example

Select * from Culture --2327 rows

Select * from Trial --6793 rows

Select *...

Lynn Pettis (8/22/2014)

---

Eirikur Eiriksson (8/22/2014)

---

Lynn Pettis (8/22/2014)

---

Even if you use a natural key as the primary key, I would still consider adding a synthetic id to the tables and making...

Lynn Pettis (8/22/2014)

---

Even if you use a natural key as the primary key, I would still consider adding a synthetic id to the tables and making it a non nullable...

"that" being a) writing the function b) write the comments c) populate the extended properties d) all of the above (turbo version):-D

😎

Maxer (8/22/2014)

---

If you use the LEFT() function for example it provides intellisense support for some of the required parameters.

Is there a way to get that same descriptive help text in...

A CROSS JOIN...

You are right (of course) Luis, I just quickly copied an example I still had open...