Skip to content Skip to sidebar Skip to footer
Showing posts with the label Stored Procedures

Sql Group By Acting Like Facebook Messaging (mssql Sp)

im trying to group messages like conversations, user1 is @user (logged in user) UserName, UserFu… Read more Sql Group By Acting Like Facebook Messaging (mssql Sp)

How To Return Multiple Rows From Oracle Stored Procedure From Multiple Cursors?

I need to have stored procedure where I can run multiple cursors. Loop over each cursor and then d… Read more How To Return Multiple Rows From Oracle Stored Procedure From Multiple Cursors?

How To Create A Sql Function Which Splits Comma Separated Value?

I want to create a function in SQL Server which takes a comma separated string a parameter, splits … Read more How To Create A Sql Function Which Splits Comma Separated Value?

Calling A Stored Procedure With Null Parameters And Sqldataadapter

I have a stored procedure which I cann from my C# code. I am passing some parameters which I put in… Read more Calling A Stored Procedure With Null Parameters And Sqldataadapter

Tsql Maxrecursion On A Cte

I get this error: The maximum recursion 100 has been exhausted before statement completion when… Read more Tsql Maxrecursion On A Cte

Sql Output Parameters In C#

I'm trying to get a value from Microsoft SQL Server stored procedure. Totally I need to return … Read more Sql Output Parameters In C#