Search results for query: *

Thanks all for the information. Michelle.

Dear sql user, We do have to tables: TblX tBLy Fld_x fLD_Y A A B C We are trying to get a join with the next result: Fld B C Can someone give us a solution? Nice regards, Michelle.

Hello PHV, Thanks a lot, simply the best! Michelle.

Dear readers, is there someone who can give a solution of our problem? We have one table with two fields: an articlenumber and a date field. We try to get the articlenumbers with the oldest date. articlenumber datefld a 2004-01-20 a 2004-04-12 a...

Hello r937, Thanks a lot! Michelle.

Dear sql user, We are trying to make a join of two tables: tblX tbly nr nr 1 3 2 3 4 The result of the join is: 1 2 4 We want to see the result what tbly is missing! Can someone give us the join? Nice regards, Michelle.

Dear MSserver users, Is there any posibility to generate a .sql file as backup voor a database. We are using SQLserver 2000. With the help of "generate SQL script" we can only create a header (fields) of the database. After create database and tables we want to see also the information what...

Dear readers, We are working the first time on MFC. We want to fill a textbox with an integer. Only number keys are correct, if an other key is pressed, the textbox must not be filled with that key. Can Someone give information. Nice regards, Michelle.

we placed these sttings also in the properties of our servers on tabblad connections.

no success michelle.

Dear sqlserver users, We have made a stored procedure to get a table from an other server database. Syntax: Select * into tblX from [sourceServer].sourcedb.dbo.tblX As we do this sentence in the query analyzer, everything goes well. When we place this sentence in a SP a warning goes up about...

We found out that the right syntax is: [from source_server].sourcedb.dbo.tbl_a Thanks a lot for your excellent information Michelle.

Dear SQL users, We are trying to copy a table to an other server database, both servers are in the enterprise manager (2000).Inside the same server it is very easy to copy a table to an other database with the next syntax: Select * into targetdb.dbo.tbl_a from sourcedb.dbo.tbl_a Is it...

Thanks. Michelle.

Dear SQL users, We are trying to copy a table to an other server database, both servers are in the enterprise manager (2000). Inside the same server it is very easy to copy a table to an other database with the next syntax: Select * into targetdb.dbo.tbl_a from sourcedb.dbo.tbl_a Is it...

yhanks for the info. Michelle.

Dear sql server users, Is the any sql syntax for making a backup to a file. For example: backup tbl_backup to "c:\mybackup" If yes, can someone give the syntax? Michelle.

thanks. Michelle.

Thanks for the information but we can't find the debug posibillity. We made a printscreen and placed it under url: http://www.geocities.com/michelle_qw/sqlserver1.jpg Its double language: knippen = cut kopieren = copy verwijderen = delete naam wijzigen = rename eigenschappen: propperties...

Dear users, It is for us a crime to debug a SP. Is there any posibillity to check step by step a SP. We are using sqlserver 2000. Can someone give an indication how the best/easiest way is to debug a SP? Maybe a url? Nice regards, Michelle.