Topics
Started by
Posts
Last post
Hello, In a table, I have a varchar(100) field called 'StreetName' in a table called 'tblStreetData…
4 replies
create table t1 (col1 int not null, col2 int not null, col3 varchar(10)) alter table t1 add constra…
4 replies
I have this statement DELETE #CL_FINAL FROM (SELECT * FROM #CL_FINAL WHERE CorrectResponseID = 1) …
4 replies
Hello I am trying to run a query comparing data from two tables. I would like to get the result of …
3 replies
Please help!!!!! Confused and not sure how to write the code An invoice was issued from 1/15/2002 …
4 replies
What is a good way to implement paging of records in a stored procedure?
11 replies
Is there a way to set my database stored procedure parameter to accept discrete values and or Multi…
9 replies
I am building a dynamic sql statement depending on data in a table. Afterwards I want to declare a …
6 replies
Hi there, Dunno if this is what you would call it, but i need to create a database wide variable. …
2 replies
Hi all, the following table is used by a third-party product. I have it in two db's TEST and PROD. …
10 replies
I have an UPDATE TRIGGER CREATE TRIGGER trg_update ON [dbo].[myTable] FOR UPDATE I use If Update(c…
7 replies
hi folks, my question is rather simple. i have one table say emp in which i have one coloum named "…
1 replies
Is so, can you show me an example of the syntax. Thanks, Dave
2 replies
my problem is that I have a dynamic stored procedure which has 10 parameters such as @param1.....@p…
4 replies
Hi, I have a table where I have transaction date, ending balance, begining balance. It has to be so…
9 replies
Viewing 15 topics - 15,166 through 15,180 (of 17,082 total)
You must be logged in to create new topics.