Forum: MS SQL May 12th, 2009 |
| Replies: 2 Views: 1,050 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 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 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 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... |