Topics
Started by
Posts
Last post
HI all Am trying to work on deleting duplicate rows from a table and am kind of stuck. Could i ple…
10 replies
SELECT completed_count = ( SELECT COUNT(1) FROM dbo.[RESPONDENT] r WITH ( N…
2 replies
select ID_NUM as ID_num, LAME1, RESP_CODE as RESP_CODE1,cast(QUERY_COMM as nvarchar(max)) as QUERY_…
2 replies
I am using SCOPE_IDENTITY() to get last generated id in session,scope. but this is giving me values…
4 replies
I am trying to develop a program for create table script for sql 2000 db using SMO. How can I add S…
1 replies
I'm new to development below script is erroring any idea why? select cast(right(@@servicename,2) as…
2 replies
Hi, I have a query regarding SQL Server. Currently I am using SQL Server 2005 Express and I have a …
1 replies
CRATE procedure [dbo].[Auto_Create_Procedure] @table_name varchar(200) AS DECLARE @column_name varc…
2 replies
The [lab_seq] column is updated within the code using the array index. A decision was made years a…
8 replies
Hi, I would like to know how to lock a particular row of a table being read by more than one user a…
10 replies
I have two SQL Servers (Server A and Server B) replicating one database via sql server merge replic…
8 replies
Hi, I have configured 6 databases on my db server and recently started getting timeout errors from …
4 replies
I have two separate queries that I would like to combine into 1. My first query returns a set of r…
7 replies
Overview.. I am working on an application in Heatlh Home Care which uses Allscripts Home Care. Due…
4 replies
Why does this returns 59 seconds ? SELECT DATEPART(SS,CAST('2012-05-06 11:07:09.313' AS DATETIME) -…
5 replies
Viewing 15 topics - 331 through 345 (of 4,155 total)
You must be logged in to create new topics.