You had stated

which , by inserting those extra rows, would make that statement incorrect. so one accounts_ID can have...

if this is the case then your sample data is incorrect. it should be something like this.

INSERT INTO A

SELECT 1,1,'TABLE_1','COLUMN_1',123

INSERT...

I have to ask is the sample data you provided an accurate reflection of your actual data. Because if you are using the values:

1,'TABLE_1','COLUMN_1',123

then there are four rows that would...

can you post what you would like the output to look like because from your description it just sound like you would like the two rows that have an accounts_id...

This should work for you.

DROP TABLE MYEXAMPLE

CREATE TABLE [dbo].[MYEXAMPLE] (

[EXAMPLEID] INT IDENTITY(1,1) ...

I believe that the default constraint will only work for newly inserted row not existing ones.

That is a very good question. I have seen this type of behavior...

First off, what is the problem? Is the trigger not working correctly or not working at all? Second, some sample data would help in solving the problem. Please read the...

the pipe character is usually the alternate character of the backslash. "Shift" + "\" will result in "|"

I dont know how you can migrate just the password but the stored proc in this kb article will generate create scripts for all logins with passwords.

I have something that I use that may be a little more encompassing then what you are asking for but it does include login role membership and object permissions. ...

if the start date is in the past then your schedule will pick up the first day of the next month because the first day of current month has past....

rajganesh.dba asked if both servers were 2008 or if one was a earlier version. What is the answer to that?

Also would you be able to post a script of you...

You can pull the file out of the database and onto the file system in a similar fashion that I did with the powershell script because they use the same...

glad I could help. As for where to learn tsql just doing it seems to be the best for me. Books online is a great resource. I also used w3schools...