SQL SERVER Archives - Vinay Patel

Decrypt an Encrypted Object in SQL Server

by Vinay Patel | Sep 29, 2013 | SQL Server | 0 |

After long enough , I found something interesting .. Decrypting existing encrypted objects of SQL...

Sending Emails with CLR + SQL Server Express Editions

by Vinay Patel | Sep 17, 2012 | C#, SQL Server | 18 |

Recently , we need to send notification emails to customer from SQL Epress 2012 Database – but the latest SQL Server Express editions got deprecated send email from SQL server Little search around turns into great help...

ROW_NUMBER() in LINQ 2 SQL

by Vinay Patel | Jul 21, 2012 | C#, LINQ, SQL Server | 4 |

Last week was quite simple and went without trouble , and just before I start enjoying my weekends – stuck in to in issue of getting ROW_NUMBER() (as we are doing in sandard SQL Query ! Finally come-up with sort and sweet...

Drop all objects of SQL Server Database

by Vinay Patel | Sep 23, 2011 | SQL Server | 0 |

Recently on my shared hosting server I need to delete all the tables and starts from scratch , I got a ready-made script on Internet page. declare @n char(1) set @n = char(10) declare @stmt nvarchar(max) -- procedures select...