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...

adonetok (8/22/2014)

---

Thank yo for help.

If I put script like below, does it include all records?

SELECT

*

FROM @test-2 T

WHERE T.TEST_STRING in ('red', 'green') or T.TEST_STRING = ''

OR T.TEST_STRING...

Quick thought, two options, the developer should change the security setting to "Do not save sensitive..." or the second option, open the package in a text editor and remove the...

Quick thought, since you are (I think) on SQL 2012, why not use Extended Events?

😎

Quick thought, could this be caused by Cartesian Product, see the example?

😎

USE tempdb;

GO

DECLARE @TBL01 TABLE

(

T_ID INT NOT NULL

);

DECLARE @TBL02 TABLE

(

T_ID INT NOT...

Something like this? (code from another reply adopted to...

If I remember correctly, there is a backward compatibility components option in the SQL install, seen this problem when trying to access earlier versions of SQL Server without having the...

Quick thought, are the SSMS versions 2008 or later and could the backward compatibility be missing?

😎

Quick thought, use the LIKE operator

😎

USE tempdb;

GO

DECLARE @test-2 TABLE

(

TEST_ID INT IDENTITY(1,1) NOT NULL PRIMARY KEY CLUSTERED

,TEST_STRING VARCHAR(50) ...