Home
Videos uploaded by user “IT Port”
Stored Procedures in SQL Server Tamil
 
09:32
Click here to Subscribe to IT PORT Channel : https://www.youtube.com/channel/UCMjmoppveJ3mwspLKXYbVlg A stored procedure is a precompiled set of one or more SQL statements that is stored on Sql Server. Benefit of Stored Procedures is that they are executed on the server side and perform a set of actions, before returning the results to the client side. This allows a set of actions to be executed with minimum time and also reduce the network traffic. Hence stored procedure improve performance to execute SQL statements
Views: 4938 IT Port
SQL Server Index Example in Tamil
 
09:23
Click here to Subscribe to IT PORT Channel : https://www.youtube.com/channel/UCMjmoppveJ3mwspLKXYbVlg SQL Server Clustered & Non Clustered Index with example. Create index in a Table with bulk data, and Comparing Performance
Views: 4188 IT Port
ANSI_NULLS in SQL Server
 
02:46
Click here to Subscribe to IT PORT Channel : https://www.youtube.com/channel/UCMjmoppveJ3mwspLKXYbVlg When SET ANSI_NULLS is ON, a SELECT statement that uses WHERE column_name NULL returns zero rows even if there are null values in column_name. A SELECT statement that uses WHERE column_name IS NOT EQUAL TO NULL returns zero rows even if there are nonnull values in column_name. When SET ANSI_NULLS is OFF, the Equals and Not Equal To comparison operators do not follow the ISO standard. A SELECT statement that uses WHERE column_name = NULL returns the rows that have null values in column_name
Views: 1355 IT Port
Magic Tables in SQL Server
 
07:29
Subscribe to IT PORT : https://www.youtube.com/c/itport28 SQL Server Tutorial in Tamil : https://www.youtube.com/playlist?list=PLouAaeZ4xQ64enJDwWVvN3KduuZRlUrb3 SQL Server Concepts in Tamil : https://www.youtube.com/playlist?list=PLouAaeZ4xQ67kdNIByJKAGBIBhor_h4Hs SQL Server Analytic Functions in Tamil : https://www.youtube.com/playlist?list=PLouAaeZ4xQ65XIU5azEUgLVrBKEl-jWMV SQL Server Tutorial : https://www.youtube.com/playlist?list=PLouAaeZ4xQ66AYrzPtxt2SeeR4UABcBcO SQL Server Concepts : https://www.youtube.com/playlist?list=PLouAaeZ4xQ66zRe8-nDDy-YHY2o0rmbn4 SQL Server Analytic Functions : https://www.youtube.com/playlist?list=PLouAaeZ4xQ64hTsEdhLsVBquE1vERWngX Magic table is nothing more than an internal table which is created by the SQL server to recover recently inserted, deleted and updated data into SQL server database. When we insert or delete any record from any table in SQL server then recently inserted or deleted data from table also inserted into inserted magic table or deleted magic table with help of which we can recover data which is recently used to modify data into table either use in delete, insert or update to table. We can only see it with the help of Triggers and Output Clause
Views: 2321 IT Port
SQL Server Triggers Tamil
 
10:51
Click here to Subscribe to IT PORT Channel : https://www.youtube.com/channel/UCMjmoppveJ3mwspLKXYbVlg SQL Server Triggers with After and Instead Of Tamil
Views: 5592 IT Port
SET NOCOUNT, ROWCOUNT in SQL Server
 
04:33
Click here to Subscribe to IT PORT Channel : https://www.youtube.com/channel/UCMjmoppveJ3mwspLKXYbVlg NOCOUNT - Stops the message that shows the count of the number of rows affected by a Transact-SQL statement or stored procedure from being returned as part of the result set ROWCOUNT - Causes SQL Server to stop processing the query after the specified number of rows are returned.
Views: 3627 IT Port
Subquery in SQL Server Tamil
 
05:07
Click here to Subscribe to IT PORT Channel : https://www.youtube.com/channel/UCMjmoppveJ3mwspLKXYbVlg Explanation about Sub Query in SQL Server
Views: 1660 IT Port
Group by clause in SQL Server - Part 22 Tamil
 
