Topics
Started by
Posts
Last post
I am doing a project where I need to Mark similar records in a table with millions of records. By s…
1 replies
Is it possible to find out SPs and Views where they are used within the database ?
3 replies
I am working on an application with a hierarchy. The hierarchy includes company, region, division, …
15 replies
Dear All, I am writing a trigger. I have a table with 10 columns. There is a column RowId (PK). The…
2 replies
Hi, I must to shot a trigger if a field is not null, but I have no idea on how to do that? Can some…
5 replies
Hey Everyone... First off, Merry Christmas, or perhaps Happy Holidays to be more inclusive to all …
5 replies
After tracing our database, many queries run with 'SP_EXECUTESQL' and run more than ten seconds, bu…
3 replies
I need a query to get valid donations against the preferences of patient. The donationas are also m…
29 replies
I am having difficulty trying to query data and using the where clause below select * from sales wh…
3 replies
hi, plz execute above code in Query analyzer. declare @year char(4) Declare @visa varchar(25) decl…
6 replies
SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[sprocGefilterdeList] ( @t…
2 replies
This sounds like a repost, but i hope not. If it looks so please forgive me. But i am in urgency, p…
10 replies
Row_id_no is the column. This is the code SELECT max(DWT40034_BZL_VAT_TAX.ROW_ID_NO) fr…
5 replies
As i said i have to convert DATETIME to TIMESTAMP. But i cant do it directly converting MSSQL DATET…
1 replies
I am a newbie to sql. I am needing to show the vst_int_id's if the diag_ty='P' then use Table3 or i…
1 replies
Viewing 15 topics - 4,546 through 4,560 (of 12,230 total)
You must be logged in to create new topics.