SQL script

[Chas17]

I have sql script which generates a table in sql server (2000-2008).

How do I run this script? Do I have to have an SQL server?

 

[xenou]

Yes, you must have a database created in SQL server, and also the proper level of permissions to make changes to the database table structure. Finally, you need to be able to connect to the database to run your script! This can be done with SQL Server Management Studio or other interfaces for working with the database itself, or via any connection technology that will allow you to send your request to the database - but everything assumes you have a user profile with appropriate permissions.

In short - talk to your database adminstrator, who should know about such changes anyway.

Regards,
Alex

 

[Chas17]

Thanks. I do not have a DB admin, just me on my home computer.
Was sent sql script to create a table which then then wanted to create spreadsheet but I don't know how to run script to create table or have excel run script.

Chas

 

[xenou]

Hmm,

SQL scripts can generate tables on various platforms. At home, you would normally be using SQL Server Express, which is a free version of SQL Server rather than the costly Enterprise version, or perhaps Microsoft Access, among others. "SQL Server", as such, is normal for corporate and other large scale environments.

What kind of database are you creating? And what kind of data management tools do you have? You'll need to pass your script to a SQL Engine to be executed - but which one?

Alex

EDIT: I'm sorry, I think I misread your original Question.

How do I run this script? Do I have to have an SQL server?

I think I assumed you have SQL server and were asking how to run it on SQL Server.

So, stepping back, you don't need SQL server but you do need a SQL Engine. The most common one in use for members of this forum is Microsoft Access. You can also download SQL Server Express from Microsoft's site - which gives you the bare bones of a database engine but generally assumes you have another set of tools to interface with it (such as a visual basic application, or even Access to act as a front end).

There are some slight differences in syntax among different flavors of SQL databases - so a script might not run the first time without slight modifications.

 

[Chas17]

Thanks, I did download Server Express, now I have to figure out how to start it (let alone use it). Guess I have a lot of learning to do.
Thanks

 

[wigi]

You can also download SQL Server Express from Microsoft's site - which gives you the bare bones of a database engine but generally assumes you have another set of tools to interface with it (such as a visual basic application, or even Access to act as a front end).

Or custom "dynamic" web pages in ASP that get their data from the database, and also write back.

 

[xenou]

Thanks Wigi - good point!

I'd place using SQL Server Express at an intermediate level of expertise - its not at all obvious where to start. I believe you can also download a set of management studio tools ... its a bit fuzzy right now. I've used it once before for some practice, and during a class in Visual Basic where we connected from a Visual Basic application created with Visual Studio Express.

Alex

 

[Chas17]

Thanks, i'll keep searching.

 

[Norie]

Chas

What is this 'script' exactly?

 

[Chas17]