13:08
Subscribe to IT PORT : https://www.youtube.com/c/itport28 SQL Server Tutorial in Tamil : https://www.youtube.com/playlist?list=PLouAaeZ4xQ64enJDwWVvN3KduuZRlUrb3 SQL Server Concepts in Tamil : https://www.youtube.com/playlist?list=PLouAaeZ4xQ67kdNIByJKAGBIBhor_h4Hs SQL Server Analytic Functions in Tamil : https://www.youtube.com/playlist?list=PLouAaeZ4xQ65XIU5azEUgLVrBKEl-jWMV SQL Server Tutorial : https://www.youtube.com/playlist?list=PLouAaeZ4xQ66AYrzPtxt2SeeR4UABcBcO SQL Server Concepts : https://www.youtube.com/playlist?list=PLouAaeZ4xQ66zRe8-nDDy-YHY2o0rmbn4 SQL Server Analytic Functions : https://www.youtube.com/playlist?list=PLouAaeZ4xQ64hTsEdhLsVBquE1vERWngX The SQL GROUP BY clause is used in collaboration with the SELECT statement to arrange identical data into groups. This GROUP BY clause follows the WHERE clause in a SELECT statement and precedes the ORDER BY clause. Explained in Tamil
Views: 1015 IT Port
SQL Server Cursor Example Tamil
 
08:42
Click here to Subscribe to IT PORT Channel : https://www.youtube.com/channel/UCMjmoppveJ3mwspLKXYbVlg Defines the attributes of a Transact-SQL server cursor, such as its scrolling behavior and the query used to build the result set on which the cursor operates. DECLARE CURSOR accepts both a syntax based on the ISO standard and a syntax using a set of Transact-SQL extensions.
Views: 1923 IT Port
Difference between After and Instead Of Triggers in SQL Server
 
05:50
Click here to Subscribe to IT PORT Channel : https://www.youtube.com/channel/UCMjmoppveJ3mwspLKXYbVlg After Triggers fire after the execution of an action query that can be either DDL statements like Create, Alter and Drop or DML statements like Insert, Update and Delete Instead OF Triggers fire before the execution of an action query that can only be DML statements like Insert, Update and Delete but after the execution of that query. The table data will not be affected, in other words if you want to insert or update the data of the table then you need to write it in the trigger using "inserted" or "deleted" virtual tables
Views: 1564 IT Port
SQL Server Primary key Example Tamil
 
06:10
Click here to Subscribe to ITPORT Channel : https://www.youtube.com/channel/UCMjmoppveJ3mwspLKXYbVlg Simple Example for Primary Key & Foreign Key
Views: 2988 IT Port
Self Join in SQL Server Tamil
 
04:25
Click here to Subscribe to IT PORT Channel : https://www.youtube.com/channel/UCMjmoppveJ3mwspLKXYbVlg A self join is a join of a table to itself. This table appears twice in the FROM clause and is followed by table aliases that qualify column names in the join condition.
Views: 684 IT Port
Common Table Expression CTE in SQL Server Tamil
 
06:45
Click here to Subscribe to IT PORT Channel : https://www.youtube.com/channel/UCMjmoppveJ3mwspLKXYbVlg A common table expression (CTE) can be thought of as a temporary result set that is defined within the execution scope of a single SELECT, INSERT, UPDATE, DELETE, or CREATE VIEW statement. A CTE is similar to a derived table in that it is not stored as an object and lasts only for the duration of the query. Unlike a derived table, a CTE can be self-referencing and can be referenced multiple times in the same query.
Views: 380 IT Port
STUFF, REPLACE in SQL server
 
05:34
Click here to Subscribe to IT PORT Channel : https://www.youtube.com/channel/UCMjmoppveJ3mwspLKXYbVlg STUFF is used to replace the part of string with some other string OR It delete a specified length of characters within a string and replace with another set of characters REPLACE is used to replace all the occurrences of the given pattern in a string.
Views: 853 IT Port
Rows Unbounded Preceding, Following in SQL Server
 
