Topics
Started by
Posts
Last post
Imagine you want to create a general trigger, which can be linked on multiple tables, e.g. a trigge…
10 replies
set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER PROCEDURE [dbo].[SearchCourse] @VarCourse_Id in…
9 replies
Hello all, I want to capture the results of an exec (in this case of sp_spaceused) and add the data…
5 replies
I have 2 unitest case. DECLARE c CURSOR FORM SELECT..... --When this SQL error OPEN c BEGIN TRAN…
3 replies
Hi, I know we cannot implement a foreign key constraint that causes a multiple cascade path. Assume…
2 replies
Dear All, I have a two column like DESIGNATIONS,NAME Values DESIGNATIONS NAME MD …
3 replies
I'm a System Admin doing getting into SQL, is the correct way to re-write this statement (OLDWay) s…
4 replies
In table A, Col1 I have a string in a column delimited by pipes. |xxxxx|xxxxx| | |xxxxx| I…
4 replies
Hopefully some of you whom are way better a SQL can give me an idea how to get started at this. I n…
3 replies
the below do not return the same results...i think it is because it is trying to say where person n…
4 replies
Hi, I have a write a query. where I need, to utilize the Case Status field and see within the time …
5 replies
I have the following questions, To obtain a single value as a result of an operation, which is more…
20 replies
I am designing a database for a web app which needs to store user profiles. However I need to be a…
2 replies
I need to add user data types to the sys.types table in my database by getting all the user datatyp…
2 replies
I have a table of around 200k records – this table holds groups of duplicate records. I have used r…
2 replies
Viewing 15 topics - 9,721 through 9,735 (of 10,647 total)
You must be logged in to create new topics.