Create Enum!

Feb 6, 2007

hi, i'm new to sql. Any idea how to make enum type in micr. sql server management studio 2005. I need something like this:

field_name char enum ('I', 'J', 'K')


pleaase help me!

View 4 Replies


ADVERTISEMENT

LinqDataSource Using Enum In Where?

Dec 30, 2007

Not sure where the best place to ask this question is so I will ask it here.  I am trying to use the LinqDataSource ASP.NET 3.5 control and am having a problem with using the Where attribute.  I have a field that I want to filter on that is an Enumeration, however if I try to put the integer value in the Where attribute the page will not compile.  How do I use enum values in the Where attribute?
I have something like this:
public enum EventType{    Charger = 0,    Location = 1,    Scanner = 2}
I want to filter the LinqDataSource like this:
<asp:LinqDataSource ID="DataSource1" runat="server"        ContextTypeName="MyDataContext"        Table="Events"        Where="EventType = 2" />
This won't work.  The EventType property is an instance of the enum type above.    

View 2 Replies View Related

Enum Datatype In SQL Server?

Sep 21, 2007

hi guys,
is it possible to do a enum datatype in SQL Server? if so can anyone point me to an example please?
 
thanks,
benny
 

View 3 Replies View Related

Storing Enum Types In SQL

Jan 21, 2008

I have an asp.net custom class which has a property using Enum types. For information, it is an "orders" class and the property is "status", with types:
OrderStatus.OpenOrderStatus.CompletedOrderStatus.CancelledOrderStatus.Refunded
each order is stored as a row in a SQL database table. How can I store the Enum type in the database?
I assume that I could have an integer column with values 0 - 4 and convert to and from the integer/enum type each time an order is read or written, but it would be much better if I could store the enum type somehow without having to convert.
Any ideas?

View 1 Replies View Related

Enum The Running SQL Instances Using DMO

Feb 12, 2008

Hello,

I want to enumerate all the RUNNING SQL instances[in a mixed env where SQL 2000 and SQL2005 are deployed] using SQL DMO.
But any of the following methods would not help

ListAvailableSQLServers Method
ListInstalledInstances Method

because they list all the installed instances and while my intent is getting only the running instances.

Is there any other direct API ? Pls advise.

Regards,
Velu

View 1 Replies View Related

Any MySQL ENUM Eqvivalent In MSSQL?

Aug 28, 2006

Hi,

Can't seem to find a similar data type in MSSQL like the one very handy ENUM type existing in e.g MySQL:

... Enum('on','off','standby') ...

It's also a convinient way to check for true/false. I'd appreciate any suggestions on possible "workarounds" or sources that might point me in the right direction.

Best

View 1 Replies View Related

In ADO What Is Diffrence Between Cursortype Enum Values

Nov 25, 2006

hi

what is the diffrence between the cursor type of the recordset enumeration values in ADO

dynamic
openkeyset
static
forwardonly

thanks in advance.

View 3 Replies View Related

How To Use Database Values In An Enum Or Class, So Developer Has Intellisense Support....

Jan 17, 2007

I have a SQL database table with all languages used in my application.
I would like to use an enum or constant class with all the languages, so every developer of the app sees directly what languages are available.
Can this be done?

View 5 Replies View Related

Problems On Create Proc Includes Granting Create Table Or View Perissinin SP

Aug 4, 2004

Hi All,

I'm trying to create a proc for granting permission for developer, but I tried many times, still couldn't get successful, someone can help me? The original statement is:

Create PROC dbo.GrantPermission
@user1 varchar(50)

as

Grant create table to @user1
go

Grant create view to @user1
go

Grant create Procedure to @user1
Go



Thanks Guys.

View 14 Replies View Related

