Topics
Started by
Posts
Last post
Hi, I have a basic store procedure which performs updates on several tables, into a transaction. Bu…
10 replies
Hi, I am writing a script to perform a large number of insert statements. Since there is no way to…
17 replies
When executing the following SQL SELECT ASCII(''), ASCII(' '), CASE WHEN ''=SPACE(1) THEN 'TRUE' E…
4 replies
Hello I have a PRODUCTS table which contains 2 fields: old product code and new product code. I als…
5 replies
I have about 2Terabytes of data in which I have to know how may rows are there. I did a SELECT COUN…
9 replies
hi , will u plz give me query for full and diifferential with a scheduled jobs which run automatic…
9 replies
Hi all, If I have a trigger for insert, update, and delete, is there an easy way to find out if the…
8 replies
I have a stored procedue(SP) that I am using to load data from an SSIS process. The SP is dynamic a…
1 replies
Hi, I write a storeprocedure which create a pivot table. But,I can not show the resul set in my rep…
1 replies
HI I have a field called JobRole where in i found few records misspelled like DBA, Adminitrator, NI…
2 replies
I have 2 tables as follows create table ord1 (customer Char (10), division char(3), ovnd_key Ch…
12 replies
history.ix, index_a.ix, index_d_1.ix, index_di_1.ix, index_i_2.ix, index_k_2.ix, index_kl_1.ix, ind…
2 replies
I have the following code: SELECTDISTINCT A.TSOrderType ,A.TSUserType ,A.InternalUserName ,A…
20 replies
As per Books Online -- Another benefit of creating an index on a view is that the optimizer starts …
6 replies
I have a table that has a field called Master_Address that contains both a city and a state (such a…
6 replies
Viewing 15 topics - 10,486 through 10,500 (of 12,230 total)
You must be logged in to create new topics.