Viewing 15 posts - 7,351 through 7,365 (of 13,469 total)
if you deleted the mdf file, you had to have stopped the server to do it...so when you restarted the server, didn't the database show an error? did you recreate...
June 23, 2011 at 8:24 am
here is how i would do it:
1.add a new float column to the table.
2.UPDATE table set newcolumn = convert(float,oldcolumn) where isnumeric(oldcolumn) =1
3. the columns that were non-numeric willb e null.....do...
June 23, 2011 at 8:22 am
if the path will be less than 4 folders deep, you could use a trick with PARSENAME:
/*
(No column name)(No column name)(No column name)(No column name)
NULLMY ReportsLotusNotes OkMy English Report
*/
SELECT
PARSENAME(ThePath,4),
PARSENAME(ThePath,3),
PARSENAME(ThePath,2),
PARSENAME(ThePath,1)
FROM
( SELECT...
June 23, 2011 at 8:15 am
chandan_jha18 (6/23/2011)
When i right click on the table and see dependencies, it shows me stored procedures or views depending on it. Is it a correct and reliable way?
it's pretty close...
June 23, 2011 at 7:56 am
i would think that a replacement role like this would give a user the rights they need to create objects and do any DML stiff, but take away the ability...
June 22, 2011 at 9:49 am
i just renamed a foreign key no problem...
sp_rename 'FK__SFPLGRP__SFGROUP__000BC426','FK_SFPLGRP_to_SFGROUP'
June 22, 2011 at 9:35 am
the FIRST function is an access function, and doesn't have a true equivilent in SQL server...the best you can do is TOP 1...ORDER BY
June 22, 2011 at 9:32 am
for me "read only activity" means SELECT from views or tables; and more specifically, no INSERT/UPDATE/DELETE/EXECUTE rights to anything else in
the database.
maybe i can get you at least started...
June 22, 2011 at 9:14 am
since you are using access, those are two different queries;
the GO statement is valid for SQL Server;
each of the two queries needs to be saved separately...been a while since i...
June 22, 2011 at 4:42 am
m.dodd (6/22/2011)
the depart time is generated when the visitor clicks the Out button on the access form (taken from the computers time)
the method of entry into a table wouldn't really...
June 22, 2011 at 4:32 am
moving the data more complex than it need to...
i don't see a need to move the data, other than it makes "sense" to someone (the data is different...
June 22, 2011 at 4:12 am
i've done this on the .NET side of things, after i've already loaded the data into a .NET DataTable.
from there, it's fairly easy to format the data into a string...
June 21, 2011 at 8:36 am
Duran (6/21/2011)
I'd imagine that somebody would have come across this before, I am trying to install SQL 2005 R2 (downloaded from MSDN) to install in the D drive, I specify...
June 21, 2011 at 6:16 am
nice job on posting details so we can follow along...but is there a question in there somewhere? is this related to compact edition(the forum you posted) or a specific version...
June 21, 2011 at 6:02 am
ok first the concept:
you can use DATADD and DATEDIFF to fiddle with dates, keeping everything in the proper datetime variable.
test this to understand the concept:
select
--midnight of TODAY.
DATEADD(dd, DATEDIFF(dd,0,getdate()), 0),
--older...
June 20, 2011 at 11:47 am
Viewing 15 posts - 7,351 through 7,365 (of 13,469 total)