Toreador (10/30/2015)

---

The correct answer should be END TRY - the completion of the try, which scores 5 points in Union, 4 in League. The Try Conversion (TRY_CONVERT) then scores an...

Index names aren't unique across the database. You must have an index called part_needi17 on a different table.

John

Is it the name of the column in your result set you want to change? If so, do it in the way Chris first suggested, or in the way...

ALTER DATABASE

John

Surely you just need to add another backslash to your search pattern? I've removed the first wildcard from the front - you don't need it if all values start...

Your command doesn't specify which file to move. It just moves all .dat files either to the Error folder or the Processed folder. Of course, once you've done...

Yes, or if the table already exists:ALTER TABLE enrollment_in WITH CHECK

ADD CONSTRAINT CK_BEN_DENT CHECK (BEN_DENT IN ('Y', 'N'))

The WITH CHECK option checks existing rows for compliance with the constraint. ...

sunitkrishna (10/21/2015)

---

I tried to implement the function as given abovw.With the test data this is fast,but with the original bulky data,it is taking a lot of time.

Can anyone suggest where...

Thanks for the question. I realised that two of the options were mutually exclusive, so I had a 50% chance of getting it right - I picked the correct...

I'm wondering whether SSIS adds some stuff to the beginning of the batch - maybe SET statements or such like. MERGE requires the preceding statement to be terminated with...

Kathy

DNS aliases should work. You'd need to wait until the old servers were retired and removed from the domain before setting up the aliases with the same names.

John

If you don't parse the query, what happens if you then execute the package?

John

In SSMS, choose Registered Servers from the View menu. Register any server as a Central Management Server. Right-click on that server and choose New Group, and create a...

It'll be your WHERE clause. If you have any non-numeric values in any of those four columns, you'll get the error. Try this instead for each of the...

Sunitha

Three steps:

(1) Use a splitter function (search this site to find one) to split the elements of your strings into rows

(2) Write a SELECT DISTINCT query to eliminate the duplicates....