Topics
Started by
Posts
Last post
I'm in situation I need to mask data for testing purpose and table do not have primary key to use c…
2 replies
How can we move mdf files from one drive to another with tsql i know how to do with ssms . Thaxxx R…
4 replies
I am getting some problem in using parsename fuction,if my login name is DOMAIN\firstname.lastname,…
1 replies
Calling for TSQL help I need help altering a User Defined Function. WHat I need it to do, is take …
13 replies
Hi i need a query for below scnario [font="Arial Black"]TblMaster[/font] ID NAME 100 James 101 Jose…
2 replies
Hi, I have the following table : Month, Year, TeamNum, Ext, AvgHoldTime,TotSCI, TeamAvgHoldTim…
1 replies
i have this query which runs good on sql server 2000: select col1,col2 from table1,table2 where tab…
19 replies
Hi, I have the following table : Month, Year, TeamNum, Ext, AvgHoldTime,TotSCI, TeamAvgHoldTim…
3 replies
When I run a stored procedure, it asks for the parameters. It remembers the previous supplied parm…
4 replies
I have a table named Courses which contains course information as well as a column named No_Units, …
6 replies
I tried to delete rows from a table with inner join with another table based on keys. But I am unab…
2 replies
I use this to get the date: DECLARE @date as VARCHAR (10) SET @date = convert(varchar,getdate(),103…
4 replies
Hi, Can we load an Excel file in my machine from client to the server using openrowset or opendatas…
1 replies
Hello, I have a query that claculates the average number of days to ship an order. SELECT CAST((b.…
8 replies
Hi guys, does anyone here knows how write a script that can switch between database context? for ex…
3 replies
Viewing 15 topics - 9,916 through 9,930 (of 12,234 total)
You must be logged in to create new topics.