Viewing 15 posts - 361 through 375 (of 389 total)
leesider (6/27/2012)
I am getting the following error when I right-click on a stored procedure (any one) in Management Studio and select "modify". It hangs for a while and then I...
June 27, 2012 at 7:34 am
DVSQL (6/22/2012)
June 27, 2012 at 7:03 am
Methew (6/25/2012)
IF OBJECT_ID('TempDB..#mytable1','U') IS NOT NULL
DROP TABLE #mytable1
CREATE TABLE #mytable1
(
ID INT IDENTITY(1,1) ,
UName NVARCHAR(50),
alert_datetime DATETIME
)
SET IDENTITY_INSERT #mytable1 ON
INSERT...
June 27, 2012 at 6:48 am
hiteshchouhan91 (6/26/2012)
column import and issue values showing me 2200 and 600
but actual total of these column is 1100 and 300 respectively
i want that it should be...
June 26, 2012 at 11:06 pm
fawadafr (6/26/2012)
Chris:In your examples you are using the five product names I had provided. What would be the best way if I am dealing with 5,000+ products?
Hey Fawad,
Did you try...
June 26, 2012 at 10:54 pm
info 281 (6/26/2012)
June 26, 2012 at 6:51 am
rahuldhawan2007 (6/26/2012)
i'm new to sql sever. i have few queries
1. what is composite key in a database
2. what is a candidate key
3. what is difference between varchar and nvarchar...
June 26, 2012 at 6:35 am
Use below command
DBCC CHECKIDENT ("TableName",RESEED, 1300);
June 26, 2012 at 4:30 am
shobha.aradhya (6/26/2012)
I have a table with one of its col as auto-increment. The max value set is 1500. when the table reached 1234 records, the next few records...
June 26, 2012 at 4:22 am
darth_vodka (6/26/2012)
hisimple question, what does the ^ do in t-sql?
it's eluding me on google
thanks
EDIT:
aha, bitwise OR
hmm
Hi darth_vodka,
This is binary XOR.
June 26, 2012 at 4:03 am
jmoog (6/26/2012)
Table are use every sec. Yes there's index.some insert is 2 - 10 ms, some insert is big like 500 ms
It is difficult to say from my end.But as...
June 26, 2012 at 3:40 am
jmoog (6/26/2012)
Here is the insert commandNSERT INTO [TT_TSAPIDataA]
([SiteId]
,[ReferenceId]
,[CallId]
,[ResultingCallId]
,[SourceIP]
,[DestinationIP]
,[ProtocolId]
,[ApplicationId]
,[OperationValue]
,[SpecificEvent]
,[DNIS]
,[ANI]
,[CallingNumber]
,[CallingAddressType]
,[CalledNumber]
,[CalledAddressType]
,[DomainExtension]
,[Count]
,[OriginationPort]
,[ConnectedNumber]
,[ConnectedNumber2]
,[ConnectedAddressType]
,[TrunkGroup]
,[TrunkMember]
,[Cause]
,[DateReceived]
,[TimeZoneOffset])
VALUES
(@SiteId1,
@ReferenceId1,
@CallId1,
@ResultingCallId1,
@SourceIP1,
@DestinationIP1,
@ProtocolId1,
@ApplicationId1,
@OperationValue1,
@SpecificEvent1,
@DNIS1,
@ANI1,
@CallingNumber1,
@CallingAddressType1,
@CalledNumber1,
@CalledAddressType1,
@DomainExtension1,
@Count1,
@OriginationPort1,
@ConnectedNumber1,
@ConnectedNumber21,
@ConnectedAddressType1,
@TrunkGroup1,
@TrunkMember1,
@Cause1,
DATEADD(mi,@TimeZone,@DateReceived1), --@DateReceived
@TimeZone)
)
Have you observed the values you are passing ? Do you have any index on the said table ? How frequently the...
June 26, 2012 at 3:13 am
jmoog (6/26/2012)
Can you please figure out the reason why insert with this table is sometimes slow. Some insert 2 ms, some insert 500 ms. Here is the schema
CREATE TABLE...
June 26, 2012 at 2:51 am
Methew (6/26/2012)
rhythmk (6/26/2012)
Methew (6/26/2012)
IF OBJECT_ID('TempDB..#mytable1','U') IS NOT NULL
DROP TABLE #mytable1
CREATE TABLE #mytable1
(
ID INT IDENTITY(1,1) ,
UName NVARCHAR(50),
alert_datetime DATETIME
)
SET IDENTITY_INSERT #mytable1 ON
INSERT INTO...
June 26, 2012 at 1:34 am
jchernev (6/19/2012)
I'm currently in the process of designing a SSIS package that needs to run in both DEV and Prod. As such, I've setup a database table that contains...
June 26, 2012 at 1:09 am
Viewing 15 posts - 361 through 375 (of 389 total)