I consider CURSOR and TABLE as data types but some one has argued that these are database o…
8 years, 8 months ago
I have 2 tables, Parts & WOParts. Parts keeps a comprehensive list of all parts in all wareho…
I have one table which contines 3 columns they are
in that table…
I'm trying to move specific data from three linked tables on a source database to three tables on a…
By: Gregory Brown
Hi I have 2 Tables as below , I need to delete TableA row with ConsumerID = 99 as my condition wou…
Hi.. When i am trying to insert delta symbol into db, its converted to question mark(?) symbol. I a…
can anyone provide me the equivalent MS SQL server query for the following query:
LOAD DATA L…
8 years, 9 months ago
By: Lynn Pettis
I have table in which date is in varchar format i.e. '29/09/2013'
now I want to ins…
By: Dwain Camps
my client needs a report which shows inventory data.
he executes this report before …
I am still trying to make sense of the whole n' when selecting text or varchar values... Is that so…
How the data are stored in memory.
How the memory is been shared between database and OS operations…
By: Gail Shaw
I'm trying to queryout a result from table to file using BCP in SQL server 2012 . My T-SQL is as…
i want to query for consumer, phone and address, SSN information
consumer table is Consumer
By: Erland Sommarskog
I have to generate a report in which amount should be 13 digits.
e.g 2000- convert it into pa…
This Query is not working please help........
select * from tbl e
INNER JOIN LKUP L ON e.ID=L.LKUP_…
Viewing 15 topics - 2,971 through 2,985 (of 2,994 total)
You must be logged in to create new topics.