11:35
Click here to Subscribe to IT PORT Channel : https://www.youtube.com/channel/UCMjmoppveJ3mwspLKXYbVlg From SQL Server 2012, This feature enabled to OVER BY Windowing Functions The ROWS limits the rows within a partition by specifying a fixed number of rows preceding or following the current row. Preceding and following rows are defined based on the ordering in the ORDER BY clause ROWS BETWEEN 1 PRECEDING AND CURRENT ROW – Aggregates 2 Between Last Row and Current Row ROWS BETWEEN CURRENT ROW AND 1 FOLLOWING – Aggregates 2 Current Row and Next Row ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW – Aggregates all Rows before Current Row with Current Row ROWS BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING – Aggregates all the Rows After Current Row With Current Row ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING – Aggregates all Rows
Views: 1402 IT Port
Basics Of Cursors in SQL Server Tamil
 
08:26
Click here to Subscribe to IT PORT Channel : https://www.youtube.com/channel/UCMjmoppveJ3mwspLKXYbVlg Cursor is a database object to retrieve data from a result set one row at a time, instead of the T-SQL commands that operate on all the rows in the result set at one time. We use cursor when we need to update records in a database table in row by row Explained in Tamil
Views: 1217 IT Port
ANSI_PADDING in SQL Server
 
05:40
Click here to Subscribe to IT PORT Channel : https://www.youtube.com/channel/UCMjmoppveJ3mwspLKXYbVlg ANSI_PADDING option specifies how trailing spaces are handled in CHAR and VARCHAR columns, and trailing zeros in BINARY and VARBINARY columns When this is ON, Trailing Spaces/Zero are stored and retrieved if data contains them When this is OFF, Trailing Spaces/Zero truncated.
Views: 493 IT Port
SQL Server PIVOT Example Tamil
 
09:51
Click here to Subscribe to ITPORT Channel : https://www.youtube.com/channel/UCMjmoppveJ3mwspLKXYbVlg Simple example for Pivot in SQL Server
Views: 2538 IT Port
SET IDENTITY_INSERT in SQL Server
 
07:41
Click here to Subscribe to IT PORT Channel : https://www.youtube.com/channel/UCMjmoppveJ3mwspLKXYbVlg Identity column automatically getting inserted with Increment value based on its Increment Value. Generally we can’t Insert Value to Identity Column. If we want to Insert Identity value, we must enable IDENTITY_INSERT.
Views: 4378 IT Port
GO Command in SQL Server
 
04:19
Click here to Subscribe to IT PORT Channel : https://www.youtube.com/channel/UCMjmoppveJ3mwspLKXYbVlg Signals the end of a batch of Transact-SQL statements to the SQL Server utilities. It is used to group SQL commands into batches which are sent to the server together. The commands included in the batch, that is, the set of commands since the last GO command or the start of the session, must be logically consistent. For ex, you can't define a variable in one batch and then use it in another since the scope of the variable is limited to the batch in which it's defined.
Views: 865 IT Port
SQL Server @@Identity vs Scope_Identity vs Ident_Current
 
16:30
Click here to Subscribe to IT PORT Channel : https://www.youtube.com/channel/UCMjmoppveJ3mwspLKXYbVlg Identity is a Column Property. This Property is used with CREATE TABLE and ALTER TABLE Transact SQL Statements. When you insert a new record into your table, this field automatically assign an incremented value from the previous entry. Usually, you can't insert your own value to this field. You must specify both the seed and increment or neither. If neither is specified, the default is (1,1). We Can Get the Inserted Identity value by using these three Functions. @@IDENTITY SCOPE_IDENTITY IDENT_CURRENT In this Video you can check these functions with Simple Example
Views: 3694 IT Port
SQL Server Computed Column Persisted
 
06:18
Click here to Subscribe to IT PORT Channel : https://www.youtube.com/channel/UCMjmoppveJ3mwspLKXYbVlg SQL Server Computed Column Persisted Example
Views: 582 IT Port
LOGON Triggers in SQL Server
 
