Using [`sys.triggers`][1]

    SELECT name, is_disabled FROM sys.triggers


  [1]: http://msdn.microsoft.com/en-us/library/ms188746.aspx

In big databases you usually don&#39;t know the table for the trigger.

    SELECT OBJECT_NAME(parent_id) [table_name],[name] [trigger_name],is_disabled
    FROM sys.triggers 



Descriptive State of Trigger help you to clearly ready about status. Also excluding triggers not related with user tables.

Check the below code:

    SELECT OBJECT_NAME(parent_id) [Table_Name],[name] [Trigger_Name],
    Case When is_disabled=0 then &#39;Enabled&#39; Else &#39;Disabled&#39; End [Trigger_Status], is_disabled
    FROM sys.triggers 
    where OBJECT_NAME(parent_id) is not null 

What exactly is a TCP connection?
I understand there isn&#39;t a physical connection from the client to server. Is this connection just the client&#39;s socket being linked with the new socket created by the server after the three-way-handshake? 
Thereafter once the &quot;connection&quot; is set up, the sockets on either ends of the connection then know where to send their packets.

How does this differ from the way UDP functions other than the initial handshake with TCP?
Is it that each server socket only has one client that sends packets to that particular socket?

What are some possible advantages of having a dedicated connection between hosts? My understanding of TCP and UDP is still very basic, so broad generalizations should suffice.

TCP vs UDP - What is a TCP connection?

I miss the Git syntax highlighting I had on Windows for every &quot;git .*&quot; command like green staged filenames, some bolding, etc.

How do I enable Git syntax highlighting for Mac&#39;s terminal?

Enabling Git syntax highlighting for Mac&#39;s terminal

How we can see which Trigger is Enabled or Disabled in SQL Server 2008?

SQL Server: check whether a Trigger is Enabled or Disabled?

<p>How we can see which Trigger is Enabled or Disabled in SQL Server 2008?</p>


So I want to do something like this sql code below:

    select s.id, s.name,s.city 
    from stuff s
    group by s.name having count(where city and name are identical) &gt; 1

To produce the following, (but ignore where only name or only city match, it has to be on  both columns):

    id      name  city   
    904834  jim   London  
    904835  jim   London  
    90145   Fred  Paris   
    90132   Fred  Paris
    90133   Fred  Paris

How do I find duplicates across multiple columns?

We have a 5GB table (nearly 500 million rows) and we want to remove the identity property on one of the column, but when we try to do this through SSMS - it times out.

Can this be done through T-SQL?


Remove Identity from a column in a table

When I submit a batch (e.g., perform a query) in SSMS, I see the time it took to execute in the status bar. Is it possible to configure SSMS to show the query time with millisecond resolution? 

Here is the bar I am talking about with the section of interest circled in red:

![enter image description here][1]


  [1]: http://i.stack.imgur.com/RiUKi.png

SQL Server Management Studio, how to get execution time down to milliseconds

I&#39;m going to delete data in an SQL Server table (parent) which has a relationship with another table (child).&lt;br&gt;
I tried the basic Delete query. But it isn&#39;t working (and I know it won&#39;t).

    DELETE FROM table WHERE ...
It returned following error

&gt; The DELETE statement conflicted with the REFERENCE constraint ...

I need to keep the table&#39;s schema. I know that I just need to add some words in the query, I&#39;ve ever done this before, but I just couldn&#39;t recall it.

Delete data with foreign key in SQL Server table

I need to alter one view and I want to introduce 2 temporary table before the SELECT.

Is this possible? And how can I do it?

    ALTER VIEW myView
    AS 
    
    SELECT *
    INTO #temporary1
    
    SELECT *
    INTO #temporary2
    
    SELECT * FROM #temporary1
    UNION ALL 
    SELECT * FROM #temporary1
    
    DROP TABLE #temporary1
    DROP TABLE #temporary2

When I attempt this it complains that ALTER VIEW must be the only statement in the batch.

How can I achieve this?


Is it possible to create a temporary table in a View and drop it after select?

I have an ASP.NET application which runs fine on my local development machine.

When I run this application online, it shows the following error:

&gt; Format of the initialization string does not conform to specification starting at index 0

Why is this appearing, and how can I fix it?

