Topics
Started by
Posts
Last post
Is it possible to run more than one sql statement given a condition ie: if(1 = 1) --insert sta…
2 replies
i need a query that make 'A010' + 1 = 'A011' or 'ABC13456' + 12 = 'ABC13468' how can i do this
10 replies
Hi everyone, I was wondering has anyone competed CURSOR against INNER JOIN for bulk UPDATEs: QUERY …
8 replies
Hello I am running the following 3 seperate queries: USE DB SELECT sum(T_OrderLine.Quantity) AS Sol…
4 replies
Trying to create a stored procedure to call from web page To reset passwords but keeps erroring wit…
3 replies
Hi, I am using following code for data transfer to flat file: declare @sql varchar(8000) select @…
1 replies
To my understanding, an INNER JOIN is symmetric, it should not make any difference which order the …
8 replies
i have a table that broken. there are some rows repeated. How may i delete the repeated rows REFNO…
15 replies
I am trying to generate a dynamic SQL string based on the following: DECLARE@ConsultantIDnVarCha…
4 replies
I have this stored procedure USE [vdb] GO 08/28/2008 10:23:14 ******/SET ANSI_NULLS ON GO SET QUO…
9 replies
Hi there, I'm just a starter with using T-Sql in SQL SERVER. I need to write a query to compare sal…
3 replies
Is there anyway to the next to-be-inserted identity value before actually inserting the value? I ne…
3 replies
Hi I haven't really used SQL XML before and now that I need to use it I find myself in trouble. I h…
2 replies
Employee table EmployeeID Employeename Employeecode Passportcode 1 aaaa …
8 replies
I have a column that is NText that may contain Kanji and English text. When I view through the GUI,…
5 replies
Viewing 15 topics - 9,001 through 9,015 (of 12,234 total)
You must be logged in to create new topics.