Viewing 15 posts - 8,866 through 8,880 (of 13,469 total)
ok, I just realized that the shortcut command you needed was for {slash L}, not {slash R]
ROWTERMINATOR =
vbCrLf = CHAR(13) + CHAR(10) = \n
vbCr = CHAR(13) = \r
vbLf =...
August 26, 2010 at 11:32 am
why not just call the file directly? why do you have to do the cd command, when you know where the file is anyway?
create table #Results (
ID int identity(1,1) NOT...
August 26, 2010 at 10:46 am
Tara-1044200 (8/26/2010)
August 26, 2010 at 10:36 am
i have this CREATE TABLe in my snippets, so i would assume drop table works the same way:
EXEC sp_addlinkedserver 'SeattleSales', 'SQL Server'
GO
EXECUTE ( 'CREATE TABLE AdventureWorks2008R2.dbo.SalesTbl
(SalesID int, SalesName varchar(10))...
August 26, 2010 at 10:21 am
this is completely untested, as you didn't provide the schema or sample data.
note i'm assuming there is a column "remarksID" so the list of remarks can be ordered....only YOU know...
August 26, 2010 at 9:37 am
skcadavre (8/26/2010)
Damnit Lowell! 😛
we cross post each others same answers just a bit too often 🙂
August 26, 2010 at 8:02 am
i don't think the CREATE USER command allows variables; you'd have to switch to dynamic SQL instead:
declare @groupname varchar(50),
@sql varchar(1000)
SELECT @groupname =...
August 26, 2010 at 7:58 am
scottichrosaviakosmos (8/26/2010)
Now, i want to know on which u_column its which columns are...
August 26, 2010 at 7:12 am
you want to read the windows registry to get the collation before the installation, i think?
I'm only sure of how to get it afterwards....maybe you could run a script to...
August 26, 2010 at 5:46 am
doh the script i posted was coded for tempdb specifically, this will work in any old database:
SELECT
SCH.schema_id, SCH.[name] AS schema_name,
...
August 26, 2010 at 5:39 am
Bhuvnesh (8/26/2010)
@lowelli am not able to see the required "include column" . i can only see the system related info.
run my script against any database; look at the column...
August 26, 2010 at 4:57 am
for files originating from unix, i've always used ROWTERMINATOR = '\r' ({slash r} if the forum doesn't like to print it),
otherwise regualr PC files get {slash n}
August 26, 2010 at 4:46 am
sys.index_columns has a 0/1 column named is_included_column;
here's a script example that pulls some of that info out into a comma delimited list that i use for scripting out indexes:
SELECT ...
August 26, 2010 at 4:41 am
also if you don't actually turn off the original satellite servers, change all the databases to read only on the old servers the moment you switch over;
it will help...
August 25, 2010 at 12:03 pm
loki1049 (8/25/2010)
Lowell, are you saying that you would join your imported data to a view to get the appropriate values, and then place it into the staging table?
what i...
August 25, 2010 at 11:52 am
Viewing 15 posts - 8,866 through 8,880 (of 13,469 total)