Database Discussion Boards

Re: How to create stored procedure in SQL Server 2005

compad6-Aug-08 22:55

6-Aug-08 22:55

Thanks for your reply.

can u have anything more. something like data types, how to declare variable, how to check condition. I am aware of Oracle Procedure. Is the same syntax or something different.

Please Help me
Adarsh

Re: How to create stored procedure in SQL Server 2005

Colin Angus Mackay6-Aug-08 23:10

Colin Angus Mackay

6-Aug-08 23:10

compad wrote:
how to declare variable

DECLARE @myVariable int -- or what ever type you want.

compad wrote:
how to check condition

IF @myVariable = 123
BEGIN
   ... Some SQL Code Here
END
ELSE
BEGIN
   ... Some other SQL Code here
END

compad wrote:
I am aware of Oracle Procedure. Is the same syntax or something different.

You might want to read the documentation.

Recent blog posts:
*SQL Server / Visual Studio install order
*Installing SQL Server 2005 on Vista
*Tip of the Day - SysInternals
* Meme

My Blog

Re: How to create stored procedure in SQL Server 2005

compad6-Aug-08 23:14

compad

6-Aug-08 23:14

Thanks a lot

I got it.

Adarsh

Re: How to create stored procedure in SQL Server 2005

nelsonpaixao6-Aug-08 14:34

nelsonpaixao

6-Aug-08 14:34

hi, you have to download some tutorial first Poke tongue | ;-P

nelsonpaixao@yahoo.com.br

Re: How to create stored procedure in SQL Server 2005

compad6-Aug-08 22:56

compad

6-Aug-08 22:56

Thanks for your help

If you have any link for tutorial. please forward it to me.

Thanks
Adarsh

Re: How to create stored procedure in SQL Server 2005

Colin Angus Mackay6-Aug-08 23:10

Colin Angus Mackay

6-Aug-08 23:10

compad wrote:
If you have any link for tutorial. please forward it to me.

Can you not use a search engine? The search term "SQL Server Tutorial" will probably give you lots of links to helpful websites.

Recent blog posts:
*SQL Server / Visual Studio install order
*Installing SQL Server 2005 on Vista
*Tip of the Day - SysInternals
* Meme

My Blog

Re: How to create stored procedure in SQL Server 2005

new2pgrmg6-Aug-08 22:32

new2pgrmg

6-Aug-08 22:32

Hi Adarsh,

Open SQL Server

Create a database like "Test"

Open that database

You will find programability--open it you will find stored prtocedure.

Rite click ....select new stored procedure

A query window will come

paste ur SP and run

It will get added to your SP

For further questions mai me at jijuanair@gmail.com

Hope this helps

Indexs

janakinandhu5-Aug-08 23:42

janakinandhu

5-Aug-08 23:42

Details about Indexes

Re: Indexs

sunil goyalG5-Aug-08 23:52

sunil goyalG

5-Aug-08 23:52

yaa .Why not ? click Index Details[^]

All database names query ?

rajg825-Aug-08 22:51

rajg82

5-Aug-08 22:51

Hi,
Can anyone please provide a query by which we can get names of all the database with there sizes.

thx

raj

Re: All database names query ?

Blue_Boy5-Aug-08 23:26

Blue_Boy

5-Aug-08 23:26

In SQL 2005 use:

SELECT *<br />
FROM   sys.databases

I Love T-SQL
"Don't torture yourself,let the life to do it for you."

Requirement on Server Machine and Client Machine

Rupsaa5-Aug-08 21:42

Rupsaa

5-Aug-08 21:42

hi all,
i Know this is the Stupid question of the day . but i am new to SQL server so i ask this question. I make a application which use SQL Server Express as a back end.I want to deploy this application on Client Machines. Application Database must be Installed on single machine ( mean on Server) and Application must be installed on all remaining machine. So what setup is required on Server machine and all remaining machine.Please suggest how can i perform this thing in VB.NET

SQL Server 200

waqas_2k5-Aug-08 21:10

waqas_2k

5-Aug-08 21:10

I am using SQL Server 2000 on back end and .Net C sharp on front end. Server is connected with more than 30 users.

On user’s computers there are different files having different formats like MS Word, Excel, Txt and Visio etc with more than 4 MB size.

I want to see these files through database, edit, save them and resend to users through database on LAN.

How Can I Do All This in Window Application without sharing any directory?

Best Regards and Thanks for your kind Help:

Re: SQL Server 200

topcatalpha6-Aug-08 21:32

topcatalpha

6-Aug-08 21:32

If you want to pass them using the database, check out storing binary data in a table.
SQl 2005 support large data as binary, i suppose SQL 2000 has the image (or text but is limited) field for this.

Otherwise you'll can store the IP Addresses of each client and send it using the windows socket.

Another way to do it is using a FTP server and store and retrieve them bij using FTP connections.
It's called FILE Transfer Protocol for some reason Smile | :)

the choice is your's...

greetz

Kurt

Need to create tables with different culture

Satish - Developer5-Aug-08 20:04

Satish - Developer

5-Aug-08 20:04

Hi, I have a requirement that as follows
In front end i have a dropdown with options English, Spanish, German,
chinese, Japan etc.

What ever the language i have selected in dropdown, i need to create a table to store the corressponsindg language data. I am not knowing how to create a table with culture specific? For each language, different table to be created.

Can any one help on this? If possible, plz provide code for me. or modify the below code

This code is general for creating a table

CREATE TABLE [dbo].[Tbl_Names]
(
[SeedID] [int] IDENTITY(1,1) NOT NULL,
[Indian_First_Names] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Indian_Last_Names] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Gender] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Culture] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
)
ON [PRIMARY]

G. Satish

