Topics
Started by
Posts
Last post
Hi all, I am using sql server 2000. I have two table like t1 and t2. Iam using the trigger fo…
2 replies
I have currently created a stored procedure that inserts data into a truncated table. However when …
3 replies
Hi I have data as below (with 30,000 different items) and whilst I do not yet have 12 months of wee…
10 replies
Hello all, I have to drop one temp table (#tmptbl) in SP, with if exists. That means if that temp t…
2 replies
reate table temp (id int identity(1,1),Sum1 int) INSERT INTO TEMP(Sum1) select 10 INSERT INTO TEMP(…
11 replies
I have a data as ParentID ChildID 1 2 1 3 1 4 2 5 3…
6 replies
I have a frequent need to copy a list of items from MS Word 2002 into a SQL Query Analyzer window.&…
12 replies
Hi All, Is there any query to know if what are the indexes on a table and whether the indexes are c…
5 replies
Hi dear all, If I give one date like '2008-03-04' i need the result next month last day or date
16 replies
I want to do the T-SQL equivalent of Iif(Instr([SKU],"EC") > 0, "EC", Iif(Instr([SKU],"DD") >…
2 replies
I have Stored procedure and after running it i am getting different results as when i run from Quer…
9 replies
I've got a table like this EntityID | Property | Value | from…
4 replies
Hi all, I have tables Chapters, questions and answers for online exams. Chapter table contain 10 …
3 replies
Dear Experts, I had sent one scenario. Ex: select * from dating Value date ---------------- 2007/…
33 replies
I'm running a stored procedure, and when it finishes I get the fatal exception error in the subject…
8 replies
Viewing 15 topics - 1,876 through 1,890 (of 17,082 total)
You must be logged in to create new topics.