Topics
Started by
Posts
Last post
I have a stored procedure and when I run it First time it creates an execution plan and it takes lo…
13 replies
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
Viewing 15 topics - 4,531 through 4,545 (of 10,635 total)
You must be logged in to create new topics.