Topics
Started by
Posts
Last post
Declare @Footer varchar(1000) Set @Footer = 'echo RECORD COUNT: >> D:\Work\Test.txt' exec x…
4 replies
I need to write a generic script to change the datatype of any column in it. I want to pass table n…
4 replies
Hi All, I have a table with a PK of type bigint. Let's call the field "ID". The rule I have to f…
4 replies
Hiya guys, I have a table like below: SELECT [Province] ,[Date] ,[Region] ,[Sto…
1 replies
Hi, I am trying to search the possibilities for tuning the query in which it goes for index scan. s…
14 replies
Hi everyone, Is there any way to keep one global temp table, and avoid to be changed by other SQL …
5 replies
Hi everyone I have this stored procedure. CREATE PROCEDURE [dbo].[sp_EE_A_disabled] @inT1 VARCHAR…
3 replies
Is bulk insert only from file -> table? Or can you use bulk insert from table -> table withou…
2 replies
It is common practice to use scope_identity() to return the identity value of a newly inserted reco…
1 replies
Hello All, Please help me with this problem. I have a UI which has some combobox for selecting Data…
3 replies
I have this other scenario: Select a.Id, (Select Sum(b.quantity) from TableB b from b.Id=a.Id) AS …
2 replies
Table 1 OrderID | ProductID | Quantity | Price | Total --------------------------------------------…
5 replies
Please bear with me through what I am being requested to do... it is a bit confusing. I need to gen…
3 replies
i have the following trigger. basically, anytime i update a table, i need to copy the row to a his…
11 replies
Hello comunity -i have the following script based on my invoice table to return by customer the amo…
1 replies
Viewing 15 topics - 8,671 through 8,685 (of 10,635 total)
You must be logged in to create new topics.