05:04
Click here to Subscribe to IT PORT Channel : https://www.youtube.com/channel/UCMjmoppveJ3mwspLKXYbVlg Logon Triggers are special kind of Stored Procedure or an operation that gets executed automatically in response to a LOGON event. They get executed only after the successful authentication but before the user session is established. If authentication fails the logon triggers will not be fired Uses Of Logon Triggers a). To audit and control server sessions b). Restricting logins to Sql Server c). Restricting the number of sessions for a specific login d). Restricting user from logging-in outside permitted hours
Views: 629 IT Port
SQL Server Joins Tamil
 
08:55
Click here to Subscribe to IT PORT Channel : https://www.youtube.com/channel/UCMjmoppveJ3mwspLKXYbVlg SQL Server Joins - Inner Join, Left Outer Join, Right Outer Join, Full Join, Cross Join and Self Join with Example in Tamil
Views: 5492 IT Port
Introduction - Partition in SQL Server - Part 1
 
04:03
Click here to Subscribe to IT PORT Channel : https://www.youtube.com/channel/UCMjmoppveJ3mwspLKXYbVlg Partitioning is the process of dividing a single large table/index into multiple logical chunks/partitions in such way that each partition can be managed separately without having much overall impact on the availability of the table/index. Partitioning improves the manageability and availability of table/index as well as the performance of the queries running against this partitioned table/index SQL Server supports table and index partitioning. The data of partitioned tables and indexes is divided into units that can be spread across more than one filegroup in a database. The data is partitioned horizontally, so that groups of rows are mapped into individual partitions. All partitions of a single index or table must reside in the same database. The table or index is treated as a single logical entity when queries or updates are performed on the data.
Views: 632 IT Port
Output Clause in SQL Server
 
08:36
Click here to Subscribe to IT PORT Channel : https://www.youtube.com/channel/UCMjmoppveJ3mwspLKXYbVlg Returns information from, or expressions based on, each row affected by an INSERT, UPDATE, DELETE, or MERGE statement. These results can be returned to the processing application for use in such things as confirmation messages, archiving, and other such application requirements. The results can also be inserted into a table or table variable
Views: 347 IT Port
Introduction - Partition in SQL Server - Part 1 Tamil
 
04:05
Click here to Subscribe to IT PORT Channel : https://www.youtube.com/channel/UCMjmoppveJ3mwspLKXYbVlg Partitioning is the process of dividing a single large table/index into multiple logical chunks/partitions in such way that each partition can be managed separately without having much overall impact on the availability of the table/index. Partitioning improves the manageability and availability of table/index as well as the performance of the queries running against this partitioned table/index SQL Server supports table and index partitioning. The data of partitioned tables and indexes is divided into units that can be spread across more than one filegroup in a database. The data is partitioned horizontally, so that groups of rows are mapped into individual partitions. All partitions of a single index or table must reside in the same database. The table or index is treated as a single logical entity when queries or updates are performed on the data. Explained in Tamil
Views: 485 IT Port
Delete duplicate rows in SQL Server Tamil
 
04:17
Click here to Subscribe to IT PORT Channel : https://www.youtube.com/channel/UCMjmoppveJ3mwspLKXYbVlg A common table expression (CTE) can be thought of as a temporary result set that is defined within the execution scope of a single SELECT, INSERT, UPDATE, DELETE, or CREATE VIEW statement. A CTE is similar to a derived table in that it is not stored as an object and lasts only for the duration of the query. Unlike a derived table, a CTE can be self-referencing and can be referenced multiple times in the same query
Views: 300 IT Port
How to Hide Stored Procedure Code in SQL Server
 
02:45
Click here to Subscribe to IT PORT Channel : https://www.youtube.com/channel/UCMjmoppveJ3mwspLKXYbVlg Hide SQL Server Stored Procedure Code for all
Views: 416 IT Port
Deadlock example in SQL Server Tamil
 
12:03
Click here to Subscribe to IT PORT Channel : https://www.youtube.com/channel/UCMjmoppveJ3mwspLKXYbVlg Explanation about deadlock & how to handle it in SQL Server Tamil
Views: 1749 IT Port
Insert multiple rows in SQL Server
 
