Viewing 15 posts - 1 through 15 (of 41 total)
it doesnt matter where the data is stored. what matters is whether SQL server is running and do you have the rights to connect to it.
July 29, 2003 at 9:06 am
you can do it easily using . dynamic sql.
to give you a pointer. herez some code.
eg:
declare @vsql varchar(8000)
declare @tablename varchar(300)
declare @fieldname varchar(300)
fetch next from...
July 9, 2003 at 12:45 am
if there are leading and trailing spaces. you can use ltrim and rtrim.
i would suggest you to provide a example and expected result. it will be easy for the members...
July 8, 2003 at 11:07 pm
you can rewrite it by converting the fields into varbinary.
SELECT COUNT(1) FROM TableName WHERE Field1=@Var1 AND Field2=@Var2 AND convert(varbinary(30),Field1)=convert(varbinary(30),@Var1)
remember Ascii function will only look for the first character Ascii value....
July 8, 2003 at 12:47 am
you can try using Image data typ.
check BOL for image data type.
June 21, 2003 at 12:48 am
wpballar i tried this its working perfectly fine.
can u post what problem are you facing with this.
June 21, 2003 at 12:35 am
Select a.col1, a.col2, b.col1, b.col2 from tablea NOT EXIST (select 1 from tableb b where a.col3=b.col3)
June 19, 2003 at 9:55 am
15 hours thats a huge time. i would suggest you to take a backup on a local drive and then copy it in the tape rather then taking the...
June 19, 2003 at 9:02 am
CREATE PROCEDURE UpdateInfo @Empid Int AS
Select * from tblEmployee where EmpID = @Empid
go
SNIPED!!!!!!!!!
should get you your required result.
Edited by - nazim on 06/19/2003 08:57:29 AM
June 19, 2003 at 8:54 am
the maximum row size in sql server is 8060. so, all the cumululative size of the data cannot go beyond 8060 values. so, i dont see any performance degradation with...
June 19, 2003 at 2:48 am
i would suggest you add two more new columns to your source table DateCreated and DateModified. first time you dump all the records from source to destination. later you can...
June 19, 2003 at 12:40 am
SELECT account_id, bill_contact, bill_address,isnull(cc_number,' '),
isnull(cc_type,' '),isnull(cc_exp,' ')
from account a
left join credit_card c
on a.account_id=c.account_id
where a.bill_method='CC'
HTH
June 19, 2003 at 12:00 am
check for DBCC CHECKIDENT in BOL.
eg:
DBCC CHECKIDENT (Employee, RESEED, 1)
June 18, 2003 at 10:02 am
if you are trying to drop a table being referenced by other table.
first manually drop the referencial constraints then only you can drop the table.
Edited by - nazim on 06/18/2003...
June 18, 2003 at 2:53 am
Viewing 15 posts - 1 through 15 (of 41 total)