#stored-procedures

Bir çok yolu var fakat kestirme bir tane daha var. Önce; Sunucunun "ad hoc distributed queries" özelliğini açmanız gerekiyor. Varsayılan olarak kapalıdır.

USE MikroDB_V15_02 EXEC sp_configure 'show advanced options', 1 RECONFIGURE GO EXEC sp_configure 'ad hoc distributed queries', 1 RECONFIGURE GO

SONRA;

Solution: LINQ-to-SQL vs stored procedures? #answer #fix #development

LINQ-to-SQL vs stored procedures?

I took a look at the “Beginner’s Guide to LINQ” post here on StackOverflow (http://stackoverflow.com/questions/8050/beginners-guide-to-linq), but had a follow-up question:

We’re about to ramp up a new project where nearly all of our database op’s will be fairly simple data retrievals (there’s another segment of the project which already writes the data). Most of…

Solution: Simulating group_concat MySQL function in SQL Server? #programming #it #answer

Simulating group_concat MySQL function in SQL Server?

I’m trying to migrate a MySQL-based app over to Microsoft SQL Server 2005 (not by choice, but that’s life).

In the original app, we used almost entirely ANSI-SQL compliant statements, with one significant exception we used MySQL’s group_concat function fairly frequently.

group_concat, by the way, does this: given a table of, say, employee…

Fixed SQL Server SELECT into existing table #dev #it #asnwer

SQL Server SELECT into existing table

I am trying to select some fields from one table and insert them into an existing table from a stored procedure. Here is what I am trying:

SELECT col1, col2 INTO dbo.TableTwo FROM dbo.TableOne WHERE col3 LIKE @search_key

I think select into is for temporary tables which is why I get an error that dbo.TableTwo already exists.

How can I insert multiple rows…

Fixed What are the pros and cons to keeping SQL in Stored Procs versus Code #dev #it #asnwer

What are the pros and cons to keeping SQL in Stored Procs versus Code

What are the advantages/disadvantages of keeping SQL in your C# source code or in Stored Procs? I’ve been discussing this with a friend on an open source project that we’re working on (C# ASP.NET Forum). At the moment, most of the database access is done by building the SQL inline in C# and calling to the SQL Server DB. So I’m…

Fixed Function vs. Stored Procedure in SQL Server #dev #it #asnwer

Function vs. Stored Procedure in SQL Server

I’ve been learning Functions and Stored Procedure for quite a while but I don’t know why and when I should use a function or a stored procedure. They look same to me, maybe because I am kinda newbie about that.

Can some one tell me why?

Answer: Function vs. Stored Procedure in SQL Server

Functions can be used in a select statement where as procedures…

Fixed Select columns from result set of stored procedure #dev #it #asnwer

Select columns from result set of stored procedure

I have a stored procedure that returns 80 columns, and 300 rows. I want to write a select that gets 2 of those columns. Something like

SELECT col1, col2 FROM EXEC MyStoredProc 'param1', 'param2'

When I used the above syntax I get the error “Invalid Column Name”.

I know the easiest solution would be to change the stored procedure, but I didn’t…

Fixed Insert results of a Stored Procedure into a Temporary Table #dev #it #asnwer

Insert results of a Stored Procedure into a Temporary Table

How do I do a SELECT * INTO [temp table] FROM [stored procedure]? Not FROM [Table] and without defining [temp table]?

Select all data from BusinessLine into tmpBusLine works fine.

select * into tmpBusLine from BusinessLine

Trying the same, but using a stored procedure that returns data, is not quite the same.

select * into tmpBusLine…