Hi,I am writing a stored procedure that will import records in one table from many different tables and stored procedures. My problem is that the stored procedures are returning records with only two columns, while my table has 4. I would like to insert some constant values for the missing columns and I don't know […]
2004-06-01
I have a Win2k server with SQL Server 2000 & IIS/ASP3 Most of applications must know who's accessing, in this way I disallow anonimous access in app & allow Integrated Windows Authentication (IIS); In ASP execute this to get logon id and use it for my Sotred Procedures: If InStr(1, Request.ServerVariables("LOGON_USER"), "\") = 0 Then […]
2004-06-01
135 reads
Hi ,Is there a command to show all tables in a database in sql server? Is it possible to see all the tables in all databases using a command? Suppose if i want all the dependencies (like which table is dependent on which) how can I do that?Thanks in advance,Sridhar!!
2004-05-26
1 reads
In your view change the select for the column you want changed to cast( <column> as datetime)
2004-05-25
You can save diagram to a pdf file.Download a pdf printer driver (eg pdf995.exe). Then from EM diagram, select print and select your pdf printer.
2004-05-24
Yes. LEN counts leading blanks (white space), but omits the trailing ones. In case there are persons interested...If you were expecting a count of 8, you needed to use "DATALENGTH" instead of "LEN". Here's the syntax:DECLARE @myString varchar(100) SET @myString = ' TEST ' SELECT DATALENGTH(@myString)
2004-05-24
2004-05-21
3 reads
As you may or may not read in another thread I created...I am having trouble implementing the drill down..I actually have it implemented and it works great in the ReportDesigner preview pane...but when I deploy to the ReportServer and page just reloads itself when I click on the (-) for drill into.Any ideas?
2004-05-20
Tell him that anyone, and that does mean anyone can log into his server and do whatever the heck they want, from dropping all of his databases to removing all the logins...and even better than that they could login using sa, change the sa password to something and then drop all other logins, thus preventing […]
2004-05-12
It sounds as if the actual generation of the Identity is not in the scope of the call to SQL Server. For example (since I know nothing of the structure of the interface) assume a call to a stored procedure that verifies data, then makes a call to a second SP to perform the actual […]
2004-05-11
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
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...
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