Re: Creating a database

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Adrian,

For as long that you don't have the books, how to use this in an SP is
basic, if you don't know how to do that, than you really need as a book.

http://www.vb-tips.com/dbpages.aspx?ID=73eab21d-db5f-46b2-8eea-6680e677e994

I hope this helps,

Cor

"Adrian" <00@xxxxx> schreef in bericht
news:4512ba08$0$738$5fc3050@xxxxxxxxxxxxxxxxxxxxxxxxxxx
I am new to stored procedures.
Is the code below a stored procedure?
It doesn't have "CREATE PROCEDURE" in the code.
How should I incorporate the code below in a C#.NET application?

Thank you,
Adrian.

USE master
GO
CREATE DATABASE Products2
ON
( NAME = prods2_dat,
FILENAME = 'c:\program files\microsoft sql
server\mssql\data\prods2.mdf' )
GO





.

Relevant Pages

  • Re: Defining own constants
    ... create FUNCTION constant ) ... DECLARE @value int ... > Instead of writing my stored procedure like: ... > FROM Books ...
    (microsoft.public.sqlserver.programming)
  • Crystal Report from DataSet or Stored Procedure with Params
    ... a Crystal Report in VS.NET 2003 with no luck. ... two ASP.NET books. ... is get data from my SQL server stored procedure onto a VS.NET crystal report. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Defining own constants
    ... of defining a function to return "constant" values. ... > Instead of writing my stored procedure like: ... > FROM Books ... > Mats-Lennart ...
    (microsoft.public.sqlserver.programming)
  • Re: Defining own constants
    ... Brad Shook ... Programmer/Analysts II ... > Instead of writing my stored procedure like: ... > FROM Books ...
    (microsoft.public.sqlserver.programming)
  • Re: Crosstab REPORT, not query
    ... you can use the 'Database Tuning Advisor' against the SQL ... other books on ADP? ...
    (microsoft.public.access.adp.sqlserver)