Topics
Started by
Posts
Last post
Use Pubs Go Create table Balaji ( f1 int not null Primary key, f2 varchar(10) Not Null) Go Create t…
6 replies
I have a store procedure when called in Query Analyzer like this: sp_RM_beveragereport_dept '10/07/…
3 replies
Is there a simple way to anticipate a doomed CAST operation, or trap the resulting error, clear the…
8 replies
I am trying to create a simple function that has datediff with one parameter as GETDATE() --set @Ag…
4 replies
Hi, I have 2 tables. I want to insert into one table where min(cost) is calculated based on 1 colum…
1 replies
What is the best way of counting the number of triggers for all the user tables in a specific user …
2 replies
hello friend, i get 3 tables, T1 with fields a and b T2 with fields c,d and a1 references to a in T…
1 replies
What's the most authoritative place to find information on accessing the system tables. The BOL is…
2 replies
Hi, I use Isql with input and output files. The input files are selects and DBCC statements. In my…
1 replies
I'm almost dreading asking ths , becuase I just KNOW the anser is going to be something simple. I w…
4 replies
1) Why is a database website non-searchable? 2) Is there a way to pass in a varhcar pre-prepared li…
8 replies
I would like to select a subset of rows from a table and assign a sequential number during the outp…
2 replies
Does anyone know of a way to trap errors and continue executing SQL instead of returning out of a p…
2 replies
How do we perform error-handling inside a UDF? I've tried using RAISERROR as well as a ROLLBACK bu…
10 replies
If I had a table with say a list of 10 names. col_id mfg_name 1 ACER 2 COMPAQ 3 …
6 replies
Viewing 15 topics - 16,201 through 16,215 (of 17,082 total)
You must be logged in to create new topics.