Re: Need to create tables with different culture

mghiassi6-Aug-08 7:51

mghiassi

6-Aug-08 7:51

you must use two table with foreign key in another table.

One table include (SeedID,FirstName,LastName,Gender and CultureID foreign key) and another table include(CultureID PrimeryKey,Culture)

Repost of Xquery Solution

Member 31863655-Aug-08 18:27

Member 3186365

5-Aug-08 18:27

This is the repost as my code snippet was not formatted correctly.
I have got a field in a table which is of xmltype, say file_block
the data for the same is structured as shown below

<data type="Structure">
<control id="txtWeight">
<value>74</value>
</control>
<control id="txtHeight">
<value>174</value>
</control>
</data>

And the above structure is taken in different ways for different
purposes in project so i cannot change that
DATA VALUE
txtWeight 74
txtHeight 174
Now how could i retrieve the data as a tabular structure as shown above using xquery. Please help if anyone know how to do that

Re: Repost of Xquery Solution

leoinfo8-Aug-08 2:24

leoinfo

8-Aug-08 2:24

Are you still having troubles with this?

Please... SAVE my time by rating the posts that you read!

There are 10 kinds of people in the world: those who understand binary and those who don't.

Xquery solution needed

Member 31863655-Aug-08 18:22

Member 3186365

5-Aug-08 18:22

I have got a field in a table which is of xmltype, say file_block
the data for the same is structured as shown below

data type="Structure">
control id="txtWeight">
value>74/value>
/control>
control id="txtHeight">
value>174/value>
control>
/data>

(I have removed the '<' tags from the xml code as codeproject
is only taking the content 174 and 74 only while removing all other
codes as they are treating the code as a formatted one... So
please read my code by prepending the appropriate line with '<')
Now I want to retrieve the values from it as follows

Data Value
txtWeight 74
txtHeight 174

And the above structure is taken in different ways for different
purposes in project so i cannot change that. Now how could i retrieve the data as a tabular structure as shown above using xquery. Please help if anyone know how to do that.

How can i Do this work Programmatically for SQL EXPRESS 2005

sunil goyalG5-Aug-08 7:20

sunil goyalG

5-Aug-08 7:20

hi all,
I want to do following task as programmaticaly (not manually) to Allow Remote Connection
1.Enable the Shared memory, Named Pipes, TCP/IP protocols in SQL Server Configuration.
2.Allow Local And Remote connection which we perform IN SQL Surface area configuration.
3.Restart SQL Browser and SQL Server After making changes.
4.Create Login on Remote SQL Server

I face above problem when i Installed SQL Express on one machine and Try to connect to Remote SQL Server. Also if I want to Connect to Remote server, then Guest Account(or SQL Authentication) must be Configured on Remote machine. So how can i Configure the Account on remote server Programmatically or how can i Get the Configured account which is on Remote server . so using this account information i can connect to Remote SQLServer.

one more thing I am able connect to Remote server using trusted connection but failed to connect to Database. I use Following statement to connect to Remote SQL Server

Dim MainServer As Server = New Server(cboServer.Text.Trim & "\SQLEXPRESS")<br />
        With MainServer.ConnectionContext<br />
            .LoginSecure = True<br />
            .ConnectionString = "Trusted_Connection=Yes;"<br />
            .Connect()<br />
            .PublicServerName = cboServer.Text.Trim<br />
            frmLogin.Show()<br />
            Me.Close()<br />
            .Disconnect()<br />
        End With

but i am unable to Use Databse which reside on Remote server. I use following connection string

Dim ConnectionString As String = "Data Source=" & PublicServerName & "\SQLEXPRESS;Integrated Security=True;Initial Catalog=ABC "

Dim ConnectionString As String =Data Source=" & PublicServerName & "\SQLEXPRESS;Initial Catalog=ABC;Trusted_Connection=Yes; "'

but this time it give error "Login failed for user MachineName\Guest"

I try lot of googling but nothing is helpful. Please provide appropriate guidance to me

Re: How can i Do this work Programmatically for SQL EXPRESS 2005

Wendelius5-Aug-08 7:28

Wendelius

5-Aug-08 7:28

Hi,

You can use SAC command line utility for importing configurations. Restarting services would be most easy with NET START / NET STOP commands and after that the login can be created using T-SQL (CREATE LOGIN).

Hope this helps,

Mika

Re: How can i Do this work Programmatically for SQL EXPRESS 2005

sunil goyalG5-Aug-08 21:21

sunil goyalG

5-Aug-08 21:21

sir, can i change the default setting during installation of SQL Server.Importanat thing is that i want to Install SQL Server In Silent mode and i want to change all specified setting during Installation

Re: How can i Do this work Programmatically for SQL EXPRESS 2005

Wendelius6-Aug-08 7:07

Wendelius

6-Aug-08 7:07

Ok,

Most of the settings can be configured during silent installation. The key is TEMPLATE.INI-file. Have a look at this article http://msdn.microsoft.com/en-us/library/ms144259.aspx[^].

I don't remember if all of the things you wanted to do are possible. For example login creation may not be possible, but you can always use a custom command line script, which first runs install and configuration and then use (for example) OSQL to create login silently.

Hope this helps,

Mika

Comprare two column headings

DFlat4Now5-Aug-08 6:24

DFlat4Now

5-Aug-08 6:24

I have one table and the columns are exactly as they should be. I am sent new data that needs to match the columns headings of this first table exactly. How do I create a sql query (it's really in Access) that does a quick compare and show me any differences or how the new violates the standard?

Re: Comprare two column headings

DerekFL5-Aug-08 7:02

DerekFL

5-Aug-08 7:02

By violates do you mean violates a foreign key?

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.