Hello all ! How do I set the current schema in SQLServer ? For example: There is a table named "Partner" that was created using schema "foo". I am logged as "bar", that has no privileges but querying the table. I have to put the alias in front of the name of the table as […]
2002-03-21
619 reads
2002-03-20
2 reads
This case statement works without options 1 and 2. DECLARE @w int DECLARE @c varchar(30) DECLARE @v varchar(30) SET @w=3 SET @c='Mr' SET @v='Mr' SELECT m.MRmanMemberID,m.MRmanTitle,MRmanIsFinancial FROM MRman_Main m where case --when @w=1 then MRmanMemberID --when @w=2 then MRmanIsFinancial when @w=3 then MRmanTitle end between @c and @v --change it to SELECT m.MRmanMemberID,m.MRmanTitle,MRmanIsFinancial FROM MRman_Main […]
2002-03-19
Recently I rebooted a production server (Sql 7, NT 4). To my surprise, noone could then connect to that box. (I couldn't even get in locally via Query Analyzer). I noted that the Sql Agent was "starting" -- never running, just starting. With some trouble I killed tha Agent and re-started it manually. Then everyone […]
2002-03-18
475 reads
Hi experts, what is the best way to author and debug the stored procedures with multiple cursors. . or are there any tools to this job easy. . with rgds. Girish Patil
2002-03-14
Hello, I had the following working from an SP for quite some time however I had to reinstall SQL due to a disk failure and now it will not run: EXEC master..xp_cmdshell 'DTSRUN /Fc:\PSP\tmpLoad.dts /NtmpLoad In the output it returns Bad command or file name. It seems almost as though after the install of SQL […]
2002-03-13
12 reads
Usage Table UID, Date, Value I want to return all UIDs and values that are less than today's date. That part is simple. However, there could be multiple records in the record set. I then need to select the max(date) of the records selected. I am just not sure how to write this in T-SQL. […]
2002-03-13
can I issue an alter table/column statement the cahnges an existing int to an identity column?
2002-03-13
2002-03-12
1 reads
When building a cube and setting up aggregations, there is a point in the process in which you set up the number of aggregations, based on either megabyte size, performance increase, or until you stop. It gives you a graph of performance vs size. This size number can get rather large, depending on the # […]
2002-03-12
3 reads
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers