Topics
Started by
Posts
Last post
Im having trouble writing a query. i have a table with 3 columns create table Tab1 ( ItemId int, Gr…
6 replies
Hi, I have inserted a record whose start time and end time 11/08/2009 9:00:00 AM and 11/08/2009 10:…
16 replies
Dear all, Can anyone help to list out possible rootcause that update command could fail to update a…
11 replies
Can someone tell me how to change this to accept English dates DD/MM/YY? It only works currently w…
6 replies
I've been working on this for hours now. I didn't expect it to take so much time. I was given 3 tab…
9 replies
Hai Can anyone tell me in which scenario we should use stored procedure and when we should not use …
6 replies
Hello everyone, how can I display something when a specific field value is not null ? That of cour…
4 replies
Hi, declare @SearchText varchar(255) set @SearchText = 'east west AND north' User will enter searc…
16 replies
Hi How to perform spell check in sql server
2 replies
Hi how to Select from one sql database and insert into another database. Source db as Sql Server 20…
11 replies
I have string data in a field. 0000010011 0020010234 0102020202 I would like to remove all the lead…
25 replies
Hello. I have the following procedure that is not going to the ERR_HANDLER: upon update error. I a…
8 replies
I've created a date range within the WHERE clause: WHERE Date Between CONVERT(DateTime, '01-JAN-200…
10 replies
Hi Folks, I am new to SQL Server particularly STored procedures, functions, SSIS + reporting servic…
2 replies
check if any records match if match ---rec match/not match when used full outer join both tables no…
1 replies
Viewing 15 topics - 5,476 through 5,490 (of 12,231 total)
You must be logged in to create new topics.