Column info in SQL Server 2005 - Database Discussion Boards

Mike Dimmick4-Jul-07 3:31

4-Jul-07 3:31

IF statements only control the next statement. They do not act as a block, despite your indentation. To control more than one statement, use BEGIN/END.

As a result, your code really looks like this:

Declare @stepid int
set @stepid = 1 --change to 2 after you have run the export
 
if @stepid = 1
    create table vendorbak (DCLink int, Account nvarchar(1000), Name nvarchar(1000))
 
select DCLink, Account, Name into VendorBak from Vendor where CT = 0
update Vendor set CT = 1
 
if @stepid = 2
    update Vendor set CT = 0 from VendorBak vb where Vendor.DCLink = vb.DCLink
 
drop table vendorbak

That means that when @stepid is 1, it will create the table, then do the SELECT INTO, then update, then drop the table.

Stability. What an interesting concept. -- Chris Maunder

Running a SQL Script file using C#

wasife3-Jul-07 19:25

wasife

3-Jul-07 19:25

Hi,
I have a T-SQL script file which i want to run using C#. Can any body please tell me how can i do it?

Regards,
Wasif.

Re: Running a SQL Script file using C#

Colin Angus Mackay3-Jul-07 22:44

Colin Angus Mackay

3-Jul-07 22:44

Running SQL Scripts with a .NET Application[^]

Upcoming events:
* Glasgow: Mock Objects, SQL Server CLR Integration, Reporting Services, db4o, Dependency Injection with Spring ...

"I wouldn't say boo to a goose. I'm not a coward, I just realise that it would be largely pointless."

Ready to Give up - Your help will be much appreciated.

My website

Re: Running a SQL Script file using C#

N a v a n e e t h4-Jul-07 3:33

N a v a n e e t h

4-Jul-07 3:33

Got a 404 for this page[^]

Navaneeth
My Website | Ask smart questions

Re: Running a SQL Script file using C#

Colin Angus Mackay4-Jul-07 7:00

Colin Angus Mackay

4-Jul-07 7:00

That wasn't on the page I linked to. Which page did that link come from?

Re: Running a SQL Script file using C#

N a v a n e e t h4-Jul-07 18:20

N a v a n e e t h

4-Jul-07 18:20

It was not the link what you referred. I bookmarked this link long back. And yesterday I tried to get it again and resulted in 404. I just thought of intimating you

My Website | Ask smart questions

Re: Running a SQL Script file using C#

Colin Angus Mackay4-Jul-07 21:26

Colin Angus Mackay

4-Jul-07 21:26

Navaneeth. wrote:
I bookmarked this link long back. And yesterday I tried to get it again and resulted in 404.

Ah... That website fell off the internet. The new link is: Types of Join[^]

Column info in SQL Server 2005

I.explore.code3-Jul-07 18:39

I.explore.code

3-Jul-07 18:39

Hi, I need to retrieve the column info only from a table that i created in the DB. Though I know it can be done using sys.objects/sys.columns, i do not know how to form the query. please help.

Re: Column info in SQL Server 2005

Tirthadip3-Jul-07 20:43

Tirthadip

3-Jul-07 20:43

Retrieving column names of a table

There are basically 3 approaches to this problem:

1.Use the sp_help procedure to get extended information about a
database object. By database object, we mean a table, view etc.

2.You can use the following select statement to retrieve a table’s columns:
SELECT TOP 0 * FROM table_name

3.The third approach, which I personally prefer, is using the schema object of SQL Server. For example, to retrieve the column names of Authors table, you can
use the following SELECT statement:
SELECT column_name FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME 'authors'

Which results in the following result set:

column_name<br />
----------------------------<br />
au_id<br />
au_lname<br />
au_fname<br />
phone<br />
address<br />
city<br />
state<br />
zip<br />
contract<br />
(9 row(s) affected)

Tirtha

Do not go where the path may lead, go instead where there is no path and leave a trail.

Author: Ralph Waldo Emerson (1803-82), American writer, philosopher, poet, essayist

DataTable Question using VB.NET

HurricaneDan3-Jul-07 9:14

HurricaneDan

3-Jul-07 9:14

I have a data table and I want to find the row in the data table that contains the string "Dan" in the third column of the data table but I am unsure how to do this.

I have looked at .find but it uses the PK, which is set in the original database but not in the data table. Is it possible to bring the PK and the field names from the database to the data table?

Thanks,

Dan

Re: DataTable Question using VB.NET

DanB19835-Jul-07 1:27

DanB1983

5-Jul-07 1:27

Hey

Can you not just iterate through each row checking the content of the third column?

Or maybe look at this:

http://msdn2.microsoft.com/en-us/library/system.data.datatable.primarykey(VS.80).aspx

Try looknig at datasets in msdn also they may be more suitable for the job as I am sure they retain the schema.

Hope this is of use

Dan

[Message Deleted]

R_L_H3-Jul-07 2:48

R_L_H

3-Jul-07 2:48

[Message Deleted]

