Topics
Started by
Posts
Last post
Morning, I have a data set that contains employee shift data, when they logged in and logged out of…
8 replies
Hi, My update query fails as table gets locked by select query. When i am selecting data it comes a…
3 replies
I have the following query which returns a column name, the database name the column is from, the w…
5 replies
Hi, I'm a beginner in sql server... I need a query to drop all tables and stored procedures from a …
7 replies
Do we get any benefit if we choose to use full text search over like operator. see the below queri…
14 replies
Hello Everyone I am having a real time with this one. --===== If the test table already exists, dr…
13 replies
I have a VLDB VLtable (>300GB table) that I need to move from a development environment to a pro…
2 replies
Hi, has anyone got an example of a Dynamic SQL and what is it and why it would benefit using this? …
18 replies
hi, In my work environment i have faced problem with getting data from two different sql servers li…
3 replies
Hello, I have a problem with selecting rows which I want to update. Select sets a read lock on the …
6 replies
Hi there, Apologies for the elusive subject title. I'm trying to filter only rows on one field onl…
5 replies
I have a question for which I want to know how it works internally Lets consider below query Select…
8 replies
I'm doing a DB review and have always been taught to write updates with a Join like using this synt…
25 replies
I use a merge statement to do incremental load to the table. I use it in a stored procedure that is…
10 replies
hi ALL, ;WITH CTE_BALANCE(SLNO,RECEIVED,PAID,BALANCE) AS ( SELECT slno,received,paid,CAST(I…
8 replies
Viewing 15 topics - 4,591 through 4,605 (of 10,647 total)
You must be logged in to create new topics.