Xavier's Blog
Tag

SQL Server

#sql-server

More content

Read more stories on Hashnode

Articles with this tag

Trick to get large data in SQL Management Studio

Aug 23, 20171 min read

If you have a column with long text, you can cast it to XML and get it out. Here is an example where the text is so big that it is also...

Counting Bit (true & false) in SQL

Aug 3, 20151 min read

Here is how to count bit in SQL SELECT Id, count(1) as TotalCount, SUM(CASE WHEN Addressed = 1 THEN 1 ELSE 0 END) as AddressedCount FROM...

Raw SQL with Entity Framework

Aug 1, 20151 min read

Here is how to execute a raw SQL query. Since Entity frame uses reflections, you have to create some nested class so that properties can be bound to...

Entity framework Delete multiple rows using a stored proc

Feb 14, 20153 min read

The quickest way to delete is using a stored procedure. I prefer stored procedures in a database project over dynamic SQL because renames will be...