Topics
Started by
Posts
Last post
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
I am trying to replace this: -------------------------- SELECT * FROM USFPIMS.dbo.PRODEXTEND WHER…
3 replies
Folks, I have a weird situation. I have a query which I am running on both Prod and test environme…
6 replies
Write code in SQL that counts from 1 to 100. For each number evenly divisible by 3, substitute “BIZ…
1 replies
Hi, what's the best alternative to using a 'GO' command right after the 'Alter table' command? It s…
8 replies
Hello comunity I need to run the following TSQL query to return a balance, but this script take a v…
15 replies
Is there any mechanism for other than bcp or bulk copy, (read; that a normal user can use) to copy …
6 replies
How do I select all records with values =4316% and yet exclude those values = 4316S*? In other word…
3 replies
I have a database that contains all the responses to employee annual reviews. The employee's respo…
3 replies
Hi. I am sure this is a common issue. I have 2 Databases. Database A (test1) contains standing data…
4 replies
I would like to remove duplicates from a table where no primary key nor a date is present. you can …
22 replies
Hello. I have a table that over 3000 user insert row in it. and some other users use SELECT on this…
9 replies
Viewing 15 topics - 10,126 through 10,140 (of 12,234 total)
You must be logged in to create new topics.