Topics
Started by
Posts
Last post
Hello to all, I want to copy data from a table on MS SQL Server to an Oracle database table using L…
3 replies
I have created a stored procedure to insert data into table, and return the scope_identity(). …
9 replies
I have a table that has many duplicate records and I need to delete all but one of the duplicate re…
13 replies
For instance, the PK is defined as follows: KeyID = UniqueIdentifier (GUID) FirstName = char(n) Las…
2 replies
I have a T-SQL statement that includes: SELECT P.Col001, P.Col002, P.Col003, A.Age_start_INT, A.Age…
6 replies
I have the following query: Declare @Memberid as varchar (50) Declare @ProcCode as Varchar (15) set…
4 replies
I run this dynamic SQL: DECLARE @DB varchar(25) SET @DB = 'pmidba' DECLARE @Tablename varchar(50) S…
5 replies
Hi, Can anyone explain why this doesn't work: select *, (select sum(time_normal_hrs) from dbo.fn_Ge…
5 replies
Hello everyone, i have a table in sqlserver 2000, in this i have a column "Name" with the followi…
1 replies
Doing a SQL word search that takes in @SearchTerms as a varchar. The WHILE loop works great with up…
6 replies
Hi, I have two tables Table1_Users UserID (int), UserName Char(20) Table2_Event EventName(char30),…
2 replies
hi how do i validate address say i have coladdr1= 'sanjaynagar 3 main 4 main blore karnataka india'…
1 replies
Hi, is there any way to construct a dynamic query and execute it inside a user-defined functio…
2 replies
Hey friendz, I've developed a DTS package from importing data from excel files to SQL Server and it…
5 replies
Hello! I have a bunch of procedures to execute as a transaction. I need to be able to rollback the …
1 replies
Viewing 15 topics - 5,956 through 5,970 (of 17,082 total)
You must be logged in to create new topics.