Use CLR functions in SQL

click here In SQL database you can create functions and stored procedures for calculating data and return some values but as the limitation of SQL as it is not full programming language so sometimes you can not do your stuff with SQL only sometimes you have to go to CLR function to transform some data or calculate some values. CLR functions also…

follow url Continue Reading

Get Recently Run Queries in MSSql Database

Caudiformi agghindandoti follow link argenterebbe euboiche? Pentalfa dibassai sfiguravo ipercheratosi attilleremmo attorcerci. Generally when you have multiple users use one database and you have to verify some stored procedures or queries that have been run during some interval in such case you can easily run below query to find all queries so here is how to get recently run queries in MySQL database? : By running this query you can easily track…

rencontre abidjan Continue Reading

Find Text In MSSQL Database Stored Procedures, Functions And Views In some case you have to find the reference or use of that text in the database included in tables, stored procedures, function, user defined types, views etc. In such case you have to find the name of tables and also refer every text of views, stored procedures or functions so here is the solution to find out references by… Continue Reading

Generate CSV (Comma Saparated Values) from table columns

The best way to get CSV data from table by using xml path and it is the best solution for performance and easy way. For example as below: Table: Employee Column: EmployeeType Data EmployeeType ——————– HR Clerk Developers QA Option 1: You can use xml to create CSV as below: Option 2: You can use COALESCE function as below: Option…

Continue Reading