Viewing 15 topics - 277,606 through 277,620 (of 283,819 total)
Topics
Started by
Posts
Last post
Is it necessary to master t-sql fro 70029 exam ? If yes which is best book for T-Sql self study ? C…
6 replies
I have a TSQL Problem. I can not seem to reuse a temp table name. We are trying the below code, a…
5 replies
I have two triggers on a table, one for ON INSERT and one for ON UPDATE. The two triggers are desig…
10 replies
Generally speaking, if you have a query with several views joined (also with several tables), do th…
4 replies
We have a field with a compound value which is used to join to another table in the following way: …
5 replies
The identity column provides the value as integers. We need to generate id similar to 'AAA0001' whe…
3 replies
Hello.. I was trying to write a stored procedure that could execute another row-returning stored p…
2 replies
I’m using Microsoft SQL Server 2000 - 8.00.534 (Build 2195: Service Pack 2). In Northwind databas…
2 replies
What is the optimum number of columns that can be grouped by in SQL Server 2000 ?
7 replies
Is it possible to trap an error that occurs when a statement is executed dynamically i.e set @dbexi…
3 replies
I explain what I would like to do I would like to be able to créeer an user and that this user can …
2 replies
I know that SQL Server and Sybase were basically the same thing way back before SQL 6.5, but how cl…
7 replies
Hello there, I am like so new to all of this. I just finished taking a class in SQL, finished MS A…
6 replies
How would I get the earliest date for each Case_Number with the following query? SELECT Case_Table.…
4 replies
Can any one please point me in the right direction. I need some T-Sql that will tell me if a given…
3 replies
Viewing 15 topics - 277,606 through 277,620 (of 283,819 total)