By tag: T-SQL
0
kicks
Know COUNT of bit column using Group by in T-SQL
Here is a scenario most of the times we use and look for. I have a bit column in database table and want to filter the count of true count and false count by applying Group By on it. For example, below is the simple scenario I came up with to better present you.
We are storing employee details in...
0
kicks
Best Split UDF function with delimeter in T-SQL to return result as a
This is what the function I am using since many years to get the table of values in the given ID's which are separated by some delimiter.
Simple to understand and see the example in the comments in below function.
From the UI there are sometimes need of sending the data or ID's in the string for...
0
kicks
Some thoughts on Stored Procedure
I read Paul Nielsen post on stored procedure. According to him stored procedures are good for application. He is not only talking about logical or business process stored procedure, but he also encouraged to developer for CRUD stored procedures. I think, it is good idea. There is no harm to use them...
0
kicks
fn_virtualfilestats: Measure the I/O load on your disk system
Microsoft included the fn_virtualfilestats function in SQL Server so you can monitor the I/O load the instance executes on the disk subsystem.
0
kicks
Select top n rows from a table for each group
Suppose you want to get the top two products from each manufacturer which have the best promotional price
0
kicks
Transact-SQL to get Column Description in Sql Server 2005
Transact-SQL to get the description property of the column in sql server 2005 using fn_listextendedproperty
0
kicks
How to Compare / Test the Equality of two Queries in SQL Server
Compare / Test the Equality of two Queries in SQL Server using this short T-SQL
0
kicks
Whats up with Stored Procedures these days?
When life throws you hard balls, you can either step back and take a swing or bunt the hell out of it. I just recently went to an information session on T-SQL, Stored Procedures and now LINQ. These folks discussed stored procedures and why they are so important in the world today.
0
kicks
Using CROSS JOIN to generate test data
In this blog, Joe demonstrates the power of the CROSS JOIN and how it can be harnessed to create lots of test data very quickly.
0
kicks
The Oncoming Microsoft ASP.NET MVC with Some LINQ Tossed In - Part 2
In the <a href="http://adronbhall.com/blogs/technology__software_development/archive/2007/12/25/6062.aspx" target="_blank">first part of this series</a> I went over how to create a basic skeleton of controllers and models so that we could create a mock test and get it...
0
kicks
Find all tables, which includes specific column name
2 SQL queries how to find tables, which includes column name via using in system tables of SQL Server 2005.
0
kicks
SQL Server error messages
Ever needed to find the text associated with an error number in SQL Server? This blog shows you how to retrieve it from SQL Server's metadata using T-SQL.
0
kicks
ZIP or Address Radius Search Function for SQL Server 2000
SQL Server 2000/2005 function to calculate distance in miles between 2 latitude/longitude points for zip or address proximity search, etc.
0
kicks
InnerWorkings tackles Transact-SQL for developers
We help developers learn to code fundamental Transact-SQL activities such as making queries, sorting and filtering, and using table joins. Delve into control-of-flow language and using functions to manipulate data. Hands-on, practice-based, just for developers looking to learn T-SQL.