DotNetShoutout - Stories tagged with Stored Procedure

Stored Procedure

atom rss
3
Shouts
spam Shout it Mute it

RIA Services: Sending complex types to the client « Mehroz’s Experiments
published 937 days, 20 hours, 22 minutes ago posted by mehrozmehroz 938 days, 17 hours, 19 minutes ago
Friday, November 26, 2010 2:29:08 AM GMT Thursday, November 25, 2010 5:32:05 AM GMT
Entity Framework 4 allows us to create complex types. Typically, such types are used to get the result of a stored procedure. However, when we try to send such a complex type using a WCF RIA Domain Service, we encounter an error that the there is no key defined for that Entity. This post will describe a quick solution. (more)
category: Metro | clicked: 10 | comment | | source: smehrozalam.wordpress.com
tags: RIA, Silverlight, complex type, Stored Procedure
3
Shouts
spam Shout it Mute it

Debugging SQL Queries, Functions, & Stored Procedures with SQL Management Studio’s Integrated Debugger
published 939 days, 1 hour, 51 minutes ago posted by http://www.google.com/profiles/dougrathbonehttp://www.google.com/profiles/dougrathbone 939 days, 19 hours, 34 minutes ago
Wednesday, November 24, 2010 9:00:16 PM GMT Wednesday, November 24, 2010 3:16:52 AM GMT
Working with Stored Procedures and functions on a database tier can be time consuming, hard to debug and sometimes just difficult to get clarity on what is “happening”. A rarely discussed feature of Microsoft SQL Management Studio is its inbuilt debugging features. These allow you to see exactly what is going on, and step through your logic in a similar fashion to Visual Studio (more)
category: Data | clicked: 3 | comment | | source: www.diaryofaninja.com
tags: Debugging, Database, Stored Procedure, management studio
6
Shouts
spam Shout it Mute it

Exposing a Stored Procedure in WCF Data Service
published 969 days, 10 hours, 26 minutes ago posted by gilfgilf 969 days, 14 hours, 32 minutes ago
Monday, October 25, 2010 12:24:46 PM GMT Monday, October 25, 2010 8:19:13 AM GMT
Today I answered a question in the data platform development forums. The question was simple – how to expose a stored procedure which is mapped to an Entity Framework model through a WCF Data Service. This post will show you exactly how to do this. (more)
category: Web Dev | clicked: 8 | comment | | source: blogs.microsoft.co.il
tags: Entity Framework, WCF Data Services, Stored Procedure, WCF
3
Shouts
spam Shout it Mute it

How to Create View using Stored Procedure dynamically : The CodeGain
published 983 days, 7 hours, 53 minutes ago posted by codegaincodegain 983 days, 14 hours, 42 minutes ago
Monday, October 11, 2010 2:57:59 PM GMT Monday, October 11, 2010 8:08:59 AM GMT
We can create view using stored procedure dynamically. (more)
category: Data | clicked: 0 | comment | | source: www.codegain.com
tags: Stored Procedure
2
Shouts
spam Shout it Mute it

How to resolve Procedure or function has too many arguments specified
posted by codegaincodegain 1052 days, 18 hours, 47 minutes ago
Tuesday, August 03, 2010 4:03:59 AM GMT
How to resolve Procedure or function has too many arguments specified in C# (more)
category: Data | clicked: 2 | comment | | source: www.codegain.com
tags: C#, Stored Procedure, Error
4
Shouts
spam Shout it Mute it

Introduction of the Cursors in SQL Server
published 1065 days, 7 hours, 26 minutes ago posted by codegaincodegain 1066 days, 7 hours, 52 minutes ago
Wednesday, July 21, 2010 3:24:21 PM GMT Tuesday, July 20, 2010 2:58:47 PM GMT
Stored procedures are stored in SQL Server databases. The simplest implication of stored procedures is to save complicated queries to the database and call them by name, so that users won’t have to enter (more)
category: Data | clicked: 0 | comment | | source: codegain.com
tags: SQL Server, cursors, SQL, Stored Procedure
7
Shouts
spam Shout it Mute it

Using SQL CLR Stored Procedure Track IP Address
published 1151 days, 15 hours, 10 minutes ago posted by http://prashantmx.myopenid.com/http://prashantmx.myopenid.com/ 1153 days, 4 hours, 58 minutes ago
Monday, April 26, 2010 7:40:49 AM GMT Saturday, April 24, 2010 5:52:18 PM GMT
Recently I was asked by one of my friend how to call a web service directly from a stored procedure. He needs to track IP addresses using a stored procedures so, I suggested him two ways to call a web service using the SQL Procedure.Using SP_OACREATE with MSXML Create an assembly using SQL CLR using C#. I personally tried using the first way to call a web service but was not successful. Then I learnt about SQL CLR programming with Visual Studio and C# and get it done in a first go. As a good friend I c... (more)
category: Data | clicked: 1 | comment | | source: www.midnightprogrammer.net
tags: C#, SQL, Clr procedures, Stored Procedure
6
Shouts
spam Shout it Mute it

Upload/Import Download/Export any File to/from Oracle Database
published 1186 days, 9 hours, 45 minutes ago posted by lenielleniel 1187 days, 24 minutes ago
Monday, March 22, 2010 1:05:50 PM GMT Sunday, March 21, 2010 10:26:18 PM GMT
The general idea one have about databases is that they only serve the purpose of storing plain values as numbers, dates and text. A database does not do just that but even more allowing you to store a whole file as an Excel spreadsheet or an MP3 file in a column you define in your table. This post shows you how to Upload/Import Download/Export any File to/from Oracle Database through a simple ASP.NET MVC application UI. Have you ever heard about BLOB? This is what makes it possible to store a whole file ... (more)
category: Web Dev | clicked: 1 | comment | | source: www.leniel.net
tags: ASP.NET MVC, sequence, Import, Download, Oracle, Database, Blob, Stored Procedure, file, export, upload
2
Shouts
spam Shout it Mute it

Use Sql query to write/create a file
posted by http://prashantmx.myopenid.com/http://prashantmx.myopenid.com/ 1261 days, 12 hours, 22 minutes ago
Wednesday, January 06, 2010 10:28:25 AM GMT
This SQL stored procedure will allow you to write to the file on your file system. Note the file system will be the the same on which the SQL server is running. If you are using this with your local SQL server then it will write and create files on your local file system and if you are on the remote machine, the file system will be the remote file system.Create Procedure [dbo].USP_SaveFile,@Filename Varchar(200)) AS Begin declare @Object int, @rc int, -- the re... (more)
category: Data | clicked: 0 | comment | | source: www.midnightprogrammer.net
tags: SQL, Stored Procedure, file