Topics
Started by
Posts
Last post
I have used EXEC sp_executesql in quite a few situations. I was building something simple today for…
4 replies
I need to shred some xml (stored in a xml column in a table) into a table. I have attached a sampl…
5 replies
Run this query and 0 records are returned. SELECT rqEmps.Employee_Name, rqStores.StoreName, rq…
4 replies
I have one huge table with binary structure. In it a record can have maximum of two child records. …
3 replies
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
By: S3ssion
SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[sprocGefilterdeList] ( @t…
2 replies
Viewing 15 topics - 4,546 through 4,560 (of 12,234 total)
You must be logged in to create new topics.