it's going to look a lot like this:

the only thing i could not determine was the primary key that woudl related the INSERTED to the DELETED ; your example did...

Sean Lange (6/6/2013)

---

I for one would be super interested in seeing how you reverse engineer your indexes. I just went through this process and I have a feeling yours will...

here's a start to finish example, where i create a user, grant just the permissions Perry identified in his posts, specifically impersonate that user for testing, and then read from...

Sean mine was just a lazy adaptation of something that already existed; it was easier than from- scratch script to find them; this adapted snippet from the middle of your...

bslchennai (6/6/2013)

---

Yes, i have to take care of all null values because in our database we should not insert null values on indexed columns. and now my database size is...

my verison is kinda of wordy but works with a case statement:

SELECT

CASE

WHEN RTRIM(ISNULL(col1, '')) <> ''

AND RTRIM(ISNULL(col2, '')) <>...

Jerome it seems to me you are leaving a lot out.

your example must be coming inside a cursor, right? why don't you show that part too?

your code(so far) is adding...

i...

SQLSACT (6/6/2013)

---

ikonrao (6/6/2013)

---

We have a table in which we want to know whether any of the columns has unique constraint defined.

Or if we can get create table statement for that...

have you created a job at...

Maybe the autoclose proeprty is...

i think the issue is your second statement; you only select if your variable is empty string, but you already created it?

i would do it all in a single command,...

We support an app that connects to either SQL or Oracle as well, and trip over the which-data-types-are-equivalent questions as well;

for your second question,

NUMBER(10) = int

this is my go to...

ikonrao (6/6/2013)

---

We have a table in which we want to know whether any of the columns has unique constraint defined.

Or if we can get create table statement for that table,...

I'd recommend starting with some of hte articles in the "stairways" series, here on SQL Server Central:

http://www.sqlservercentral.com/stairway/

those articles are on subjects and build up from basic information to more and...