Topics
Started by
Posts
Last post
Hello All this query doesnot work. column employeeid has datatype char () declare @ab varchar (1…
3 replies
I took Seth's advice and visited the link on how to post data. Please see below. I hope I've done i…
14 replies
select * from sysobjects WHERE object_id = OBJECT_ID(N'[dbo].SP_anything]') ... is used to find a…
5 replies
hi , i have atble named emp which contains an index on empno and a constraint on address columns. w…
2 replies
Hi, I want to update a record, if the record count of another table equal to 1. How can i achi…
4 replies
Can i create a store proc where it does 44 alter column commands and add column cmd. As i had bad e…
1 replies
Everyone, we have an important legacy lob attribute that stores well formed and also malformed xml…
9 replies
hi all, i am an experienced developer who has done a lot of application side programming (C++/Java/…
7 replies
Hi all, I have two tables with one to many relationship. Can i get the line table data separated by…
9 replies
Please help me with this query. Sample data: create table #BeforeTraining (ID int identity, SalePe…
6 replies
Hi, I have a trigger on Update of Field1 and I would like to find out the value of Field2 for the U…
4 replies
how would i decode this in tsql select /*+ RULE */ decode(orig.orig_system,null,'ORACLE','UN…
35 replies
Any ideas how to quickly call a stored procedure to insert a record into another table for each rec…
33 replies
i've written a simple IF statement, have a look at the following code snippet... DECLARE @Result D…
1 replies
Hi all, I have a table I need to update based on certain criteria. Please see example data below; R…
5 replies
Viewing 15 topics - 8,416 through 8,430 (of 12,230 total)
You must be logged in to create new topics.