Format of the initialization string does not conform to specification starting at index 0

I have a table which has this schema

    ItemID    UserID    Year    IsPaid    PaymentDate  Amount
    1         1         2009    0         2009-11-01  300
    2         1         2009    0         2009-12-01  342
    3         1         2010    0         2010-01-01  243
    4         1         2010    0         2010-02-01  2543
    5         1         2010    0         2010-03-01  475

I&#39;m trying to get a query working which shows the totals for each month. So far I&#39;ve tried DateDiff and nested selects, but neither gives me what I want. This is the closest I have I think:

    DECLARE @start [datetime] = 2010/4/1;
    SELECT ItemID, IsPaid,
    (SELECT SUM(Amount) FROM Payments WHERE Year = 2010 And DateDiff(m, PaymentDate, @start) = 0 AND UserID = 100) AS &quot;Apr&quot;,
    (SELECT SUM(Amount) FROM Payments WHERE Year = 2010 AND DateDiff(m, PaymentDate, @start) =1 AND UserID = 100) AS &quot;May&quot;,
    (SELECT SUM(Amount) FROM Payments WHERE Year = 2010 AND DateDiff(m, PaymentDate, @start) =2 AND UserID = 100) AS &quot;Jun&quot;, 
    (SELECT SUM(Amount) FROM Payments WHERE Year = 2010 AND DateDiff(m, PaymentDate, @start) =3 AND UserID = 100) AS &quot;Jul&quot;, 
    (SELECT SUM(Amount) FROM Payments WHERE Year = 2010 AND DateDiff(m, PaymentDate, @start) =4  AND UserID = 100) AS &quot;Aug&quot;, 
    (SELECT SUM(Amount) FROM Payments WHERE Year = 2010 AND DateDiff(m, PaymentDate, @start) =5  AND UserID = 100) AS &quot;Sep&quot;, 
    (SELECT SUM(Amount) FROM Payments WHERE Year = 2010 AND DateDiff(m, PaymentDate, @start) =6  AND UserID = 100) AS &quot;Oct&quot;, 
    (SELECT SUM(Amount) FROM Payments WHERE Year = 2010 AND DateDiff(m, PaymentDate, @start) =7 AND UserID = 100) AS &quot;Nov&quot;, 
    (SELECT SUM(Amount) FROM Payments WHERE Year = 2010 AND DateDiff(m, PaymentDate, @start) =8 AND UserID = 100) AS &quot;Dec&quot;, 
    (SELECT SUM(Amount) FROM Payments WHERE Year = 2010 AND DateDiff(m, PaymentDate, @start) =9 AND UserID = 100) AS &quot;Jan&quot;, 
    (SELECT SUM(Amount) FROM Payments WHERE Year = 2010 AND DateDiff(m, PaymentDate, @start) =10 AND UserID = 100) AS &quot;Feb&quot;, 
    (SELECT SUM(Amount) FROM Payments WHERE Year = 2010 AND DateDiff(m, PaymentDate, @start) =11 AND UserID = 100) AS &quot;Mar&quot; 
    FROM LIVE L INNER JOIN Payments I ON I.LiveID = L.RECORD_KEY 
    WHERE UserID = 16178 

But I just get nulls when I should be getting values. Am I missing something?


How to group by month using SQL Server?

I&#39;m trying to write a script that will completely empty a SQL Server database. This is what I have so far:

    USE [dbname]
    GO
    EXEC sp_msforeachtable &#39;ALTER TABLE ? NOCHECK CONSTRAINT all&#39;
    EXEC sp_msforeachtable &#39;DELETE ?&#39;

When I run it in the Management Studio, I get:

&gt;Command(s) completed successfully.

but when I refresh the table list, they are all still there. What am I doing wrong?

How to drop all tables in a SQL Server database?

select unique rows based on single distinct column

I have this script:

    CREATE FUNCTION dbo.CheckIfSFExists(@param1 INT, @param2 BIT = 1 )
    RETURNS BIT
    AS
    BEGIN
	    IF EXISTS ( bla bla bla )
		    RETURN 1;
	    RETURN 0;
    END
    GO

I want to use it in a  procedure in this way:

    IF dbo.CheckIfSFExists( 23 ) = 0
	    SET @retValue = &#39;bla bla bla&#39;;

