|
|
|
IDENTITY_INSERT is set to OFF
Fri, 1 Aug 2008 19:05:58 -0400
Hi All,
When I am trying to do some import , sometimes I am getting the below error. Using ms sql 2005 64 bits Windows Vista Ultimate.
Cannot insert explicit value for identity column in table 'VerifyAmerica' when IDENTITY_INSERT is set to OFF
I fixed it by running below code :
SET IDENTITY_INSERT dbo.email ...
|
nested select?
Thu, 31 Jul 2008 17:42:57 -0400
I have a table requirements it contains the following data table structure
and sample data;
id, year, term, program, division, location, sequence, requirement_code,
requiremtent_type, test_code, test_element,requirement_description,
completion_status, completion_date, hold_release, minimum_met, recieved_req
...
|
SQL Query via the command line pt.2
Thu, 31 Jul 2008 09:04:08 -0700 (PDT)
A couple of more questions for the group! What do the
following command(s) do? Is this one command or several different
ones? And can I execute this in the same manner as the previous
command (OSQL)?
sysname, Object sysname, Grantee sysname, Grantor sysname,
ProtectTypeuse msdb
CREATE TABLE #ProcPermission ...
|
question about views (SQL2005)
Thu, 31 Jul 2008 11:09:52 -0400
Hi: I created a simple view against a single table where the sql is
something like:
USE [myDB]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create VIEW [dbo].[myTableView]
AS
SELECT ReqDate, FName, LName, Email
FROM dbo.myTable
WHERE (myPage = 3)
ORDER BY ReqDate
where "Re ...
|
Error
Wed, 30 Jul 2008 18:08:45 -0700
Hello I get this error message and I don't know what to do or go to fix this
I am a new user to sql server 2005 can someone help. I am trying to connect
via ODBC Microsoft to AS/400. Message says:
Executed SQL Statement: SELECT OVDA, OVBC, ODGY FROM
ABC.ASC ORDER BY OVDA
Error Source: CWBODC.DLL
Er ...
|
Executing a Stored Procedure from a remote box
Tue, 29 Jul 2008 13:41:52 -0700 (PDT)
What is the most robust method of executing a stored procedure via a
batch file on a remote machine?
PSEXEC?
I am trying to run a restore that will execute from a SPS web server
in the same farm.
Thanks,
Dennis ...
|
returning max, min, median, mean in one query?
Mon, 28 Jul 2008 11:07:49 -0400
Hi: I have a table that I want to return the max, min, median and mean
values from. I have the first three returned in a single query (select
Max(val) As myMax, etc.), and I have the mean returned in a separate query:
with positions
as(
select (1 + Count(*)) / 2 as mid,
1-(count(*) % 2) as even
from medpr ...
|
|
|
Find function of mod
Mon, 28 Jul 2008 12:14:33 +0800
I have a problem to find a function name: mod (returns the remainder portion
of i mod p) at SQL server and it is exit at vusual studio.
Example : 5 / 2 = 1 is my remainder portion.
Thank You
...
|
ACREDITE FUNCIONA!!!!!
Sun, 27 Jul 2008 16:22:52 GMT
Ganhar dinheiro rápido e honesto
meu blog http://jet72.zip.net/
: QUER GANHAR UM BOM DINHEIRO? FAÇA COMO NÓS !
: COMO TRANSFORMAR 12 REAIS EM NO MINIMO DOZE MIL REAIS !!
: EU TAMBEM NÃO ACREDITAVA!! VOCÊ É CAPAZ, APENAS FAÇA FUNCIONAR.!
Encontrei esta mensagem em um fórum no UOL e decidi tentar. Pouco ...
|
SQL Server 2005 on Windows Server 2008 - sqlcmd can not connect
Sat, 26 Jul 2008 15:48:56 -0700
SQL Server 2005 SP2 (9.0.3068) installed on Windows Server 2008 Enterprise.
When I installed SQL Server I specified a "named instance" with the name
TEAMFOUNDATION.
This appears to be working OK; I have Team Foundation Server and SharePoint
3.0 installed on another Windows Server 2008 server and they can us ...
|
|
|
