Topics
Started by
Posts
Last post
Hello, I have a table for which structure is below: nCounter numeric vInOutTag varchar(1) nEmpNo nu…
9 replies
Hello I have a table that has a numeric primary key and other columns like personName, assignedgned…
5 replies
We need to pull some data in from our SAS db into a SQL Server 2005 database. From what I can tell …
9 replies
hi, SET NOCOUNT ON DECLARE @crdate DATETIME, @hr VARCHAR(50), @min-2 VARCHAR(5) SELECT @crdate…
5 replies
create table #drivertable( id int, name varchar(10), status varchar(2), c_group int ) Insert into #…
8 replies
Hi, I know multiple columns can be updated in a single UPDATE statement like this: UPDATE t SET fie…
13 replies
I have an XML of the Form declare @XML xml declare @tmp1 int,@tmp2 int declare @New_ACC_ID int set …
4 replies
This seems like an easy query, yet all my attempts have failed to find the answer. Mainly I have 2 …
3 replies
I am trying to automate a process. In the code, I am creating a backup of a table before I modify i…
2 replies
Hey reader, first of all thanks for reading my problem ! The issue i'm having is that i'm reading …
10 replies
Hi Techies, Attached is the sql statements to create 3 tables and insert dummy data in all three ta…
8 replies
Hello , Can you please tell me wheteher i have written the following code correctly or not... sele…
2 replies
Hello Friends ….I’ve a table which has 4 partitions and those partitioned table are purged by a job…
3 replies
I have been logging data from perfmon to a SQL Server DB. The Date/Time info is stored as CHAR(24)…
5 replies
Hi, I need to delete data older than 30 days. Column that I filter on is char and has date formatte…
8 replies
Viewing 15 topics - 1,816 through 1,830 (of 12,234 total)
You must be logged in to create new topics.