Topics
Started by
Posts
Last post
I would like to implement Oracle "FOR UPDATE" row level concept on SQL Server 2005. I tried using t…
13 replies
I am cleaning up a number of stored procedures and have come accross quite a few with the following…
6 replies
I am trying to write some link server based SPs and at one step I am checking if the link server ex…
4 replies
Hi i picked few lines from below link Now “IS NULL” is a little trickier and is the preferred me…
2 replies
Hi everyone, We have seen recently (and in the past) error messages from SQL Server having this for…
4 replies
Hi all, I have a small problem for witch i cannot see the solution.. I thought it would not be so h…
6 replies
Hello all site members , I have a table with 100K + records and consisting of 4 columns.website_nam…
2 replies
Hi All, I want list of tables having self join in an database. Please help me out to resolve it Th…
5 replies
Friends, please provide me if anybody having script for deadlock. send mail alerts on blocking so w…
1 replies
I have a table. It has only one column and more that 100,000 rows. Data type is VARCHAR(50). I need…
2 replies
Hi All, alter PROCEDURE MonthlyDepreciation ( @Classification int ) AS BEGIN Declare @Query varchar…
3 replies
What are you guys & gals thoughst about someone using a DATA TYPE like TEXT or INT as the anme…
2 replies
Hi All, I have simple SP in SQL2005, which produces to results tables (please see attached) Is it p…
5 replies
Dear Experts, At the moment of insert data into a table using a certain program I would like to che…
2 replies
Hi All, i want to modify an data of xml data type,so i am using DECLARE @xml XML SET @xml = '<r…
1 replies
Viewing 15 topics - 991 through 1,005 (of 4,155 total)
You must be logged in to create new topics.