Topics
Started by
Posts
Last post
As we don't practice to shutdown SQL server (unless there is a system maintenance work needs to be …
2 replies
I am getting following error on my sp "Server: Msg 117, Level 15, State 1, Procedure dbspCalcdbaSpa…
2 replies
I just wonder if it's safe to assume that the row order is the same for INSERTED and DELETED when I…
10 replies
Is it possible to do a cross server query in SQL Analyzer? If so, can someone show me the syntax f…
4 replies
The difference between the two? [Platform is SQL 2k]When is the best time to use them? In other w…
4 replies
We have this table: CREATE TABLE [dbo].[allocdet] ( [alloc_num] [decimal](18, 0) NOT NULL , [price_…
12 replies
I'm trying to teach myself how to write triggers. I understand the basics, but my boss wants me to…
9 replies
Does anyone have a script that will tell you how a column is used in an application? What I'm look…
8 replies
I have two identically structured tables, A and B. "A" has the correct records, "B" is like "A" bu…
4 replies
Is there a way to stop the WITH NORECOVERY command? I'm restoring a database and it succeeded, but …
5 replies
hi, my query is: SELECT CAST(OID AS varchar(15)) ........................... this is a possible res…
5 replies
How do I go about executing a VB Application from a insert trigger
20 replies
Hello! Is there some basic rules when JOINing multiple tables? Like is there a performance differen…
3 replies
Can anyone help with this. I could do it in VB, not too much problem but want to do it in TSQL... …
3 replies
Hi all! I have a problem. I'm trying to make a small search engine. I have two tables like this: me…
3 replies
Viewing 15 topics - 16,066 through 16,080 (of 17,082 total)
You must be logged in to create new topics.