05:07
Click here to Subscribe to IT PORT Channel : https://www.youtube.com/channel/UCMjmoppveJ3mwspLKXYbVlg Methods to insert Multiple rows in SQL Server
Views: 2483 IT Port
SQL Server Types of Keys in Tamil
 
11:42
Click here to Subscribe to IT PORT Channel : https://www.youtube.com/channel/UCMjmoppveJ3mwspLKXYbVlg Explanations about all types of Keys (Super, Candidate, Primary, Alternate, Composite, Unique and Foreign) with example in Tamil
Views: 4236 IT Port
Constraints in SQL Server  - Part 6 Tamil
 
15:49
Subscribe to IT PORT : https://www.youtube.com/c/itport28 SQL Server Tutorial in Tamil : https://www.youtube.com/playlist?list=PLouAaeZ4xQ64enJDwWVvN3KduuZRlUrb3 SQL Server Concepts in Tamil : https://www.youtube.com/playlist?list=PLouAaeZ4xQ67kdNIByJKAGBIBhor_h4Hs SQL Server Analytic Functions in Tamil : https://www.youtube.com/playlist?list=PLouAaeZ4xQ65XIU5azEUgLVrBKEl-jWMV SQL Server Tutorial : https://www.youtube.com/playlist?list=PLouAaeZ4xQ66AYrzPtxt2SeeR4UABcBcO SQL Server Concepts : https://www.youtube.com/playlist?list=PLouAaeZ4xQ66zRe8-nDDy-YHY2o0rmbn4 SQL Server Analytic Functions : https://www.youtube.com/playlist?list=PLouAaeZ4xQ64hTsEdhLsVBquE1vERWngX Constraints define rules regarding the values allowed in columns and are the standard mechanism for enforcing integrity. A constraint is usually associated with a table and is created with a CREATE CONSTRAINT or CREATE ASSERTION SQL statement. They define certain properties that data in a database must comply with. They can apply to a column, a whole table, more than one table or an entire schema. Here 6 types of Constraints available in SQL Server a) Not Null b) Default c) Check d) Unique e) Primary Key f) Foreign Key Explained in Tamil
Views: 1702 IT Port
Static Cursors in SQL Server
 
09:08
Click here to Subscribe to IT PORT Channel : https://www.youtube.com/channel/UCMjmoppveJ3mwspLKXYbVlg The complete result set of a static cursor is built in tempdb when the cursor is opened. A static cursor always displays the result set as it was when the cursor was opened. The cursor does not reflect any changes made in the database that affect either the membership of the result set or changes to the values in the columns of the rows that make up the result set. A static cursor does not display new rows inserted in the database after the cursor was opened, even if they match the search conditions of the cursor SELECT statement. If rows making up the result set are updated by other users, the new data values are not displayed in the static cursor. The static cursor displays rows deleted from the database after the cursor was opened. No UPDATE, INSERT, or DELETE operations are reflected in a static cursor (unless the cursor is closed and reopened), not even modifications made using the same connection that opened the cursor. SQL Server static cursors are always read-only. Because the result set of a static cursor is stored in a work table in tempdb, the size of the rows in the result set cannot exceed the maximum row size for a SQL Server table
Views: 452 IT Port
Introduction to SQL Server - Part 1 - Tamil
 
04:55
Subscribe to IT PORT : https://www.youtube.com/c/itport28 SQL Server Tutorial in Tamil : https://www.youtube.com/playlist?list=PLouAaeZ4xQ64enJDwWVvN3KduuZRlUrb3 SQL Server Concepts in Tamil : https://www.youtube.com/playlist?list=PLouAaeZ4xQ67kdNIByJKAGBIBhor_h4Hs SQL Server Analytic Functions in Tamil : https://www.youtube.com/playlist?list=PLouAaeZ4xQ65XIU5azEUgLVrBKEl-jWMV SQL Server Tutorial : https://www.youtube.com/playlist?list=PLouAaeZ4xQ66AYrzPtxt2SeeR4UABcBcO SQL Server Concepts : https://www.youtube.com/playlist?list=PLouAaeZ4xQ66zRe8-nDDy-YHY2o0rmbn4 SQL Server Analytic Functions : https://www.youtube.com/playlist?list=PLouAaeZ4xQ64hTsEdhLsVBquE1vERWngX In this video contains Introduction to SQL server for SQL Server Tutorials SQL Server 2014 Evaluation Edition - https://www.microsoft.com/en-in/evalcenter/evaluate-sql-server-2014-sp2 SQL Server 2014 Express Edition - https://www.microsoft.com/en-in/download/details.aspx?id=42299 SQL Server 2014 installation Step - https://social.technet.microsoft.com/wiki/contents/articles/23878.installing-sql-server-2014-step-by-step-tutorial.aspx
Views: 2264 IT Port
Show - Statistics in SQL Server - Part 2
 