USE [pubs]
GO
/****** Object:  Table [dbo].[authors]    Script Date: 08/18/2009 21:52:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[authors](
 [au_id] [dbo].[id] NOT NULL,
 [au_lname] [varchar](40) NOT NULL,
 [au_fname] [varchar](20) NOT NULL,
 [phone] [char](12) NOT NULL,
 [address] [varchar](40) NULL,
 [city] [varchar](20) NULL,
 [state] [char](2) NULL,
 [zip] [char](5) NULL,
 [contract] [bit] NOT NULL,
 CONSTRAINT [UPKCL_auidind] PRIMARY KEY CLUSTERED 
(
 [au_id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON , ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
INSERT [dbo].[authors] ([au_id], [au_lname], [au_fname], [phone], [address], [city], [state], [zip], [contract]) VALUES (N'172-32-1176', N'White', N'Johnson', N'408 496-7223', N'10932 Bigge Rd.', N'Menlo Park', N'CA', N'94025', 1)
INSERT [dbo].[authors] ([au_id], [au_lname], [au_fname], [phone], [address], [city], [state], [zip], [contract]) VALUES (N'213-46-8915', N'Green', N'Marjorie', N'415 986-7020', N'309 63rd St. #411', N'Oakland', N'CA', N'94618', 1)
INSERT [dbo].[authors] ([au_id], [au_lname], [au_fname], [phone], [address], [city], [state], [zip], [contract]) VALUES (N'238-95-7766', N'Carson', N'Cheryl', N'415 548-7723', N'589 Darwin Ln.', N'Berkeley', N'CA', N'94705', 1)
INSERT [dbo].[authors] ([au_id], [au_lname], [au_fname], [phone], [address], [city], [state], [zip], [contract]) VALUES (N'267-41-2394', N'O''Leary', N'Michael', N'408 286-2 428', N'22 Cleveland Av. #14', N'San Jose', N'CA', N'95128', 1)
INSERT [dbo].[authors] ([au_id], [au_lname], [au_fname], [phone], [address], [city], [state], [zip], [contract]) VALUES (N'274-80-9391', N'Straight', N'Dean', N'415 834-2919', N'5420 College Av.', N'Oakland', N'CA', N'94609', 1)
INSERT [dbo].[authors] ([au_id], [au_lname], [au_fname], [phone], [address], [city], [state], [zip], [contract]) VALUES (N'341-22-1782', N'Smith', N'Meander', N'913 843-0462', N'10 Mississippi Dr.', N'Lawrence', N'KS', N'66044', 0)
INSERT [dbo].[authors] ([au_id], [au_lname], [au_fname], [phone], [address], [city], [state], [zip], [contract]) VALUES (N'409-56-7008', N'Bennet', N'Abraham', N'415 658-9932', N'6223 Bateman St.', N'Berkeley', N'CA', N'94705', 1)
INSERT [dbo].[authors] ([au_id], [au_lname], [au_fname], [phone], [address], [city], [state], [zip], [contract]) VALUES (N'427-17-2319', N'Dull', N'Ann', N'415 836-7128', N'3410 Blonde St.', N'Palo Alto', N'CA', N '94301', 1)
INSERT [dbo].[authors] ([au_id], [au_lname], [au_fname], [phone], [address], [city], [state], [zip], [contract]) VALUES (N'472-27-2349', N'Gringlesby', N'Burt', N'707 938-6445', N'PO Box 792', N'Covelo', N'CA', N'95428', 1)
INSERT [dbo].[authors] ([au_id], [au_lname], [au_fname], [phone], [address], [city], [state], [zip], [contract]) VALUES (N'486-29-1786', N'Locksley', N'Charlene', N'415 585-4620', N'18 Broadway Av.', N'San Francisco', N'CA', N'94130', 1)
INSERT [dbo].[authors] ([au_id], [au_lname], [au_fname], [phone], [address], [city], [state], [zip], [contract]) VALUES (N'527-72-3246', N'Greene', N'Morningstar', N'615 297-2723', N'22 Graybar House Rd.', N'Nashville', N'TN', N'37215', 0)
INSERT [dbo].[authors] ([au_id], [au_lname], [au_fname], [phone], [address], [city], [state], [zip], [contract]) VALUES (N'648-92-1872', N'Blotchet-Halls', N'Reginald', N'503 745-6402', N'55 Hillsdale Bl.', N'Corvallis', N'OR', N'97330', 1)
INSERT [d bo].[authors] ([au_id], [au_lname], [au_fname], [phone], [address], [city], [state], [zip], [contract]) VALUES (N'672-71-3249', N'Yokomoto', N'Akiko', N'415 935-4228', N'3 Silver Ct.', N'Walnut Creek', N'CA', N'94595', 1)
INSERT [dbo].[authors] ([au_id], [au_lname], [au_fname], [phone], [address], [city], [state], [zip], [contract]) VALUES (N'712-45-1867', N'del Castillo', N'Innes', N'615 996-8275', N'2286 Cram Pl. #86', N'Ann Arbor', N'MI', N'48105', 1)
INSERT [dbo].[authors] ([au_id], [au_lname], [au_fname], [phone], [address], [city], [state], [zip], [contract]) VALUES (N'722-51-5454', N'DeFrance', N'Michel', N'219 547-9982', N'3 Balding Pl.', N'Gary', N'IN', N'46403', 1)
INSERT [dbo].[authors] ([au_id], [au_lname], [au_fname], [phone], [address], [city], [state], [zip], [contract]) VALUES (N'724-08-9931', N'Stringer', N'Dirk', N'415 843-2991', N'5420 Telegraph Av.', N'Oakland', N'CA', N'94609', 0)
INSERT [dbo].[authors] ([au_id], [au_lname], [au_fname ], [phone], [address], [city], [state], [zip], [contract]) VALUES (N'724-80-9391', N'MacFeather', N'Stearns', N'415 354-7128', N'44 Upland Hts.', N'Oakland', N'CA', N'94612', 1)
INSERT [dbo].[authors] ([au_id], [au_lname], [au_fname], [phone], [address], [city], [state], [zip], [contract]) VALUES (N'756-30-7391', N'Karsen', N'Livia', N'415 534-9219', N'5720 McAuley St.', N'Oakland', N'CA', N'94609', 1)
INSERT [dbo].[authors] ([au_id], [au_lname], [au_fname], [phone], [address], [city], [state], [zip], [contract]) VALUES (N'807-91-6654', N'Panteley', N'Sylvia', N'301 946-8853', N'1956 Arlington Pl.', N'Rockville', N'MD', N'20853', 1)
INSERT [dbo].[authors] ([au_id], [au_lname], [au_fname], [phone], [address], [city], [state], [zip], [contract]) VALUES (N'846-92-7186', N'Hunter', N'Sheryl', N'415 836-7128', N'3410 Blonde St.', N'Palo Alto', N'CA', N'94301', 1)
INSERT [dbo].[authors] ([au_id], [au_lname], [au_fname], [phone], [address], [city], [state], [zip ], [contract]) VALUES (N'893-72-1158', N'McBadden', N'Heather', N'707 448-4982', N'301 Putnam', N'Vacaville', N'CA', N'95688', 0)
INSERT [dbo].[authors] ([au_id], [au_lname], [au_fname], [phone], [address], [city], [state], [zip], [contract]) VALUES (N'899-46-2035', N'Ringer', N'Anne', N'801 826-0752', N'67 Seventh Av.', N'Salt Lake City', N'UT', N'84152', 1)
INSERT [dbo].[authors] ([au_id], [au_lname], [au_fname], [phone], [address], [city], [state], [zip], [contract]) VALUES (N'998-72-3567', N'Ringer', N'Albert', N'801 826-0752', N'67 Seventh Av.', N'Salt Lake City', N'UT', N'84152', 1)
/****** Object:  Default [DF__authors__phone__7E6CC920]    Script Date: 08/18/2009 21:52:32 ******/
ALTER TABLE [dbo].[authors] ADD  DEFAULT ('UNKNOWN') FOR [phone]
GO
/****** Object:  Check [CK__authors__au_id__7D78A4E7]    Script Date: 08/18/2009 21:52:32 ******/
ALTER TABLE [dbo].[authors]  WITH CHECK AD D CHECK  (([au_id] like '[0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9][0-9][0-9]'))
GO
/****** Object:  Check [CK__authors__zip__7F60ED59]    Script Date: 08/18/2009 21:52:32 ******/
ALTER TABLE [dbo].[authors]  WITH CHECK ADD CHECK  (([zip] like '[0-9][0-9][0-9][0-9][0-9]'))
GO