Keyboard Shortcut To Add &&<NULL&&> Value
Apr 20, 2008Is there a keyboard shortcut to add a <NULL> value into a field on my SQL Server 2000 database table, using SQL Server Enterprise Manager
View 1 Replies
ADVERTISEMENT
Keyboard Shortcut To Edit TextBox In Table
Mar 29, 2007Anyone know if there is one and if so what it is? I know I can type directly into a text box in a table, but what if I want to edit the contents? Equivalent of F2 in Excel...
Thanks
Use Of Keyboard
Dec 10, 2007I have SQL Server 2005. Holding shift while pressing the spacebar selects an entire row. I can then use my arrow keys to move about the cells and it selects the entire cell I'm on. I am looking for a way to modify the cell without clicking the mouse. Is there a way to go from entire cell selected to cursor in the cell by using the keyboard? Thanks
View 1 Replies View RelatedKeyboard Shortcuts???
Aug 15, 2005hello friends..
i am a new user to sql,
i was wondering if anyone here will help me to get all the keyboard shortcuts while working on sql...
thankyou
SSRS Keyboard Shortcuts/Usability
Jul 18, 2007
I have been using SSRS2k5 now since early CTP, and one thing that bothers me is the lack of keyboard shortcuts and windows standards.
For example: If I am in the data screen, and want to enter a SQL Query, I cannot use the tab key. So I copy it to SQL Management Studio, but I cant use CTRL-A to select all.
If I am in the layout tab, and want to bold a field, I hit CTRL-B, but that pulls up the breakpoint entry dialog.
If I have a table on a report, and want to add click-thru navigation, I have to:
Right click on cell 1
Click on properties
Select Navigation
Click on Jump to Report
Select the report from the list
Click on parameters
Select parameter 1
Now, if I want a field as the parameter, i can just select from the drop down, but most of the time I am passing parameters from the 1st report to the 2nd report. Then i have to:
Click on the Expression button
Either type the parameter name, or click on it from the list.
Press OK
Repeat number 8 for the number of parameters.
Hit OK.
Hit OK.
REPEAT FOR ALL CELLS
Now, here is the issue... If you have a 20 column table, and have similar click thru functionality, you have to repeat this process for each cell. You cannot multi select. THAT would be a huge timesaver. I would rather set all 20 cells the same, and tweak 1 or 2, rather than kill my wrist mousing thru the above process 20 times. (It hurts, trust me )
These seem like little things, until you are working on 50 reports in a short time frame.
Anyone else find this bothersome?
Is there any improvement on the GUI in the next release?
Thanks!
BobP
Analysis :: Large Tabular Cube With Lots Of Measures - Keyboard Stuck?
Apr 24, 2015large tabular cubes (SSAS 2012 SP2), with lots of calculations, the keyboard seems to be stuck, one cannot type or make any modifications to any measures, even after closing a project.
The only workaround is to completely restart the machine. Using Visual Studio 2010 Shell.
Are there any possibly corruptions or calc limitations that one should be aware of?
Notable that this never happens with any small cubes, but just with the largest cube that we have, that has probably tens of calcs.
Shortcut For QA
Oct 28, 2007When I open QA on my development machine, I almost always go to the same db.Is it possible to create a shortcut for QA which tells it to go to that db,and also provides the login and password? Thanks,Neil
View 4 Replies View RelatedNo Shortcut
Apr 4, 2008I have downloaded and installed this program, trying to get into programming, and i cannot find a shortcut to lauch it... Is there even a shortcut... all i get when i go to Start > All programs is configuration changes... Please help
View 3 Replies View RelatedSQL Select Shortcut
Feb 7, 2000Is there a way to have the results from a query return to a single string? Basically concatenating all values returned to a string?
View 2 Replies View RelatedSql Enterprise Shortcut
Jul 30, 2007Hello,
i have installed sql 2005. i dont see enterprise shortcut anywhere. i even went to mmc console but could not see under 'add..' i could only see SQL configuration shortcut.
what am i doing wrong? :(
Formatfile Shortcut?
Jul 20, 2005I was searching the group for posts on the subject of format files andI came across a message by Erland Sommarskog dated 2003-07-07 withsubject line "Re: BCP Format File". In this example, he used aFORMATFILE where the "prefix length" and "host file data length"fields were both zero for all columns.This convention seems to simplify the task of creating format files.Is this shortcut generally applicable or was it a special case? Doesthis mean that SQL Server can always establish the actual lengths inthe data file by looking up the destination table's schemainformation?
View 3 Replies View RelatedSql Enterprise Shortcut
Jul 31, 2007Hello,
i have installed sql 2005. i dont see enterprise shortcut anywhere. i even went to mmc console but could not see under 'add..' i could only see SQL configuration shortcut.
what am i doing wrong?
Shortcut Key Could Not Work
Feb 26, 2008Private Sub DataGridView1_KeyDown(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyEventArgs) Handles DataGridView1.KeyDown
'Create a new row after pressing enter key
Dim newRow As PSystemDBDataSet._BaseInformation_FTRow
newRow = PSystemDBDataSet._BaseInformation_FT.New_BaseInformation_FTRow
If (e.KeyCode = Keys.Enter) Then
PSystemDBDataSet._BaseInformation_FT.Rows.Add(newRow)
PSystemDBDataSet._BaseInformation_FT.IDColumn.AutoIncrement = True
Else
PSystemDBDataSet._BaseInformation_FT.IDColumn.AutoIncrement = False
End If
'Post the information to final results and tax information using shortcut keys
If (e.Control And e.KeyCode.ToString = "C") Then
MsgBox("This is it")
End If
End Sub
The control C code that i code cannot work. Any ideas??
Keyboard Not Working (backspace And Arrow Keys) When Viewing 2000 DTS Packages From 2005 (backward Compatibility)
May 4, 2006I know my problem is not directly associated w/ SSIS, so please forgive the post here. I figured this would be the "most" appropriate place to post this challenge.
We're attempting to edit a 2000 DTS package in Design mode from within the 2005 SQL Management Studio. To do this we downloaded/installed the following packages from the MS download site:
Microsoft SQL Server 2000 DTS Designer Components
Microsoft SQL Server 2005 Backward Compatibility Components
We're able to open the package in design mode from the Management Studio (Server > Management > Legacy > Data Transformation Services > DTS Package Name). But, when the DTS designer is open, the backspace and arrow keys won't respond in the Management Studio. They begin responding when we close the DTS designer. There are no error messages when we close the DTS designer.
Does anyone know of a fix or a workaround? Any help would be greatly appreciated.
Thanks, Mike
Outer Join Shortcut?
Nov 20, 2007Is this a shortcut for an outer join and if so, why can't I find any info on it?
select id, name
from table1, table2
where id *= id_tbl2
instead of
select tb1.id, tb1.name
from table1 as tb1
outer join table2 as tb2
where tb1.id = tb2.id_tbl2
and what happens in the first example if you try to join more tables?
SQL Server 2008 :: Shortcut Key For Template?
Sep 30, 2015I created a template that I use all the time. Normally I just drag-n-drop from the Template Explorer menu, however I'm wondering if I can assign a shortcut key to have it open? I see you can assign stored procedures and other items, but I can't find where/if I can do this for a template.
View 2 Replies View RelatedSSIS Does Not Open And The Shortcut Is Missing
May 26, 2008I have installed in my machine SQL 2005 with SSIS components, and the Visual studio 2005. The installation process was successfully and all components seem to be on the machine, but I did not find the shortcut to allow me running SSIS environment.
When I re-run the SQL setup the SSIS components is there but is unable to be used.
Any idea how to solve this issue?
Thank you,
Marian
Code Page Conversion Shortcut?
Dec 16, 2005Is there a simple way to avoid having to use a data conversion task to convert Unicode data (from DB2) to ANSI format (for insert to Oracle)?
I'm hoping that there is a way to set the code page property on the OLEDB driver so that it implicitly converts to the format I want instead of having to explicitly force the conversion in the package.
Thoughts? suggestions?
-Clayton
SQL Server 2008 :: Shortcut For Table Variables?
Jul 27, 2015any shortcut strategies for table variables similar to shortcut strategies for temp tables? For example, the following SQL will create a temp table named #MyTable with all of the columns from student and then select the top 10 rows of student data into #MyTable:
select top 10 * into #MyTable from Student
Is there any type of similar or equivalent shortcut for table variables like:
select top 10 * into @MyTable from Student
if I want to select rows from Student into a @MyTable table variable then I need to create the @MyTable table variable with a column structure like a normal table which is more time-consuming than using the temp table approach.
Can I Upload A URL Or Shortcut To The SSRS Home Page?
Jun 26, 2007I have a simple WSS 2.0 SharePoint site for my SSRS deployment which I would like to link my users to from the SSRS home page. Is it possible to add a link or shortcut to my SSRS home page without embedding it inside of a document or report?
View 1 Replies View RelatedProblem With Isnull. Need To Substitute Null If A Var Is Null And Compare It To Null And Return True
Sep 20, 2006Hey. I need to substitute a value from a table if the input var is null. This is fine if the value coming from table is not null. But, it the table value is also null, it doesn't work. The problem I'm getting is in the isnull line which is in Dark green color because @inFileVersion is set to null explicitly and when the isnull function evaluates, value returned from DR.FileVersion is also null which is correct. I want the null=null to return true which is why i set ansi_nulls off. But it doesn't return anything. And the select statement should return something but in my case it returns null. If I comment the isnull statements in the where clause, everything works fine. Please tell me what am I doing wrong. Is it possible to do this without setting the ansi_nulls to off??? Thank you
set ansi_nulls off
go
declare
@inFileName VARCHAR (100),
@inFileSize INT,
@Id int,
@inlanguageid INT,
@inFileVersion VARCHAR (100),
@ExeState int
set @inFileName = 'A0006337.EXE'
set @inFileSize = 28796
set @Id= 1
set @inlanguageid =null
set @inFileVersion =NULL
set @ExeState =0
select Dr.StateID from table1 dR
where
DR.[FileName] = @inFileName
AND DR.FileSize =@inFileSize
AND DR.FileVersion = isnull(@inFileVersion,DR.FileVersion)
AND DR.languageid = isnull(@inlanguageid,null)
AND DR.[ID]= @ID
)
go
set ansi_nulls on
Shortcut To Insert New GUID Into Uniqueidentifier Cell In MSSQL Management Studio Express?
Jul 15, 2006Hi,
anyone knows if there's an easy way to insert new GUIDs into uniqueidentifier cells when editing data in table on Management Studio Express? or Visual Studio 2005 Server Explorer? I can't find a shortcut, and copying from external tools is pain..
I suppose it's possible to build a VB macro in Visual Studio, would it work when editing table data?
Thanks in advance!
Shortcut To Create @table Def From Table Func?
May 29, 2008is there a way to create
"CREATE TABLE @table ( blah blah blah...."
from a table value function?
Reporting Services :: Give Meaning Full Name To Allow Null Value Check Box In Report Parameter Instead Of NULL?
Oct 20, 2015In my report i have CNAME parameter , which allows null value. I checked Allow null value check box in report parameter properties.
when i preview the report , it displays checked NULL check box beside CNAME parameter . I want to give some meaningful name(i.e.ALLCustomers) to this checkbox instead of NULL.
Is it possible through SSRS designer?
Integration Services :: SSIS Insert Non Null Value Into Null Rows
Jul 15, 2015I have a flat file with the following columns
SampleID Rep_Number Product Protein Fat Solids
In the flat file SampleID and Product are populated in the first row only, rest of the rows only have values for Rep_Number, Protein, Fat, Solids.
SampleID and Product are blank for the rest of the rows. So my task is to fill those blank rows with the first row that has the sampleID and Product and load into the table.
Subscription Issue With Null Default Parameter - Key Cannot Be Null
May 3, 2007I have a report that is run on a monthly basis with a default date of null. The stored procedure determines the month-end date that it should use should it be sent a null date.
The report works fine when I tell it to create a history entry; however, when I try to add a subscription it doesn't appear to like the null parameter value. Since I have told the report to have a default value of null it doesn't allow me to enter a value on the subscription page.
Now, I suppose I could remove the parameter altogether from the stored proc, but then the users would never be able to run the report for a previous time period. Can someone explain to me why default values aren't allowed to be used on subscriptions when they seem to work fine for ad hoc and scheduled reports? This is really quite frustrating as most of my reports require a date value and default to null so that the user doesn't have to enter them for the latest data.
An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help
Key cannot be null. Parameter name: key
Returned SQLParam.SqlValue Is {Null} But Can't Test For Null?
Nov 5, 2007I run a stored procedure for which I have a return variable. The stored procedure returns the ID of a row in a table if it exists:
m_sqlCmd.ExecuteScalar();
The m_sqlCmd has been fed an SQLParameter with direction set to output.
When the stored proc returns, I want to test it. Now when there IS a row it returns the ID ok.
When the row doesn't exist, in my watch I have:
m_sqlParam.SqlValue with value {Null}
I can't seem to work out how to test this value out.
I've tried several things but none seem to work.
This line compiles ok, but the following runs into the IF statement as if the SqlValue is null??
if (m_sqlParam.SqlValue != null)....
{
// I'm here!! I thought the watch says this is null???
}
Sorry if this is obvious, but I can't work this one out!!
Any Improvements To This: Cannot Apply Value Null To Property Login: Value Cannot Be Null.
Mar 26, 2007Looks like there was a fix and then I read this fix is not a fix. Does anyone know how this can be rectified? Does it mean that only Windows authentiation is the only way it works. The Software is over 2 years old, there are no excuses.
Cannot Insert The Value NULL Into Column 'OrderID' -- BUT IT IS NOT NULL!
Apr 2, 2007I am getting this error: "Cannot insert the value NULL into column 'OrderID', table 'outman.outman.Contact'; column does not allow nulls. INSERT fails." -- But my value is not null. I did a response.write on it and it show the value. Of course, it would be nice if I could do a breakpoint but that doesn't seem to be working. I'll attach a couple of images below of my code, the error, and the breakpoint error.
Server Error in '/' Application.
Cannot insert the value NULL into column 'OrderID', table 'outman.outman.Contact'; column does not allow nulls. INSERT fails.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: Cannot insert the value NULL into column 'OrderID', table 'outman.outman.Contact'; column does not allow nulls. INSERT fails.Source Error:
Line 89: sContact.Phone = sPhone.Text.Trim
Line 90: sContact.Email = sEmail.Text.Trim
Line 91: sContact.Save()
Line 92:
Line 93: Dim bContact As Contact = New Contact()Source File: F:InetpubwwwrootOutman KnifeCheckout.aspx.vb Line: 91 Stack Trace:
[SqlException (0x80131904): Cannot insert the value NULL into column 'OrderID', table 'outman.outman.Contact'; column does not allow nulls. INSERT fails.]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +857354
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +734966
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1838
System.Data.SqlClient.SqlDataReader.HasMoreRows() +150
System.Data.SqlClient.SqlDataReader.ReadInternal(Boolean setTimeout) +214
System.Data.SqlClient.SqlDataReader.Read() +9
System.Data.SqlClient.SqlCommand.CompleteExecuteScalar(SqlDataReader ds, Boolean returnSqlValue) +39
System.Data.SqlClient.SqlCommand.ExecuteScalar() +148
SubSonic.SqlDataProvider.ExecuteScalar(QueryCommand qry) +209
SubSonic.DataService.ExecuteScalar(QueryCommand cmd) +37
SubSonic.ActiveRecord`1.Save(String userName) +120
SubSonic.ActiveRecord`1.Save() +31
Checkout.btnCheckout_Click(Object sender, EventArgs e) in F:InetpubwwwrootOutman KnifeCheckout.aspx.vb:91
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +105
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +107
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42
Help Altering Database Table From NULL To NOT NULL
Jun 28, 2004I would drop and add the table but the data can't be deleted. So if anyone could help with the statement it would be greatly appreciated. Thanks
View 7 Replies View RelatedSp_option... 'concat Null Yields Null'
Feb 26, 2004I'm trying to set the concat... option to OFF
all the time and in all my databases
I tried this command
USE master
EXEC sp_dboption 'DatabaseName', 'concat null yields null', 'FALSE'
but it doesn't change anything
Select NULL + 'TOTO'
----> NULL
(it should be 'TOTO')
Change Not Null To Null, Default Value To Empty
Aug 3, 2005hi,my structure table in database:Amount float(53) not null default 0when i try to run his script:alter table ABC alter column Amount float(53) nullit can only set the Amount to allow null, but can't set the defaultvalue to empty.anyone know how to set the field to allow null and default set toempty, no value.thanks
View 5 Replies View RelatedDB Engine :: Not Able To Make Column To Null Value From Not Null
May 13, 2015It's giving me an error while I'm trying to change column value from not null to null..
'tblid' table
- Unable to modify table.
Cannot insert the value NULL into column 'ValidID', table 'Xe01.dbo.Tmp_tblid'; column does not allow nulls. INSERT fails.
The statement has been terminated.