11:04
Click here to Subscribe to IT PORT Channel : https://www.youtube.com/channel/UCMjmoppveJ3mwspLKXYbVlg DBCC SHOW_STATISTICS displays current query optimization statistics for a table or indexed view. The query optimizer uses statistics to estimate the cardinality or number of rows in the query result, which enables the query optimizer to create a high quality query plan. For example, the query optimizer could use cardinality estimates to choose the index seek operator instead of the index scan operator in the query plan, improving query performance by avoiding a resource-intensive index scan. DBCC SHOW_STATISTICS displays the header, histogram, and density vector based on data stored in the statistics object
Views: 1045 IT Port
Self Join in SQL Server
 
04:04
Click here to Subscribe to IT PORT Channel : https://www.youtube.com/channel/UCMjmoppveJ3mwspLKXYbVlg A self join is a join of a table to itself. This table appears twice in the FROM clause and is followed by table aliases that qualify column names in the join condition.
Views: 1200 IT Port
Introduction - Statistics in SQL Server - Part 1 Tamil
 
09:26
Click here to Subscribe to IT PORT Channel : https://www.youtube.com/channel/UCMjmoppveJ3mwspLKXYbVlg Statistics refers to the statistical information about the distribution of values in one or more columns of a table or an index. SQL Server Query Optimizer uses statistics to estimate the distribution of values in one or more columns of a table or index views, and the number of rows (called cardinality) to create a high-quality query execution plan. Often statistics are created on a single column but it’s not uncommon to create statistics on multiple columns. Explained in Tamil
Views: 3597 IT Port
Where clause in SQL Server - Part 21 Tamil
 
11:30
Subscribe to IT PORT : https://www.youtube.com/c/itport28 SQL Server Tutorial in Tamil : https://www.youtube.com/playlist?list=PLouAaeZ4xQ64enJDwWVvN3KduuZRlUrb3 SQL Server Concepts in Tamil : https://www.youtube.com/playlist?list=PLouAaeZ4xQ67kdNIByJKAGBIBhor_h4Hs SQL Server Analytic Functions in Tamil : https://www.youtube.com/playlist?list=PLouAaeZ4xQ65XIU5azEUgLVrBKEl-jWMV SQL Server Tutorial : https://www.youtube.com/playlist?list=PLouAaeZ4xQ66AYrzPtxt2SeeR4UABcBcO SQL Server Concepts : https://www.youtube.com/playlist?list=PLouAaeZ4xQ66zRe8-nDDy-YHY2o0rmbn4 SQL Server Analytic Functions : https://www.youtube.com/playlist?list=PLouAaeZ4xQ64hTsEdhLsVBquE1vERWngX WHERE clause is used to specify a condition while fetching the data from a single table or by joining with multiple tables. If the given condition is satisfied, then only it returns a specific value from the table. We should use the WHERE clause to filter the records and fetching only the necessary records. The WHERE clause is not only used in the SELECT statement, but it is also used in the UPDATE, DELETE statement Explained in Tamil
Views: 252 IT Port
List All Dates Between Two Dates in SQL Server
 
07:12
Click here to Subscribe to IT PORT Channel : https://www.youtube.com/channel/UCMjmoppveJ3mwspLKXYbVlg In this video, we used MultiLine table valued function to get All dates between two dates.
Views: 1300 IT Port
ARITHABORT in SQL Server
 
