Topics
Started by
Posts
Last post
Hi all, I have a table with 2 columns named Depot_Id & Depot_Name, i have to make another tabl…
8 replies
Since it is the default, I don't understand what the point of this option would be.
1 replies
Hi, Can we simulate a truncate trigger? what i need is from which host, who,when truncated a table …
9 replies
Hello everyone, I have database with about 20 tables,and some of them must be populate automaticall…
2 replies
i have two database AgencyDB(primary DB) and AgencyBackupDB(Deleted Info from AgencyDB by user) and…
6 replies
Here Is My DDL Create Table #Tab1 ( Fileid int, FileName Varchar(10), FileType varchar(10) ) go in…
13 replies
CREATE TABLE #AmountOfTime ( DURATIONTIME ) INSERT INTO #AmountOfTime (DURATION ) VALUES…
12 replies
I need to GROUP products by category based on a product rate, but I'm having a hard time joining on…
6 replies
I am unable to understand how variables work: I have created this query that finds all the column n…
4 replies
Hello, I have a query where two tables are joined using a LEFT JOIN. This logical operation is bein…
2 replies
in my case, some source columns values are nulls, i want to populate "NULL" to "0" where isnull([co…
3 replies
OK, need a fast way to compare new data coming in to old data. Both are in seperate tables so we we…
12 replies
I have a column and the values are 0.01 0.2 0.0003 0.00004 0.5 I want output like this 1 2 3 4 5…
1 replies
Im running the following in a batch file sqlcmd -Q "exec dbo.MySproc" -S "MyServer" -d "MyDatabase"…
6 replies
I altered a sql script the other day to handle for a column containing NULLs. Basically, in the ca…
3 replies
Viewing 15 topics - 3,631 through 3,645 (of 10,647 total)
You must be logged in to create new topics.