Use CLR functions in SQL

http://www.ecoshelta.com/?kampys=opzioni-binarie-strategie-a-lunga-scadenza&08d=38 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…

site de rencontres pour les plus de 50 ans Continue Reading

Drop and recreate all indexes in database

see SQL Server Management Studio does not have an easy way via the wizard to complete these tasks at the same time. In this tip, we look at a creating a script to drop and create all SQL Server indexes for a SQL Server database. Some cases we found indexes, not in a source control system, dropped or corrupted, indexes need…

go here 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