Can you tell me what is the need for a stored procedure when there 开发者_开发知识库is UDF?Off the top of my head, a stored procedure can do the following that a UDF cannot do:
I have a table in production with 12 columns for each month. I need to create a SP where I pass in a productID, Custome开发者_Python百科r and Month parameter and retrieve the sum of that month.
If I run a stored procedure in my database (SQL 2000) and return the SCOPE_IDENTITY, I receive a v开发者_Python百科alue. However, using LINQ to SQL, I get a null value for the Column1 property. Anyone
How to replace text in sql server 2000 i开发者_如何学Pythonn a ntext column with more than 4000 characters? conversion to nvarchar(max) does not work as it truncates values.Working with TEXT/NTEXT is
My ERP database uses non-nullable datetime fields. However, it enters \'\' for the datetime when one isn\'t available and returns ‘1900-01-01 00: 00: 00.000’ as the value.
I have run into a strange problem using SQL Server 2000 and two linked server. For two years now our solution has run without a hitch, but suddenly yesterday a query synchronizing data from one of the
We want to remove tons of obsolete data in a table, but this will lock table for a long while. I开发者_运维知识库s is possible to use Cursor to delete, says, one hundred records per transaction in a w
hi i have the following table P_idFnameLname 1vaibhav开发者_运维问答 shukla 2davaleshbarak 2sumobarath
What I need to do is, put the results of stored procedure (with lots of parameters) in to a table. Something like that:
I\'m having some problem safely casting a varchar to int on SQL2000. Part 1 of my problem was that IsNumeric returns开发者_如何学编程 false positives if your looking for integers only. I\'m aware tho
加载中,请稍侯......