Re: Can you access an nvachar OUT parameter?

originSH3-Jul-07 3:07

originSH

3-Jul-07 3:07

That article says if it's not being returned it's because you've done something wrong!

Whats your code in the client for getting the output param?

[Message Deleted]

R_L_H3-Jul-07 3:24

R_L_H

3-Jul-07 3:24

[Message Deleted]

Re: Can you access an nvachar OUT parameter?

originSH3-Jul-07 3:38

originSH

3-Jul-07 3:38

Tried SqlDBType rather than OleDbType? SqlDBType.NVarChar.

http://msdn2.microsoft.com/en-us/library/system.data.sqldbtype.aspx[^]

And whilst MS might not be perfect they're pretty good at making sure the basics work in sql server and .net :P I'd be extreamly suprised if it was thier bug stopping it being returned.

[Message Deleted]

R_L_H3-Jul-07 3:45

R_L_H

3-Jul-07 3:45

[Message Deleted]

Re: Can you access an nvachar OUT parameter?

originSH3-Jul-07 3:48

originSH

3-Jul-07 3:48

No probs

[Message Deleted]

R_L_H3-Jul-07 3:27

R_L_H

3-Jul-07 3:27

[Message Deleted]

Re: Can you access an nvachar OUT parameter?

originSH3-Jul-07 3:39

originSH

3-Jul-07 3:39

I gathered that Wink | ;)

You seemed pretty switched on so I took it your SP was right Smile | :)

Reporting Services:Check if File Exists, problem with IIS/NTFS Permissions

francorg2-Jul-07 22:59

francorg

2-Jul-07 22:59

In a report I want to check if a picture exists before showing it.
I put this function in the Report Properties:

Function DoesFileExist(PathnFileName As String) As Boolean
DoesFileExist = My.Computer.FileSystem.FileExists(PathnFileName)
End Function

And in the Visibility property of the image placeholder I call the DoesFileExist function.

Inside the MS Visual Studio Development Editor everything works fine, but when I deploy the report to the IIS Server and run it from there it doesn't work:
the DoesFileExist function always return "False" even if the pictures exist.

I'm 100% sure it's a permission problem, I tried to correctly set the permissions both on IIS and on NTFS Folder with no luck.

Please help.

Thank you,
Roberto

How to acccess the SQL database over a network

ozzyrocsdbn2-Jul-07 22:41

ozzyrocsdbn

2-Jul-07 22:41

Hello

I have a network running tcp/ip on 4 networked pc’s with windows xp home.

In my network places I can see the server(Windows xp pro) and all clients, I have created a user account in the Login sections in SQL management studio express , yet how do I access the databases from the client computers

What setting do I need to edit to allow my users to connect to the Server and its databases?
What permissions do I need to set I o the users?
What shares should be done?
Please can some one assist me.

Please email me on Ozzyrocsdbn@yahoo.com

Regrads Ozer

Re: How to acccess the SQL database over a network

originSH2-Jul-07 23:36

originSH

2-Jul-07 23:36

ozzyrocsdbn wrote:
Please email me on Ozzyrocsdbn@yahoo.com

Emailing the answer is bad, it means the answer isn't here for everyone else to benefit from.

ozzyrocsdbn wrote:
What setting do I need to edit to allow my users to connect to the Server and its databases?
What permissions do I need to set I o the users?
What shares should be done?
Please can some one assist me.

If your compleatly starting from scratch I'd recommend getting a good book on the subject. I don't personally know of any good beginner books sorry.

ozzyrocsdbn wrote:
What setting do I need to edit to allow my users to connect to the Server and its databases?

Here's how to configure Sql Server 2005 Express for remote access:

http://www.datamasker.com/SSE2005_NetworkCfg.htm[^]

ozzyrocsdbn wrote:
What permissions do I need to set I o the users?

Google:http://www.google.co.uk/search?hl=en&q=creating+a+user+in+sql+server+2005&meta=[^]

ozzyrocsdbn wrote:
What shares should be done?

You don't need any shares. Sql Server is network based not file based.

Re: How to acccess the SQL database over a network

ozzyrocsdbn3-Jul-07 1:11

ozzyrocsdbn

3-Jul-07 1:11

THANK YOU THE WEB ADDRESS ROCK MY NETWORK UP
btw. MY NETWORK IS AT HOME AND WE CODING A PROJECT FREE LANCE STYLE.

REGRARDS OZER

MICROSOFT ROCKS Smile | :)

Re: How to acccess the SQL database over a network

originSH3-Jul-07 1:19

originSH

3-Jul-07 1:19

How can i embed SQL Server 2000 system????

john84vn2-Jul-07 21:29

john84vn

2-Jul-07 21:29

I wanna include my SQL Server 2000 to my Project. So people needn't to install SQL Server 2000. They just install my software. It will automatic attach the database into a very-small SQL Server on my Disc. Could i do that?
If not, can you give me a solution that solve my problem???
The problem is Install software and its database without requiring the SQL Server.
Thanks
John

JohnJone

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