Search Results

Showing results 1 to 4 of 4
Search took 0.01 seconds.
Search: Posts Made By: Ramy Mahrous ; Forum: MS SQL and child forums
Forum: MS SQL May 12th, 2009
Replies: 2
Views: 1,050
Posted By Ramy Mahrous
Your thread subject is totally different than the thread itself.
Sknake, they can't use SQL Profiler as
Log file is your eye, you can see through each transaction happened.
Forum: MS SQL Jan 27th, 2009
Replies: 10
Views: 1,764
Posted By Ramy Mahrous
If you traced the SQL Command sent, you'll find it doesn't surround the state within single quotes '
What you need is to modify it
Dim SQLComm = New SqlCommand("SELECT * FROM ViewCustomers('" &...
Forum: MS SQL Jan 20th, 2009
Replies: 6
Views: 781
Posted By Ramy Mahrous
If you have string like that in table "lmlmlaa,lmlmlaa, lmlmlaa, lmlmlaa" and need to return it as table
ID text
1 lmlmlaa
2 lmlmlaa
3 lmlmlaa
4 lmlmlaa
and you may also do some operation...
Forum: MS SQL Oct 14th, 2007
Replies: 3
Views: 2,725
Posted By Ramy Mahrous
Create proc InsertIntoMyTables
@topicID int,
...
...
AS
Insert into Topic values (@topicID,....)
Insert into Reply values(@replyID,....)


or you can use 2 insert statements but DON'T...
Showing results 1 to 4 of 4

 


About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC