Soliciting other people to do your homework on an Internet form is cheating. Specifically, academic plagiarism, presenting the work of others as your own. We need to report you to...

>> I want to copy row(s) from Table_B into Table_A based on a condition. The first condition is a sequence number "OYHSSQA" and the second is Type "OYNMTP" I want...

>> I have two tables one is temporary and another is main dbo.employee <<

please, please, please read just one book on basic data modeling. A table models a set; a...

Jeez... as a bit of a sidebar, someone needs to find the "developer" that created all that and put them out of their misery. What a huge and ridiculous...

To reiterate what everyone else is trying to tell you, we cannot help you unless you follow minimal forum rules and netiquette. We need to see DDL. This DDL should...

Bluntly, but we 00 thing you have done is right proper>> I have got following data in my table <<

if you are doing the wrong thing badly.

Where is the...

The short answer is you can do this with an alter check constraint. The right answer is that you are going to destroy your data integrity. Why would you want...

Have you considered getting a third party audit tool? Why reinvent the wheel, expose yourself to legal problems, and slow your overall performance?

>> I'm trying to write a code to do a recursive check. <<

I am not sure what that means. A recursive check () constraint or what?

>> I can get the...

Decades ago, in 1960's, we used magnetic tape. The IBM convention was a prefix, followed by a two digit year and a three digit ordinal date within the year. Tape...

All of the Basic terms wrong in your post. Rows are not records; columns are not fields. Instead of using a zero, which is an actual numeric value, you probably...

I have a table of statuses(Open, Closed, etc.). I need to create a parameter that combines the first letter of multiple statuses, such as any status beginning with "O"...

There is actually a good...

No, this is not a table at all. A table has to have a key. But this can never have a key,...

I am trying to make over a column which depends on 3 columns. Like combination of emp1,emp2,emp3 as ID)

SELECT * FROM Personnel WHERE (emp1,emp2,emp3) IN (SELECT emp1,emp2,emp3 FROM Personnel);...