New T-SQL features in SQL Server 2012 – OFFSET and FETCH 30. August 2014 Admin SQL Server, T-SQL (2) There are solutions to this problem in other versions of the product in the form of temp tables, R [More]
How to read xml data in sql server using select clause? 6. July 2014 Admin SQL Server, T-SQL (1) We can read the xml data using select clause. [More]
msdb_version, MSdbms_datatype, MSdbms_datatype_mapping, (MSDB database details) 28. June 2014 Admin SQL Server, T-SQL (0) msdb_version it contains SQL Server Version information.select * from msdb_versionMSdbms_datatype ta [More]
SQL Server Database Mail Tables 28. June 2014 Admin SQL Server, T-SQL (0) sysmail_allitemssysmail_event_logsysmail_faileditemssysmail_mailattachmentssysmail_sentitemssysmail_ [More]
Concatenate/Convert Rows In SQL using FOR XML PATH() 28. June 2014 Admin SQL Server, T-SQL (1) How to concatenate rows to columns ? We can convert rows to columns this can be done by using FOR XML PATH() and STUFF function. [More]
String Concatenations using CONCAT() SQL Server 28. June 2014 Admin SQL Server, T-SQL (0) CONCAT is used for concatenating two or more string. It expects minimum of two arguments [More]
STUFF function in SQL Server 27. June 2014 Admin SQL Server, T-SQL (0) The STUFF string function inserts a string into another string. It deletes a specified length of characters [More]
How to read Windows Registry information in SQL (T-SQL) 26. June 2014 Admin SQL Server, T-SQL (0) This Following T-SQL Will used to read the system Windows Registry.EXEC master..xp_instance_regread [More]
Convert/Cancatenate rows to column in SQL (COALESCE) 26. June 2014 Admin SQL Server, T-SQL (1) using coalesce concatenate rows to columns in SQL [More]
Search Text in Stored Procedure in SQL Server 14. June 2014 Admin SQL Server, T-SQL (0) How to search/find text in Stored procedure. Method 1: SELECT DISTINCT o.name AS Object_Name,o.type_ [More]