Search results for query: *

Thank's very...very... much for your help Bernadette!

Hi there. The situation is like this: -I Have a Database on Server1 and now I want to restore the backup into a new Server2. The problem is the Unicode. I already create a database on Server2 with same devices (sizes and names of course!) but the Sql server interrupt de restore because the...

Hi fruityBoy! First Rule: Do not use TTabel component(Never),instead uses TQuery component. if you will make insert, updates etc set the property "RequestLive" to true. Good lock...luck :-)

Hi! I have many stored procedures in my DB and I need to know how can I intercept a execption like "key vilolation" or "foreign key violation". I'm using ASP pages and when a error occur user can see de error on that page. Any sugestions or tips will be greatiful!

Olá Bob Nachbar! hummm...let's see...I think i have a similar problem one day. Here go's something that can help you: 1-Do not make a "SELECT * FROM MYTABLE", instead use something like this " SELECT ID,DESCRIPTION FROM MYTABLE WHERE DESCRIPTION = 'TEST' " If you are...

Hi Bob! I think that the way you are doing your delete proceses is wrong. Try do this to your stored procedure: CREATE PROCEDURE DeleteTest @arg INT AS BEGIN TRANSACTION DELETE FROM tab3 WHERE tab3.[id]=@arg DELETE FROM tab2 WHERE tab2.[id]=@arg DELETE FROM tab1 WHERE tab1.[id]=@arg...

Welcome Bob Nachbar! Take a look in then Books on line and search for CONVERT functon.I Can remenber right now if a time function exists, but I know about GETDATE() function thats return the date and time. Use the CONVERT function with GETDATE() to extract the time and compare to other time...

Hi there RingoBingo! I Don't if I'm wrong but I think is something is missing in your SQL. 1st line: sExecutestring = "Select * From Carsdb[put a space here]" second line: "Where FirstColumn = '"ListBox.List(Listbox.ListIndex) third line: & "'" "And...

Thanks FoxDev!

"RELLOW" my friend! I'm not a expert but here something that can help you. Sugestion one: Take a look at two stored procedure in books on line: sp_detachdb and sp_atachdb. Sugestion two: Create a database in your new server with same configuration. (same devices sizes -I mean log...

I need to know if it's possible to connect to sql server 7.0 using only ODBC driver ( without SQL server client installed) and if so how can I do that?

Try this my friend! CREATE PROCEDURE MYPROCEDURE @Arg int as SELECT AlarmTypeText, ActionText, Handling FROM AlarmTable WHERE AlarmTypeID = @Arg go Where @arg is a integer parameter(I thinsk it's your case). To call the procedure write the followinf code in your application: EXECUTE...

Rebuilding Indexes Tips<br>Periodically (weekly or monthly) perform a database reorganization on all the indexes on all the tables in your database. This will rebuild the indexes so that the data is no longer fragmented. Fragmented data can cause SQL Server to perform unnecessary data reads...

DreewToo- Yes I try this, but it's to slowly. I Need this is a SQL Statament. Thanks anyway!<br><br>MalcolW- I will try that. Valeu!!( In portuguese means Thanks man! :-) )<br><br>Subuk - Ok,but i need this results in other table!Thanks!

Hi!<br><br>I have a table with this columns:<br><br>ID(identity) QT(Int)<br><br>A need&nbsp;&nbsp;a sql that repeat a row many times is the value &quot;QT&quot; column. Like this:<br><br>ID ¦ QT<br>1&nbsp;&nbsp;¦ 3<br>2&nbsp;&nbsp;¦ 5<br>3&nbsp;&nbsp;¦ 2<br>4&nbsp;&nbsp;¦ 6<br><br>a need a sql...

Somebody have some samples of SQL that return random rows?!

Hi!<br><br>I have a table with this columns<br><br>ID-identity<br>QT- INT<br><br>A need to do a sql that repeat a row many times is &quot;QT&quot; column. Like this:<br><br>Table rows<br>ID ¦ QT<br>1&nbsp;&nbsp;¦ 3<br>2&nbsp;&nbsp;¦ 5<br>3&nbsp;&nbsp;¦ 2<br>4&nbsp;&nbsp;¦ 6<br><br>a need a sql...