AND and OR Operator in Sql Server
And & Or:- These Operators are used to further filter the recordset return by SQL queries when more than one conditions...
2014-08-13
550 reads
And & Or:- These Operators are used to further filter the recordset return by SQL queries when more than one conditions...
2014-08-13
550 reads
Sum():- This function is used to get the sum of values of the specified numeric column.
Syntax:-
Select Sum (column_name) from tablename
Example:-...
2014-08-12
699 reads
Round():-This function is used to round a numeric field to the number of decimals specified.
Syntax:-
ROUND ( numeric_expression , length [ ,function ]
numeric_expression...
2014-08-12
851 reads
This function returns the distinct values from the left query that are not also found on the right query. For...
2014-08-12
768 reads
Like:- This operator is used in a WHERE clause to search for a specific pattern in the values of the...
2014-08-11
411 reads
1. All the tables in the database have properly defined relationship using primary keys and foreign keys .
2. Indexes should...
2014-08-11
2,264 reads
This function is used to select the values within a specified range. These values can be of Int type or...
2014-08-11
336 reads
Left():- This function returns the specified number of characters from the left part of the given character string.
Syntax:-
Select LEFT ( character_expression...
2014-08-11
942 reads
Right():- This function returns the specified number of characters from the Right part of the given character string.
Syntax:-
Select RIGHT ( character_expression...
2014-08-11
763 reads
This function is used to returns distinct values that are returned by both the query on the left and right...
2014-08-11
1,049 reads
I had an excellent group of people in Gothenburg Sweden when I taught there...
By Steve Jones
How can I quickly get a CU patch for a system that’s out of...
Data analysis is all about wrangling massive datasets. To do that efficiently, you need...
Comments posted to this topic are about the item GIT Configuration and Automated Release...
hi a peer of mine recalls an error in an edi app that often...
Hello SSC! First, I would like to thank everyone who has responded to my...
I have created these triggers in SQL Server 2022:
CREATE TRIGGER triggertest_tri_1 ON dbo.triggertest FOR INSERT AS PRINT 'one' GO CREATE TRIGGER triggertest_tri_2 ON dbo.triggertest FOR INSERT AS PRINT 'two' GOI want to be sure that the trigger with "1" runs first. I decide to run this:
EXEC sp_settriggerorder@triggername = 'triggertest_tri_1', @order = 'first'What happens? See possible answers