Viewing 15 posts - 991 through 1,005 (of 1,478 total)
ashokdasari (5/4/2009)
Yes Mr.Adi I am using SqlServer2008
In that case you should post you question in the correct forum (this forum is about SQL Server 2000 and SQL Server 7). ...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 4, 2009 at 5:01 am
This can not be done using SQL Server 2000. If it is important for you and you can work with SQL Server 2005 or 2008, then read in BOL...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 4, 2009 at 4:48 am
arun.sas (5/4/2009)
Hi Adi,Fine for the convert into varchar, but
OP shows convert to timestamp
ARUN SAS
Timestamp has nothing to do with date. Timestamp is just a binary column that modifies...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 4, 2009 at 2:15 am
Here is one way of doing so:
declare @string char(12)
set @string = '200905031043'
select CONVERT (smalldatetime,left(@string,8) + ' ' + substring(@string,9,2) + ':' + right(@string,2))
By the way why are you storing...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 4, 2009 at 1:48 am
You trigger is written to work when one record is updated. Take a look at this statement that was taken from your code:
Select @EquipId=EquipId ,@MDL=Mdl, @UID=UID,@DC=DC,@RomPrimaryid=RomPrimaryid,@MKMDID=MKMDID,
@Room=Room FROM...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 3, 2009 at 11:30 pm
With SQL Server 6.5 you could work with SQL Server authentication only, but this feature was taken out when SQL Server 7 was released. Windows Authentication is regarded as...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 3, 2009 at 10:25 pm
First of all you have to make sure that it is space. It could be another charcter such as tab or a control character that can not be seen....
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 1, 2009 at 4:31 am
Why aren’t you doing the whole update in the statement? In any case no one will be able to tell you what went wrong in your trigger if you...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 1, 2009 at 12:28 am
One way of doing it is to create a user defined function that checks for each record if it has the highest value in filed2 according to field1. Then...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
April 30, 2009 at 11:46 pm
You can use bcp with query on information_schema.routines. The column routine_definition contains the routine’s script. The column routine_type can help you filter only the records that are stored...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
April 30, 2009 at 11:15 am
FNS (4/30/2009)
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
April 30, 2009 at 9:18 am
You need to check for null. You can do it with the isnull function or with the is null operator:
select * from table where isnull(flag,1) = 1
select * from...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
April 30, 2009 at 4:21 am
Notice that if your table is big, you'll might have performance issues. Unfortunetly I don’t remember the technical explanation on way using the third option causes a none optimal...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
April 30, 2009 at 3:53 am
Markus Veretin (7/14/2004)
Sorry, too fast reply:
alter table orders
drop columnid_order
alter table orders
addid_orderint not null Identity(1,1)
If you just drop the existing...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
April 30, 2009 at 1:48 am
Most chances that all of you star wars fan, know this site, but just in case that someone missed it, here it is http://www.asciimation.co.nz/
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
April 29, 2009 at 11:54 pm
Viewing 15 posts - 991 through 1,005 (of 1,478 total)