Recent content by duchovnick

Hi dhulbert , Your code worked. i dont entirely understand it but i'll try to do so later. Thanks a lot !

The same results Borislav.. I guess the table is lost.. And dhulbert how do i know what schema i'm in and which ones is there ? I didnt see any "schema" in query analyzer or server enterprise. Thanks however.

Hi Borislav ! I ran: exec sp_MSForEachDB 'IF OBJECT_ID(''?.dbo.contact1'') IS NOT NULL SELECT ''?'' AS DataBaseName'and recieved: Does it mean the table doesnt exist ? I didnt run the comman as properly? Thanks !

Hi, I'm looking for a table which name is, say, "mytable". It is located in one of my databases but i dont know which one. Is there some "search" command to find a table through its name unknowingly its database ? Thanks.

Thanks !

Hi , This is a "very beginner's question" but i still need help with that. I need to copy a table to a disk or send it to a remote computer via email. Where do i find a "sql server table" on the disk ? What is its extension ? Name ? does it carry the same name given to it in SQL Server on the...

Thanks again, and again, and agian.............

Hi, I'd like to assign the number of rows in my table into a parameter like this: DECLARE @myparam INTEGER SET @myparam=SELECT COUNT(*) FROM myTable or DECLARE @myparam INTEGER SELECT COUNT(*) INTO @mypara FROM myTable but both do not work. Is there a third way that works ? Thanks.

Hi Otto I ran your code changing it into "not like rather than like and it worked OK! thanks A LOT ! HI Earhandfire Either i didnt understand it or it didnt match excactly my need, I couldnt use the PATINDEX keyword. And thank you GMMastros !

Hi, In my table there's a string type column. I want it to contain digits only. I want to see all lines with that string having any other character but a digit. I search a code that will do something like SELECT myStringCol WHERE All characters>='0' AND all_characters<='9' "All charcters" is my...

Hi Alex, Yes, I made it as simple as i could. Thanks a lot .

Hi, I try to work with functions but i end by working with errors. The following is the code to make a function CREATE FUNCTION aaa (@myDigit INTEGER) RETURNS INTEGER AS BEGIN RETURN @myDigit END and the following is the code calling that function: CREATE PROCEDURE bbb @hisDigit INTEGER AS...

Thanks a lot !

Hi ! I'd like to know the decimal value of my number. Say, if i have a "26" i'm looking for the function to return "2". Thanks !

Thanks SkipVought, If this is not easy or fast, why not asp.net or Access ? Why excel ? In other words, there is no other simple way to import sheets to an excel sheet but copy-paste. Isn't it so ? Thanks. It is an important information[bigsmile]