Topics
Started by
Posts
Last post
What is the optimal method to filter dates in a where clause if you want to ignore the time portion…
17 replies
Hi, Hopefully I can get some help with writing a query that some of you are probably familiar with …
2 replies
Here is my Dilemma i have a table abc with columns testId,gender with values testid gender 1 …
5 replies
Here is my dilemma. I have three tables that I need to join together but at any given time any one…
2 replies
Hi all, Let say there are two select statement and we are using UNION to combine result from both…
5 replies
Hi there, I got a stored procedure that receives an XML document as a parameter to update a table. …
7 replies
I am new to SQL. Can you tell me how I would convert a DateTime field to MMDDYY without any / or …
6 replies
Hi To All; I will Run the QueryApproximately 700000 Records ; For example Select * From S…
2 replies
XML <?xml version="1.0" encoding="utf-8" standalone="no"?> <submission> <header_reco…
2 replies
Hi all, I created a table in which there r n fields and in that two of them are date field i.e., …
8 replies
i have a table like.. column1 column2 column3 a a 002 a…
3 replies
Hi to All; Pls any one to Help This; The Following Qry to Update The Records; Update G…
3 replies
Since ISNUMERIC will return 1 for "some characters that are not numbers" I will usually accept valu…
3 replies
I have a source table 'Codes' CREATE TABLE [dbo].[Codes]( [id] [int] IDENTITY(1,1) NOT NULL, [Na…
7 replies
backup and insertion process is doing same time. some times backup process is getting error when in…
11 replies
Viewing 15 topics - 10,381 through 10,395 (of 10,635 total)
You must be logged in to create new topics.