Boolean: {[If [table With This Name] Already Exists In [this Sql Database] Then [ Don't Create Another One] Else [create It And Populate It With These Values]}

May 20, 2008

the subject pretty much says it all, I want to be able to do the following in in VB.net code):
 
{[If [table with this name] already exists [in this sql database] then [ don't create another one] else [create it and populate it with these values]}
 
How would I do this?

View 3 Replies View Related

Create Variable To Store Fetched Name To Use Within BEGIN / END Statements To Create A Login

Mar 3, 2014

I created a cursor that moves through a table to retrieve a user's name.When I open this cursor, I create a variable to store the fetched name to use within the BEGIN/END statements to create a login, user, and role.

I'm getting an 'incorrect syntax' error at the variable. For example ..

CREATE LOGIN @NAME WITH PASSWORD 'password'

I've done a bit of research online and found that you cannot use variables to create logins and the like. One person suggested a stored procedure or dynamic SQL, whereas another pointed out that you shouldn't use a stored procedure and dynamic SQL is best.

View 3 Replies View Related

Dynamic Create Table, Create Index Based Upon A Given Database

Jul 20, 2005

Can I dynamically (from a stored procedure) generatea create table script of all tables in a given database (with defaults etc)a create view script of all viewsa create function script of all functionsa create index script of all indexes.(The result will be 4 scripts)Arno de Jong,The Netherlands.

View 1 Replies View Related

Can CREATE DATABASE Or CREATE TABLE Be Wrapped In Transactions?

Jul 20, 2005

I have some code that dynamically creates a database (name is @FullName) andthen creates a table within that database. Is it possible to wrap thesethings into a transaction such that if any one of the following fails, thedatabase "creation" is rolledback. Otherwise, I would try deleting on errordetection, but it could get messy.IF @Error = 0BEGINSET @ExecString = 'CREATE DATABASE ' + @FullNameEXEC sp_executesql @ExecStringSET @Error = @@ErrorENDIF @Error = 0BEGINSET @ExecString = 'CREATE TABLE ' + @FullName + '.[dbo].[Image] ( [ID][int] IDENTITY (1, 1) NOT NULL, [Blob] [image] NULL , [DateAdded] [datetime]NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]'EXEC sp_executesql @ExecStringSET @Error = @@ErrorENDIF @Error = 0BEGINSET @ExecString = 'ALTER TABLE ' + @FullName + '.[dbo].[Image] WITHNOCHECK ADD CONSTRAINT [PK_Image] PRIMARY KEY CLUSTERED ( [ID] ) ON[PRIMARY]'EXEC sp_executesql @ExecStringSET @Error = @@ErrorEND

View 2 Replies View Related

Create Script To Create/Refresh Identical Database

Mar 26, 2008



I'm new to using SSIS and have been reading and learning slowly how to use it. I'm trying to create an identical copy of our database for reporting. I've used the Import/Export wizard, but have had some issues with foreign keys and with sql_variant columns.

I've tried searching for anything but haven't had any luck as of yet. I guess I don't even know where to start or what to look for.

Any help would be appreciated. Thanks!

View 9 Replies View Related

Grant CREATE VIEW, CREATE PROCEDURE ...

Apr 12, 2006

Hi,

I have currently a problem with setting up the permissions for some developers. My configuration looks like this.

DB A is the productive database.

DB B is a kind of "development" database.

Now we have a couple of users call them BOB, DAVID, ...

who are members of the db role db_reader and db_writer for the productive db a but they should be allowed to do nearly everything on db b.

Therefor I added them to the db role db_owner for db b.

For testing purposes I tried to "CREATE" a view TEST as BOB in database B but I received the error message

'Msg 262, Level 14, State 1, Procedure Test, Line 3

CREATE VIEW permission denied in database 'b'.'

I cross checked the permissions on db level and I even granted all available permissions on db level but nevertheless I receive this error message.

What's my mistake?

Of course it worked fine when I give them sysadmin rights but then they have far too much permissions.

Regards,

Stefan

View 8 Replies View Related

Create INDEX Within CREATE TABLE DDL

Jan 27, 2006

Hi Minor and inconsequential but sometimes you just gotta know: Is it possible to define a non-primary key index within a Create Table statement? I can create a constraint and a PK. I can create the table and then add the index. I just wondered if you can do it in one statement. e.g. I have: CREATE TABLE MyT (MyT_ID INT Identity(1, 1) CONSTRAINT MyT_PK PRIMARY KEY Clustered, MyT_Desc Char(40) NOT NULL CONSTRAINT MyT_idx1 UNIQUE NONCLUSTERED ON [DEFAULT])which creates a table with a PK and unique constraint. I would like (pseudo SQL):CREATE TABLE MyT (MyT_ID INT Identity(1, 1) CONSTRAINT MyT_PK PRIMARY KEY Clustered, MyT_Desc Char(40) NOT NULL CONSTRAINT MyT_idx1 UNIQUE INDEX NONCLUSTERED ON [DEFAULT]) No big deal - just curious :D Once I know I can stop scouring BOL for clues. Tks in advance

View 2 Replies View Related

Convert Mysql Create Script To SQL Server Create Script

Mar 29, 2008

Hi guys

Just a quick one. I have some create scripts that were created for mysql and i am wanting to convert them to a

SQL Server create script. I am just wondering if anyone knows of any utilities or codeplex projects, etc that can perform the convert process.



The script is fairly basic but it is not fully compatible but i have a lot of them thus why i want to automate the process. The majority of the script is just table create statements like the following:





Code Snippet
-- -----------------------------------------------------
-- Table `dbo`.`Staff`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `dbo`.`Staff` (
`StaffId` INT NOT NULL AUTO_INCREMENT ,
`IndividualId` INT NOT NULL DEFAULT 0 ,
`PositionId` INT NOT NULL DEFAULT 0 ,
`EmploymentStartDate` DATETIME NULL ,
`EmploymentEndDate` DATETIME NULL ,
`SupervisorStaffId` INT NULL ,
`TerminatedEmploymentReasonId` INT NULL ,
`DeletedFl` BIT NOT NULL ,
`CreateDateTime` DATETIME NOT NULL ,
`CreateUserId` INT NOT NULL ,
`ChangeUserId` INT NOT NULL ,
`ChangeDateTime` DATETIME NOT NULL ,
`VersionNum` INT NOT NULL ,
PRIMARY KEY (`StaffId`) ,
INDEX Individual_Staff_IndividualId_Ref (`IndividualId` ASC) ,
INDEX Lookup_Staff_PositionId (`PositionId` ASC) ,
INDEX Staff_Staff_SupervisorStaffId_Ref (`SupervisorStaffId` ASC) ,
INDEX Lookup_Staff_TerminatedEmploymentReasonId (`TerminatedEmploymentReasonId` ASC) ,
CONSTRAINT `Individual_Staff_IndividualId_Ref`
FOREIGN KEY (`IndividualId` )
REFERENCES `dbo`.`Individual` (`IndividualId` )
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `Lookup_Staff_PositionId`
FOREIGN KEY (`PositionId` )
REFERENCES `dbo`.`Lookup` (`LookupId` )
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `Staff_Staff_SupervisorStaffId_Ref`
FOREIGN KEY (`SupervisorStaffId` )
REFERENCES `dbo`.`Staff` (`StaffId` )
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `Lookup_Staff_TerminatedEmploymentReasonId`
FOREIGN KEY (`TerminatedEmploymentReasonId` )
REFERENCES `dbo`.`Lookup` (`LookupId` )
ON DELETE NO ACTION
ON UPDATE NO ACTION);







Thanks for the help

Anthony



Note: i know if you have a mysql database you can go from one to the other, but i specifically need to take these mysql create scripts and convert them to sql server create scripts and there are a LOT of them i.e. more than 1000 script files that each contains a couple of hundred table create statements.

View 4 Replies View Related

Is The Operation CREATE MINING STRUCTURE And CREATE MINING MODEL Really Useful?

Aug 17, 2006

Hi,

I've tried those two operations in the Management Studio.
Though we can create a mining structure and mining model in Management Studion,
but we cannot process the analysis-service database.

(1) I create only a mining structure through CREATE MINING STRUCTURE.
No error reported. But if I process the analysis-service database in Management Studio I always get error

'Error : The '<mining_structure__name>' structure does not contain bindings to data
(or contain bindings that are not valid) and cannot be processed.

I then tried to create it by creating and running an XMLA script. It was successful.
However, it's much harder to learn XMLA.

If any of you created an analysis-service database in Mgt Studio, and create a mining
structure in the same place using DMX script, can you process the database?

(2) Is there any use of CREATE MINING STRUCTURE operation without binding
to any table? Examples I saw so far did not show relating it to do. In my experience
processing the analysis-service database with that mining structure is doomed to fail.

(3) Is there any way we can create mining structure through CREATE MINING

STRUCTURE operation in Management Studio and use RELATED TO clause

to bind it to any Relationship to an attribute column (mandatory only if it applies), indicated by
the RELATED TO clause

(4) If this is the fact, is there any use of CREATE MINING STRUCTURE operation?
If we use BI Dev Studio, it's much easier to use the wizard.

(5) I found I cannot create a mining model inside a mining structure through operation
CREATE MINING MODEL. If you call that operation, you end up having a mining
model and a mining structure with the same name. I found that in order to create a
mining model inside a mining structure you have to call operation ALTER MINING
STRUCTURE ADD MINING MODEL. Is it true this is the only way?

Thank you,

Bernaridho

View 3 Replies View Related

Cant Create New Database / CREATE DATABASE Permission Denied In Database Master (error 262)

Oct 2, 2007

 
 I am using SQL express and Visual web developer on windows Vista.
When I try to create a new database the following message appears.
 
CREATE DATABASE permission denied in database master (error 262)
I log on to my computer as an administrator.
Help appreciated
 Prontonet
 
 
 

View 4 Replies View Related

Create Table From Text File, Extract Data, Create New Table From Extracted Data....

May 3, 2004

Hello all,

Please help....

I have a text file which needs to be created into a table (let's call it DataFile table). For now I'm just doing the manual DTS to import the txt into SQL server to create the table, which works. But here's my problem....

I need to extract data from DataFile table, here's my query:

select * from dbo.DataFile
where DF_SC_Case_Nbr not like '0000%';

Then I need to create a new table for the extracted data, let's call it ExtractedDataFile. But I don't know how to create a new table and insert the data I selected above into the new one.

Also, can the extraction and the creation of new table be done in just one stored procedure? or is there any other way of doing all this (including the importation of the text file)?

Any help would be highly appreciated.

Thanks in advance.

View 3 Replies View Related

Create Procedure To Create Many Triggers And Procedure

Apr 19, 2002

Hi guys.

I am trying to create a procedure which should drop all existing triggers and can create about 40 differnt triggers in a table.

I cant use "GO" statement in a procedure.

Is there any way to create a procedure like that?

I dont want to run this as a script.

please advice.


--Note: Many triggers use same kind of variable names inside.

-MAK

View 1 Replies View Related

Need To Create Dbo

Apr 24, 2001

i need to create a dbo in new databases that i made. i sent them to another SQL server and they do not have any users and especially do not have a dbo as one of the users. i really would like to have detailed directions on this. i know that i've done it before, but i'm beggining to think that it might have been just by accident. thanks!

View 1 Replies View Related

How To Create A Job From VB6 ?

Apr 6, 2000

Hello,

I need to create a Job from a VB6 application. How to do it ? Somebody Knows ?

Thank you.

Hugo Venturini Loureiro

View 1 Replies View Related

DSN Create...

Jun 1, 2006

I am used to MySQL, so all this MSSQL is a bit new to me..


so I am writnig a perl script to connect to a database and do some querying.

I have to get a DSN to a specific database on my local machine. How do I do this?


I have created a DSN but it just points, it seems, to the machine and not the database itself....

help?

View 1 Replies View Related

Create New Db

Aug 17, 2004

Greetings,
Using a server base database called Respond (fe) and Sql server 2000 as a (be), I was trying to create a new db. Instead of designing from scratch, I was thinking to copy an existing Respond db, delete existing data, and modify it to fit my new requirements. I'm new to sql server db and would like to know
1. How to delete data from the table (be).
2. How to perform an automatic backup daily (or may be every other day) and how to check if the backup is doing what it was suppose to do in sql server 2000.

Thank you in advance,

OCM

View 3 Replies View Related

Where Should I Create ERD?

Oct 4, 2006

Hello, everyone:

Does anyone offer the idea where I should create ERD in SQL Server? And how?

Thanks a lot.

ZYT

View 4 Replies View Related

Help To Create Job

Mar 2, 2004

i want to give to my user permission to create job , add step to job etc.
i can't do this when my user do not use sa user but i don't want to give him the sa password so how can i do this
eytanb@mekorot.co.il

View 1 Replies View Related

How To Create

May 13, 2008

How to create full_text index table

View 1 Replies View Related

Can't Create SP

Sep 5, 2006

create proc usp_CatchAddressException @tableName varchar(500) as

set nocount on
begin
declare @sql varchar(500)

truncate table #tempException

set @sql = 'insert #tempexception (id_town, id_voter, ad_str1, nmb_exception )
select a.id_town, a.id_voter, substring(a.ad_str1, 1, len(a.ad_str1) - charindex(' ', reverse(a.ad_str1))), '20'
from HAVA_DCDE.dbo.' + quoteName(@tableName)+ ' a
where substring(a.ad_str1, 1, len(a.ad_str1) - charindex(' ', reverse(a.ad_str1))+1) not in (select nm_street from state_streets )
and a.id_town = '00519''

print (@sql)
exec(@sql)
end



Server: Msg 170, Level 15, State 1, Procedure usp_CatchAddressException, Line 10
Line 10: Incorrect syntax near ', reverse(a.ad_str1))), '.


i cant find where my mistake is. can someone give some inputs?

View 3 Replies View Related

Create FK

Jan 31, 2007

This is a really basic question but how to I create a relationship between two tables using the Microsoft SQL 2005 Management Studio?

I have created the two tables but I can't find where to create the relationship.

Thanks,
Miguel

View 1 Replies View Related

Create

Nov 28, 2007

Hello!

thanks!

View 5 Replies View Related

How To Create...

Apr 11, 2007

how to create reports without using business intelligence development studio

plz give me a more explanatory answer as how to start with using reporting wizard or report builder or something



thanks

sally

View 1 Replies View Related

How To Create A SQL Ev DB?

Jul 31, 2006

Good day All

I'm new to databases with C#

There are lots of good examples that use an already existing SQLev db and vs2005, but I'm trying to use VS2005 standard to create the SQLev DB (table, etc), when I try to add a new item, is see only the .mdf selection. (I don't have Full SQL Server or SQL Express on my machine, if that means anything)

Can you please tell me how or point me to an tutorial

Thanks

Mike Greenway

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved