Topics
Started by
Posts
Last post
Hi all, My friend ask me the following transaction problem. Consider the following structure of tab…
3 replies
I have a column of data in a table that I need to update and remove the first 2 characters if they …
11 replies
DECLARE @T TABLE(ID INT,NAME VARCHAR(10)) INSERT INTO @T VALUES(1,'PPP') INSERT INTO @T VALUES(2,'…
60 replies
hi all, while executing the plan Maintenance Plan it's giving error like the log for database 'te…
2 replies
All, I have often worked on the below requirement. There are two tables and fetch the record from T…
5 replies
What can I use to find if a string contains a '? I know how to replace the quote with a blank but I…
15 replies
Hi All I have a query that need to Rewrite it without cursor, function or loop to produce same resu…
4 replies
When an index is created with STATISTICS_NORECOMPUTE = OFF, how frequently is the index updated? I…
2 replies
For a customer, I need to load data from excel 2010 spreadsheets into a sql server 2008 r2 database…
6 replies
I have different groups of items, some items are common in groups. I need a query that can combine …
3 replies
Hi, I have a table with syn_trans with below cols: ( Id integer(10), Name varchar2(100), seq_no in…
3 replies
I have following xml: <root> <row value="US"> <col value="00">Jon</col&…
2 replies
can anyone tell me the basic T-SQL for looking up a user and their password in a loging I'm creatin…
5 replies
SELECT Persons.P_id ,Persons.LastName ,Persons.FirstName ,Persons.Address ,Persons.City F…
6 replies
Hi All, I have 58 sequentially run jobs as part of our Database ETL. So, I took the start time …
3 replies
Viewing 15 topics - 4,531 through 4,545 (of 10,636 total)
You must be logged in to create new topics.