m3rajk
Last Activity: Apr 17 '06, 01:15 PM
Joined: Mar 8 '06
Location:
-
Looking for MSSQL table structure
I've recently become the defacto DBA of two MSSQL databases at work because I am the only one with SQL experience. I have been asked to do some tasks with the databases but this requires and understanding of their structure. I cannot find anything akin to MySQL's mysqldump for mssql and have been looking for that among other help in being able to use my MySQL experience as a base for learning MSSQL. I have spent a few days (8 to 9 hours per day)... -
sql commands dont work in mssql????
i tried 'show databases;' and 'show database;' with NO response. i'm pretty sure it's the frist one that lists the databases on postgres sql and myssql
i have used those two but work is using m$sql.
it seems to me basic SQL commands dont work. what stupid quirk of m$ am i missing to get it to actually RUN sql commands???
thank you in advance -
...Code:# we have to create it, including make the first row $Excel -> {'Visible'} = 1; $Excel -> { 'SheetsInNewWorkBook' } = 1; my $workbook = $Excel -> Workbooks -> Add(); my $ws = $workbook -> Worksheets(1); $ws -> { 'Name' } = "Lab Report $date"; # set first row titles $ws -> Cells(1, "A") -> ('Value') = "Node"; $ws -
...Code:# does the file exit? if(-e "$labrep"){ #we are just adding to it, so open it my $report = $Excel->Workbooks->Open("$labrep"); my $ws = $report -> Worksheets(1); my $ldate = localtime(); &rep("Examining information gathered from lab computers @ $ldate\n", $verb); # start row counter my $row=2; # set rowLeave a comment:
-
and the code for the script/program is...Code:#! /usr/bin/perl use strict; use warnings; use Getopt::Long; # used in getting unix-style options use Win32::OLE; use Win32::OLE::Const 'Microsoft Excel'; # use OLE/Excel $Win32::OLE::Warn = 3; # die on errors... ################################################################################ # Purpose: # This script catalogues the psinfo
Leave a comment:
-
i really dislike doing other people's homework. but since you have tried, i will give you this clue:
you need 4 variables:
var input_string
var output_string
var is_length
var is_place
you should use onChange() to update your length
in psuedo-code:
...Code:<html start stuff> <script language="javascript"> // declare variables
Leave a comment:
-
Active State Perl 5.8.x, OLE, and Excel not creating files
how do i get this to actually fill in and save? when i run my script now it has 2 books with blank sheets.
my wrapper file (batch), with computer names removed for safety/brevity:
...Code:@echo on rem this batch is for cataloguing computers using two other "helpers" rem "helpers" are psinfo and compinfo rem information section is over, turning echo off. @echo off compinfo
-
thank you Kub
I had the same question. this was about link #40 hat i opened looking for help and the first one to go beyond giving mee how to open an excel file.
I have two more questions though:
1: how do i find the last row number with information so that I may jump to there?
2: how do i get this to actually fill in and save? when i run my script now it has 2 books with blank sheets....Leave a comment:
No activity results to display
Leave a comment: