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: 6165 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: 5096 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: 1641 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: 1947 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: 6902 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: 2873 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: 4396 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: 1594 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: 2467 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: 2299 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: 461 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: 3703 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: 2840 IT Port
Having clause in SQL Server - Part 24 Tamil
 
07:56
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 HAVING Clause is used to Specifies a search condition for a group or an aggregate. HAVING can be used only with the SELECT statement. HAVING is typically used in a GROUP BY clause. When GROUP BY is not used, HAVING behaves like a WHERE clause. Explained in Tamil
Views: 710 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: 584 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: 1277 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: 1509 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: 5473 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: 351 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: 1730 IT Port
SQL Server Isnull and Nullif Tamil
 
04:30
Click here to Subscribe to IT PORT Channel : https://www.youtube.com/channel/UCMjmoppveJ3mwspLKXYbVlg SQL Server Isnull and Nullif Function example in Tamil
Views: 342 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: 775 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: 674 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: 2794 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: 2470 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: 2459 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: 1748 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: 597 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: 1179 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: 913 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: 6540 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: 505 IT Port
SQL Server Case Statement Tamil
 
04:55
Click here to Subscribe to IT PORT Channel : https://www.youtube.com/channel/UCMjmoppveJ3mwspLKXYbVlg SQL Server Case Statement with Example in Tamil
Views: 379 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: 6882 IT Port
Temporary Stored Procedures in SQL Server
 
07:02
Click here to Subscribe to IT PORT Channel : https://www.youtube.com/channel/UCMjmoppveJ3mwspLKXYbVlg Temporary stored procedures are like normal stored procedures but, as their name suggests, have fleeting existence. There are two kinds of temporary stored procedures LOCAL and GLOBAL LOCAL temporary Stored procedures are Starts with # and Stored in TempDB and Available only in Current Session and dropped when session is closed. GLOBAL temporary Stored procedures are Starts with ## and Stored in TempDB and Available for all Sessions and dropped when Creator session is closed.
Views: 129 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: 292 IT Port
Maintenance Plan for Update Statistics Task in SQL Server
 
06:47
Click here to Subscribe to IT PORT Channel : https://www.youtube.com/channel/UCMjmoppveJ3mwspLKXYbVlg If your queries are executing slower, then it is time to update the statistics. It is recommended to update your statistics after you insert a larger amount of data into ascending or descending key columns because in such cases the statistics histogram might not have any information about the newly inserted values. This task is used to update SQL Server information about the data in the tables and indexes. This task resamples the distribution statistics of each index created on user tables in the database. The distribution statistics are used by SQL Server to optimize navigation through tables during the processing of Transact-SQL statements. To build the distribution statistics automatically, SQL Server periodically samples the data in the corresponding table for each index.This size of the sample is based on the number of rows in the table and the frequency of data modification. Use this option to perform an additional sampling using the specified percentage of data in the tables. SQL Server uses this information to create better query plans. This task executes the UPDATE STATISTICS statement.
Views: 1151 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: 6257 IT Port
How to Hide Stored Procedure Code in SQL Server Tamil
 
02:56
Click here to Subscribe to IT PORT Channel : https://www.youtube.com/channel/UCMjmoppveJ3mwspLKXYbVlg Hide SQL Statements in Stored Procedure from SP_Helptext
Views: 215 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: 416 IT Port
Temporary Stored Procedures in SQL Server Tamil
 
06:41
Click here to Subscribe to IT PORT Channel : https://www.youtube.com/channel/UCMjmoppveJ3mwspLKXYbVlg Temporary stored procedures are like normal stored procedures but, as their name suggests, have fleeting existence. There are two kinds of temporary stored procedures LOCAL and GLOBAL LOCAL temporary Stored procedures are Starts with # and Stored in TempDB and Available only in Current Session and dropped when session is closed. GLOBAL temporary Stored procedures are Starts with ## and Stored in TempDB and Available for all Sessions and dropped when Creator session is closed. Explained in Tamil
Views: 260 IT Port
SQL Server Try Catch Tamil
 
04:51
Click here to Subscribe to IT PORT Channel : https://www.youtube.com/channel/UCMjmoppveJ3mwspLKXYbVlg SQL Server Exception Handling in Tamil
Views: 330 IT Port
SQL Server Cast and Convert Functions
 
06:58
Click here to Subscribe to IT PORT Channel : https://www.youtube.com/channel/UCMjmoppveJ3mwspLKXYbVlg SQL Server Convert One datatype data to another datatype using these functions with example
Views: 1356 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: 348 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: 979 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: 3326 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: 401 IT Port
Rows Unbounded Preceding, Following in SQL Server Tamil
 
10:24
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 Explained in Tamil
Views: 299 IT Port
QUOTED_IDENTIFIER in SQL Server
 
04:53
Click here to Subscribe to IT PORT Channel : https://www.youtube.com/channel/UCMjmoppveJ3mwspLKXYbVlg Causes SQL Server to follow the ISO rules regarding quotation mark delimiting identifiers and literal strings. Identifiers delimited by double quotation marks can be either Transact-SQL reserved keywords or can contain characters not generally allowed by the Transact-SQL syntax rules for identifiers.
Views: 1703 IT Port
WAITFOR DELAY | TIME in SQL Server
 
07:24
Click here to Subscribe to IT PORT Channel : https://www.youtube.com/channel/UCMjmoppveJ3mwspLKXYbVlg Blocks the execution of a batch, stored procedure, or transaction until a specified time or time interval is reached, or a specified statement modifies or returns at least one row. While executing the WAITFOR statement, the transaction is running and no other requests can run under the same transaction. The actual time delay may vary from the time specified in time_to_pass, time_to_execute, or timeout and depends on the activity level of the server. The time counter starts when the thread associated with the WAITFOR statement is scheduled. If the server is busy, the thread may not be immediately scheduled; therefore, the time delay may be longer than the specified time.
Views: 443 IT Port