Topics
Started by
Posts
Last post
Hello, This is sathish, how many tables we can join in teh single select statement. Regards,…
6 replies
Hi, I have a table with a VARCHAR(50) column. The collation for the column is SQL_Latin1_General_CP…
6 replies
if exists (select * from tempdb.dbo.sysobjects o where o.xtype in ('U') and o.id = object_id(N'te…
5 replies
Dear Pals, I have small requirement in my project. I need to display the results of the WHERE claus…
5 replies
Hi everyone, I have a task in which we get feed files in form of xml files and we have to investiga…
1 replies
Hello, In my script I want to dive (Oooh nooo !) here's my (very simple) code: ALTER PROC TESTTELL…
5 replies
I have 2 tables (TableA and TableB) with various fields. I want to build a new table (TableZ), that…
3 replies
Hi, Trying to solve a reporting issues here, and cant quite get my head around it. I have a table w…
2 replies
Please help me get the insert scripts for all the user tables in a database. "More Green More Oxyge…
6 replies
Hi all, This is what I have. but somehow it keeps saying that Procedure getSelectCertNumber, Line …
3 replies
Hi All, I have a Table with 3 columns SalesPID SalesAmount DiscountAmount 12 …
2 replies
Hi Friends, I just come across the topic of join hints and I found its interesting if we can change…
7 replies
Easy question. When using dynamic sql, does the string have to be declared as a nvarchar(4000)? i …
6 replies
This cursor has given me headaches since day 1. It was tolerable in sql2000 because it was a batch …
15 replies
Can somebody show me the basic syntax for an update select statement when I need multiple fields in…
2 replies
Viewing 15 topics - 10,111 through 10,125 (of 12,230 total)
You must be logged in to create new topics.