I recently switched from sql server 2005 to sql server 2008. A while ago when I tried to change a table column, i encountered an error not allowing me to save the changes. After some time of googling I found… Read more ›
A while ago I ran into a scenario where I had to pass null values to the stored procedures in SQL database. I tried to pass null values by using Nullable int variables. However that would return the error saying… Read more ›
Here is a simple way to merge multiple rows into a single row using SQL coleasce DECLARE @compositestr VARCHAR(100) select @compositestr=COALESCE(@str+’/', ”) + cast(MenuID as varchar(20)) from Items where ID=1 select ISNULL(@compositestr,0) AS ItemsMerged The result before merge looked like… Read more ›
