Sql Server : A Sql cursor is a database object that is used to retrieve data / loop over the bunch of a result set/tuples each row at a time. A SQL cursor is used when we have to manipulate data in each row Or specific row based on some condition(s) and its not feasible by a simple/single TSQL querySQL Ser...
Sql Server : A database object known as a "stored procedure" houses pre-written queries (a group of T-SQL Statements).In other words, a stored procedure is a section of code that is created to run whenever it is invoked. In SQL Server, you can create a stored procedure by using the CREATE PROCEDURE or CREATE PRO...
Sql Server : SQL provide CHARINDEX() function Or LIKE Predicate to check if the string contains a specific substringMethod 1 - Using CHARINDEX() functionused to find a certain word or substring within a larger text and returns the first match it found.It will return 0 if no words are detected (zero). CHARI...
Sql Server : This article gives an overview of FOR XML PATH clause to get data in XML format with various examplesFOR XML clause can use to convert existing data to XML format. It can also be used to join or concatenate multiple columns into a single row. FOR XML Clause has below 4 Modes, that decide the shape o...
Sql Server : SQL Server has a bunch of functions that return the current date/time. 1. GETDATE() returns a datetime value.is the T-SQL version of that same function. 2. SYSDATETIME() returns a dateti...