03:36
Click here to Subscribe to IT PORT Channel : https://www.youtube.com/channel/UCMjmoppveJ3mwspLKXYbVlg By default SQL Server will terminate the query when an Arithmetic Overflow Or Divide by zero error occurs during query execution Using this ARITHABORT we can control these termination with Warnings. We can check with these following error Type Arithmetic Overflow Divide by Zero Before this execution we must noted that ANSI_WARNINGS is in OFF
Views: 291 IT Port
Indexed Views in SQL Server Tamil
 
07:36
Click here to Subscribe to IT PORT Channel : https://www.youtube.com/channel/UCMjmoppveJ3mwspLKXYbVlg A Clustered index is the only type of SQL Server index that contains data; the Clustered index on a view contains all the data that makes up the view definition. As soon as you create this clustered index, the View is materialized, meaning SQL server allocates storage space for it.
Views: 787 IT Port
Insert into Table Select From Stored Procedure
 
04:58
Click here to Subscribe to IT PORT Channel : https://www.youtube.com/channel/UCMjmoppveJ3mwspLKXYbVlg Single Insert Statement to Insert data into a table from Stored Procedure
Views: 4898 IT Port
Sequence in SQL Server Tamil
 
07:13
Click here to Subscribe to IT PORT Channel : https://www.youtube.com/channel/UCMjmoppveJ3mwspLKXYbVlg A sequence is a user-defined schema bound object that generates a sequence of numeric values according to the specification with which the sequence was created. The sequence of numeric values is generated in an ascending or descending order at a defined interval and can be configured to restart (cycle) when exhausted. Sequences, unlike identity columns, are not associated with specific tables. Applications refer to a sequence object to retrieve its next value. The relationship between sequences and tables is controlled by the application. User applications can reference a sequence object and coordinate the values across multiple rows and tables.
Views: 320 IT Port
SQL Server Goto Simple Example
 
04:18
Click here to Subscribe to ITPORT Channel : https://www.youtube.com/channel/UCMjmoppveJ3mwspLKXYbVlg SQL Server Goto Simple Example
Views: 344 IT Port
Difference between UNION and UNION ALL in SQL Server Tamil
 
04:24
Click here to Subscribe to IT PORT Channel : https://www.youtube.com/channel/UCMjmoppveJ3mwspLKXYbVlg This operation combines the results of two or more queries into a single result set that includes all the rows that belong to all queries in the union and will ignore any duplicates that exist. Union all also does the same thing but include even the duplicate values.
Views: 360 IT Port
EXISTS Operator in SQL Server Tamil
 
05:05
Click here to Subscribe to IT PORT Channel : https://www.youtube.com/channel/UCMjmoppveJ3mwspLKXYbVlg Specifies a subquery to test for the existence of rows. In this video you can check Exists and Not Exists with Simple Example Explained in Tamil
Views: 384 IT Port
SQL Server Like Clause Tamil
 
05:25
Click here to Subscribe to IT PORT Channel : https://www.youtube.com/channel/UCMjmoppveJ3mwspLKXYbVlg Like Clause in SQL Server Tamil
Views: 257 IT Port
Instead Of Triggers in SQL Server
 
09:20
Click here to Subscribe to IT PORT Channel : https://www.youtube.com/channel/UCMjmoppveJ3mwspLKXYbVlg INSTEAD OF triggers override the standard actions of the triggering statement: an INSERT, UPDATE, or DELETE. An INSTEAD OF trigger can be defined to perform error or value checking on one or more columns, and then perform additional actions before inserting the record
Views: 482 IT Port
When to update - Statistics in SQL Server - Part 4
 
16:08
Click here to Subscribe to IT PORT Channel : https://www.youtube.com/channel/UCMjmoppveJ3mwspLKXYbVlg Updates query optimization statistics on a table or indexed view. By default, the query optimizer already updates statistics as necessary to improve the query plan; in some cases you can improve query performance by using UPDATE STATISTICS or the stored procedure sp_updatestats to update statistics more frequently than the default updates. We can update Statistics by these 3 methods a) Auto_update_statistics b) Update Statistics c) Sp_updatestats
Views: 632 IT Port