Database

FirstPrevNext

Re: Multiple User tables? LongRange.Shooter16-Mar-07 7:51 LongRange.Shooter 16-Mar-07 7:51  First at the DB security level you create roles of student, teacher, sysAdmin Next you create only one user table and define your users. Finally you bind each user to a specific role and use permissions to define the CRUD for each role. converting topcatalpha16-Mar-07 1:07 topcatalpha 16-Mar-07 1:07  hi, anyone any idea if there is some SQL syntax for converting an integer to hexadecimal ? Thx Kurt Re: converting topcatalpha16-Mar-07 1:26 topcatalpha 16-Mar-07 1:26  i've found HEX in the books online but seems that it isn't available in SQL2005... but i've found this (ofcourse microsoft undocumented) one : DECLARE @x BINARY(16) ( or int if you please) SET @x = 255 SELECT master.dbo.fn_varbintohexstr(@x) greetz... Re: converting Mike Dimmick16-Mar-07 2:17 Mike Dimmick 16-Mar-07 2:17  SQL Server is not designed to present data. It is designed to store and retrieve data efficiently. If you need to show integers in hexadecimal in your application, make the client-side application do it. The same goes for things like string concatenation. Stability. What an interesting concept. -- Chris Maunder Re: converting topcatalpha16-Mar-07 2:47 topcatalpha 16-Mar-07 2:47  That's true, but the (my concept) SQl server needs to prepare some things so the (dum and transparant) applications just need to pickup data end send it to hardware... if the hardware gets a firmware update we don't need to replace all the applications, we only need to modify one stored proc.. so easy to maintain.. the apps are installed on embeddeds also so we don't want them to do a lot of time absorbing work. ofcours we can also use services on the server who can do the work but that takes a lot of extra work and my experience is that MSSQL is very powerfull en can handle those things without any problems.. but i guess this is my opinion..ofcourse any suggestions or better concepts to do this are very welcome.. Thx.. Kurt Re: converting topcatalpha19-Mar-07 1:33 topcatalpha 19-Mar-07 1:33  So why are stored procedures, views and functions implemented in MSSQL then ? i solve things this way : insert into A select fielda, fieldb, LEFT(fieldc, 50) from B Where fieldd = 1 i suppose retrieve all the 50.000 records to a service truncate the string in the client app and sending 50.000 update records from a client app to your MSSQL server is taking more time then this query... greetz.. tell me if i'm wrong. Embedding Reports Within a cell !!! fulbright15-Mar-07 20:46 fulbright 15-Mar-07 20:46  I am new to reports so might this question seamed stupid ... I am using Report Application Sever .I create a table and populate all the data required.Now I want to create a cross-tab (pivot table) instead and embed a report within the cell of cross-tab ... is it possible ? Best Regards, Madni hidden views in SQLServer Maira K15-Mar-07 20:06 Maira K 15-Mar-07 20:06  hi , i have created views in database Test, in sqlServer.when i had to import Test to another database Test1, the views become hiddden. i can't see the views and when i try to create them again, i get this msg: There is already an object named 'view1' in the database. so how can i resolve this problem? thanks, Re: hidden views in SQLServer coolestCoder16-Mar-07 2:00 coolestCoder 16-Mar-07 2:00  Hi, check whether the views are converted to tables. "A good programmer is someone who looks both ways before crossing a one-way street." -- Doug Linder coolestCoder Write SQL that will remove PK and set it to another column steve_rm15-Mar-07 18:23 steve_rm 15-Mar-07 18:23  Hello, I have a table with a primary key on Serial No. I need to add a new column called softwareID and set that to the new primary Key. It is possible to write some sql what will remove the PK from Serial No, and set the softwareID as the new PK? I was thinking about dropping the table and creating a new one, but I don't want to lose the data. Many thanks, Steve Re: Write SQL that will remove PK and set it to another column Harini N K15-Mar-07 19:04 Harini N K 15-Mar-07 19:04  Hi Check this example : http://www.sqlmag.com/Files/23/22081/Listing_03.txt[^] Harini Change schema, without destroying the data steve_rm15-Mar-07 18:13 steve_rm 15-Mar-07 18:13  Hello, I have a sql 2005 server database and using .Net 2005. The client has a database when contains all there business data. In the currently I have been making changes to the schema i.e. creating new table, altering procedures, etc. All these has been done by writing the scrips and when the program installs it will execute these scripts. The customer gets an update every few months. However, the updates are becoming more and more frequent and also becoming more complex and sometimes difficult to keep track of all the table's schema. Is it possible to send them a backup so that they can restore it with all the changes I have made to the schema without destroying all their data? Is there any software that can be used to automate this process? What could make this difficult as we are in different offices. Development office and the customer's office in different countries. Many thanks for any advice, Re: Change schema, without destroying the data Mark J. Miller19-Mar-07 5:53 Mark J. Miller 19-Mar-07 5:53  Try using Red-Gate SQL compare. You can use it to compare both schema and data and it can be automated using .Net scripts. The best thing to do would be to keep a backup of the schema for each series of updates. When you make a new release, create a backup. Then the next time you need to release a new set of changes, restore the last backup to a place where you can run SQL compare to generate the change scripts. Then you can send those scripts with your update to the customer. the database has been placed in state by user "Admin" charleslau285515-Mar-07 15:39 charleslau2855 15-Mar-07 15:39  hi, Everyone know this error? the database has been placed in state by user "Admin"! We are using a shared database in access databases. When more than one user has connect to my databases by my application (my program developed by vb.net) at the same time, the following error message appears. "The database has been placed in a state by user 'Admin' on machine XXXXX that prevents it from being opened or locked." * Although i already add the "Persist Security Info=False;Mode=Share Deny None" in my OleDbConnection, it still got same error! How to solve this error? please help! My following code as below: Try DB = New OleDbConnection("Provider=microsoft.jet.oledb.4.0; data source=C:\prdsystem\prdnsf.mdb; Persist Security Info=False;Mode=Share Deny None") DB.Open() Catch ex As Exception MsgBox(ex.Message, MsgBoxStyle.Information, "") End End Try Da = New OleDb.OleDbDataAdapter(sql, DB) Ds = New DataSet Da.Fill(Ds, "emp") Creating a SqlDbType.SmallDateTime parameter digsy_15-Mar-07 8:08 digsy_ 15-Mar-07 8:08  I'm trying to create a SqlDbType.SmallDateTime parameter and have been unable to find the correct answer. I'm trying to take a date in mm/dd/yyyy format from a text box and pass it to a stored procedure. This is about as close I have got but it still doesnt work: SelectCommand.Parameters.Add("@dateofbirth", SqlDbType.SmallDateTime).Value = DateTime.Parse(StoredProcedureValues[3]).ToShortDateString(); Does anyone know what the answer is ? Thanks Re: Creating a SqlDbType.SmallDateTime parameter Marcus J. Smith15-Mar-07 9:35 Marcus J. Smith 15-Mar-07 9:35  When you are adding a datetime value of any sort to a database leave it in a date, I mean DATE, format if possible. Otherwise you must format it correctly to insert. So ensure that the value you are parsing to DateTime is a date value and dont set it to short date string. SmallDateTime is about precision not how it looks in the DB[^] CleaKO "I think you'll be okay here, they have a thin candy shell. 'Surprised you didn't know that." - Tommy Boy "Fill it up again! Fill it up again! Once it hits your lips, it's so good!" - Frank the Tank (Old School) error of duplicate PK in subscriber database Rocky#15-Mar-07 6:14 Rocky# 15-Mar-07 6:14  hi every one, well I've set up transactional replication here and the problem is that when I try to insert a new record at the subscriber it gives me an error that the primary key is being dupicated. I have the NOT FOR REPLICATION Option for the ideantity column but its not working.. can u plz help me thanks in advance Rocky Add Multiple ColumnValue to a SingleColumn Sarfaraj Ahmed15-Mar-07 3:47 Sarfaraj Ahmed 15-Mar-07 3:47  Hello EveryBody I got 2 Table Customer and Order Customer Table got two column CustomerID, CustomerName Order Table got Two Column OrderID, ProductID CustomerTable: CustomerID CustomerName 101 James 102 Andy 103 Bryan OrderTable: OrderID ProductID CustomerID 1001 10001 101 1002 10002 101 1003 10003 101 1004 10004 102 1005 10005 102 1006 10006 103 I want the output as below CustomerID CustomerName OrderID ProductID 101 James 1001,1002,1003 10001,10002,10003 102 Andy 1004,1004 10004,10005 103 Bryan 1006 10006 Please help me. Thanks Sarfarj Ahmed Re: Add Multiple ColumnValue to a SingleColumn Marcus J. Smith15-Mar-07 4:26 Marcus J. Smith 15-Mar-07 4:26  SELECT Column1 & ', ' & Column2 & ', ' & Column3 & ', ' & Column4 FROM TableName WHERE Whatever Try something along those lines. CleaKO "I think you'll be okay here, they have a thin candy shell. 'Surprised you didn't know that." - Tommy Boy "Fill it up again! Fill it up again! Once it hits your lips, it's so good!" - Frank the Tank (Old School) Re: Add Multiple ColumnValue to a SingleColumn Sarfaraj Ahmed15-Mar-07 4:47 Sarfaraj Ahmed 15-Mar-07 4:47  getting error message Msg 402, Level 16, State 1, Line 1 The data types nchar and varchar are incompatible in the boolean AND operator. Sarfarj Ahmed Re: Add Multiple ColumnValue to a SingleColumn Marcus J. Smith15-Mar-07 5:16 Marcus J. Smith 15-Mar-07 5:16  Try replacing the & with +. CleaKO "I think you'll be okay here, they have a thin candy shell. 'Surprised you didn't know that." - Tommy Boy "Fill it up again! Fill it up again! Once it hits your lips, it's so good!" - Frank the Tank (Old School) Re: Add Multiple ColumnValue to a SingleColumn Sarfaraj Ahmed15-Mar-07 5:25 Sarfaraj Ahmed 15-Mar-07 5:25  Still Getting Error Please send me an Example with SQL code Thanks Sarfarj Ahmed Re: Add Multiple ColumnValue to a SingleColumn Marcus J. Smith15-Mar-07 5:31 Marcus J. Smith 15-Mar-07 5:31  Ahhh, you need to ensure that all types are the same. So if you have some int datatypes along with varchar or char you need to cast the int to a varchar. CAST(IntColumn as varchar(length)) CleaKO "I think you'll be okay here, they have a thin candy shell. 'Surprised you didn't know that." - Tommy Boy "Fill it up again! Fill it up again! Once it hits your lips, it's so good!" - Frank the Tank (Old School) sql server 2000 millisecond issue nickjoe9015-Mar-07 2:41 nickjoe90 15-Mar-07 2:41  Hello, I was trying to build an application using sql server 2000 and asp.net which would use real time resources, and; I have been facing an issue in which when two transactions occur at the same time, down to hh:mm:ss; then in that case a deadlock occurs and none of the transactions are completed. They remain pending unless u manually goto enterprise manager and change the seconds by making them +/-1 This issue can be reduced considerably if milliseconds can be used hh:mm:ss:fff. Is there a way to implement this? Nikhil Joshi Re: sql server 2000 millisecond issue Pete O'Hanlon16-Mar-07 2:15 Pete O'Hanlon 16-Mar-07 2:15  Deadlocking does not occur because you have a datetime. It occurs because you have two resources which are locking each other. Deja View - the feeling that you've seen this post before.

Last Visit: 31-Dec-99 18:00     Last Update: 28-Apr-24 12:35 Refresh ᐊ Prev1...1631163216331634163516361637163816391640 Next ᐅ

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

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