Recursive function in sql server 2005?
Can anybody suggest programming examples that illustrate recursive functions? For example fibonacci series or factorial.. ...
sql-server-2005
Why Does SQL Update Top apparently reduce locking even when no records are updated?
I have a question about why some SQL (running on SQL Server 2005) is behaving the way it is. Specifically, I made a change to reduce lock contention during an update and it seems to be working in cases I didn't think it would. Original code: We had an update statement like this, that was being applied to a table with more than 3,000,0...
How to run Django on Windows and cope with Apache not having a daemon mode?
Evolution of this question This started as an attempt to find other recommendations for running Django on Linux, accessing SQL Server via Django-PyODBC, and supporting Unicode as competently as in installations running Django on Windows. After failing to materialize with a good solution for ODBC drivers in Linux that would provide the ...
How to determine why a distributed transaction is timing out
I am using LINQ to SQL and a third party SDK that supports distributed transactions. When I realize that a pending update will be updating both SQL records and records in the third party SDK, I am creating a TransactionScope with a 0 (presumably infinite) timeout (although I've also tried 12 hours as a timespan parameter). Then I use G...
Ideablade Update
Hi, I'm using IdeaBlade version 3.6. I noticed the following generated SQL update query : (@P1 nchar(32),@P2 nvarchar(32),@P3 nvarchar(512),@P4 nchar(32),@P5 int,@P6 nvarchar(32),@P7 int,@P8 datetime,@P9 datetime,@P10 datetime,@P11 int,@P12 datetime,@P13 int,@P14 int,@P15 int,@P16 nvarchar(32),@P17 nvarchar(128),@P18 nvarchar(32),@P...
Trunc(sysdate) in SQL Server
What is the equivalent of: TRUNC(SYSDATE) ...in SQL Server 2005? ...
upgrading tfs 2008 sp1 to use sql server 2008
I have an instance of tfs 2008 supported by sql server 2005. I want to change the sql server machine by doing a restore based move. I also want to change the version of sql server to 2008. I know that i can restore backups from sql 2005 to sql 2008, IN GENERAL, but I don't know if this is a thing that is OK for tfs databases. I also k...
is it good to use check constraints for business rules
Currently we are using check constraints for business rules implementation, but I want to know should we implement business rules in sql or Business logic(c# code) layer. I have searched on the net and finds that check constraints are good to use. please let me know if somebody knows more int detailed abt it. One more thing is that data ...
SQL Server: pause a trigger
I am working with SQL Server 2005 and I have trigger on a table that will copy an deletions into another table. I cannot remove this trigger completely. My problem is that we have now developed an archiving strategy for this table. I need a way of "pausing" a trigger when the stored proc that does the archiving runs. ...
SQL Server 2005, Caches and all that jazz
Hi all Background to question: I'm looking to implement a caching system for my website. Currently we're exploring memcache as a means of doing this. However, I am looking to see if something similar exists for SQL Server. I understand that MySQL has query cache which although is not distributed works as a sort of 'stop gap' measure. Is...
Raiserror in procedure (SQL Server 2005) is not caught in update process in client side(c#)
Hi all, I am using stored procedure with RAISERROR. The error raised by the SP is not caught by the try catch statement in c#.Net. I'm using SqlDataSource for SQL connection and SqlDataSource_Updating event to update the data. SQL Code: DECLARE @count int @count=0 if(@count = 0) begin RAISERROR('Updation failed. record alread...
Roles vs Schema
I want to give different level of access on tables to different users based on their department. Should I use Schema or Roles for this purpose. Any Insights! ...
sql 2005 join results
HI, Using Microsoft SQL Server 2005: I have a table "test": id, link_id, name 1 11 test1 2 11 test2 3 11 test3 4 12 test4 Is there a way to query this, and return the results grouped by "link_id", with the names joined? EG, SELECT link_id, name FROM test WHERE ??????? results: link_id, ...
Is there a SVN plugin for SQL Server Management Studio 2005 or 2008?
Looking for a "Source Control" plugin to integrate SSMS with Subversion/SVN. Anyone know of one? ...
How do I share an image between projects in Microsoft SQL Server Reporting Services 2005?
I have a SQL Server 2005 Reporting Services solution containing several reporting projects. (I need separate reporting projects so that I can deploy reports to the correct folders on the report server.) We want to include our company's logo in the header of each report. I don't want to bake the logo image into each report ("embedded")...
How can I share a Data Source between multiple projects in Microsoft SQL Server 2005 Reporting Services and keep Visual Studio "Preview"?
I have a solution that contains multiple reporting projects (one per target deployment folder - I think this is the only way to achieve this effect, at least until I abandon Visual Studio for report deployment). I want to specify my data source information "once and only once" for all these reports. So far, I have created a separate re...
SEARCH several Tables IN SQL
I'm trying to search several tables at once for a search term. My query is: SELECT item.ItemID FROM Inventory.Item item JOIN Inventory.Category catR // each item can be in several categories ON catR.ItemID = item.ItemID JOIN Category.Category cat ON cat.CategoryID = catR.CategoryID ...
Inserting Randomly Selected Records SQL
I'm using Microsoft SQL Server 2005. I'm creating a random record generator that will insert 10 records randomly into a temporary table. The records in the temporary table will then be used to update records in the table in memory. Here is the statement that is giving me some troubles (assume the temp table is already created). i...
Inconsistent Generate Change Script
I add a column of type tinyint and being set to not allow nulls in a table and generate the change scripts. The table has data in it at this time. The script has code that creates a temp table and inserts the data that is in the current table into. It then deletes the old table and renames this temp table to the same name as the origi...
Creating multiple stored procedures from SQL executed by powershell issue
Ok, so I've got a bit of a SQL and Powershell problem. There are 2 SQL scripts, one to setup 4 different global stored procedures. Another to execute them and manipulate data before returning it to PS to be placed in a CSV file. The reason I'm not putting them into a single file is for readability. The procs are enclosing huge chunks of ...