But I get the error:

&gt; An insufficient number of arguments were supplied for the procedure or function dbo.CheckIfSFExists.

Why does it not work?

T-SQL - function with default parameters

Using T-SQL, how would I go about getting the **last 3** characters of a varchar column?

So the column text is **`IDS_ENUM_Change_262147_190`** and I need **`190`**

T-SQL Substring - Last 3 Characters

I&#39;m trying to create a trigger on a table in my Amazon RDS database, and I can&#39;t seem to make it happen.

I tried to create a trigger on a table in the mysql client I use (Navicat), and got the error that I needed the SUPER privilege to do so. After some searching, I found that you could `SET GLOBAL log_bin_trust_function_creators = 1` to get around this. I tried that using these instructions: http://getasysadmin.com/2011/06/amazon-rds-super-privileges/ (and then restarting the DB server for good measure), but no luck.

I also tried creating the trigger and setting the variable via the mysql commmand line to make sure Navicat wasn&#39;t adding anything unwanted to my sql commands, but that failed, too. It also seems from searching that there&#39;s no way to grant yourself the SUPER privilege.

So ... is creating a trigger possible in RDS?


Can I CREATE TRIGGER in an rds DB?

I have a URLs table. They contain 

(id int primary key,
 url character varying unique, 
content character varying, 
last analyzed date). 

I want to create trigger or something(rule may be), so each time i make insert from my java program, it updates some single row if row with such URL exists. Else it should perform an Insert.

Please, can you provide a complete code in Postgresql. Thanks.

Postgresql, update if row with some unique value exists, else insert

In Google Sheets, you can add some scripting functionality. I&#39;m adding something for the `onEdit` event, but I can&#39;t tell if it&#39;s working. As far as I can tell, you can&#39;t debug a live event from Google Sheets, so you have to do it from the debugger, which is pointless since the event argument passed to my `onEdit()` function will always be undefined if I run it from the `Script Editor`.

So, I was trying to use the `Logger.log` method to log some data whenever the `onEdit` function gets called, but this too seems like it only works when run from the `Script Editor`. When I run it from the `Script Editor`, I can view the logs by going to `View-&gt;Logs...`

I was hoping I&#39;d be able to see the logs from when the event actually gets executed, but I can&#39;t figure it out.

How do I debug this stuff?

How to debug Google Apps Script (aka where does Logger.log log to?)

By looking at other examples I&#39;ve come up with the following but it doesn&#39;t seem to work as I would like: I want it to only update the modified information if the `QtyToRepair` value has been updated... but it doesn&#39;t do that. 

If I comment out the where then the modified information is updated in every case. As I said other examples led me to be optimistic. Any clues appreciated. Thanks.

Walter

    ALTER TRIGGER [dbo].[tr_SCHEDULE_Modified]
       ON [dbo].[SCHEDULE]
       AFTER UPDATE
    AS 
    BEGIN
    	SET NOCOUNT ON;

	    UPDATE SCHEDULE	SET modified = GETDATE()
		    , ModifiedUser = SUSER_NAME()
    		, ModifiedHost = HOST_NAME()
	    FROM SCHEDULE S
    	INNER JOIN Inserted I on S.OrderNo = I.OrderNo and S.PartNumber = I.PartNumber
    	WHERE S.QtyToRepair &lt;&gt; I.QtyToRepair
    END

SQL update trigger only when column is modified

How can I trigger a function when I click anywhere on my page except on one div (`id=menu_content`) ?

Content Type	Original Author	Original Content on Stackoverflow
Question	Vikrant More	View Question on Stackoverflow
Solution 1 - Sql Server	gbn	View Answer on Stackoverflow
Solution 2 - Sql Server	Igor Micev	View Answer on Stackoverflow
Solution 3 - Sql Server	ikram.chatha	View Answer on Stackoverflow

SQL Server: check whether a Trigger is Enabled or Disabled?

Sql Server Problem Overview

Sql Server Solutions

Solution 1 - Sql Server

Solution 2 - Sql Server

Solution 3 - Sql Server

Enabling Git syntax highlighting for Mac's terminal

TCP vs UDP - What is a TCP connection?

Attributions